trees
320 rows where qSpecies_id = 145
This data as json, CSV (advanced)
| rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 123480 | 129760 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2222 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006381.91218 | 2118496.72963 | 37.7973485646419 | -122.421971438426 | (37.7973485646419, -122.421971438426) | 13 | 9 | 10 | 28858 | 32 | |||
| 124727 | 129838 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 733 Front St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6012789.03405 | 2118594.11911 | 37.7979752365279 | -122.39980784898 | (37.7979752365279, -122.39980784898) | 3 | 1 | 10 | 28860 | 6 | |||
| 125463 | 129830 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 354 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012498.4118 | 2117199.54922 | 37.7941298748476 | -122.400715469043 | (37.7941298748476, -122.400715469043) | 3 | 1 | 10 | 28860 | 4 | |||
| 126383 | 108650 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
| 126645 | 62971 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1833 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 6 | Permit Number 23358 | 6008235.84849 | 2118785.82593 | 37.7982467346621 | -122.415576801855 | (37.7982467346621, -122.415576801855) | 5 | 1 | 10 | 28858 | 21 | |
| 127399 | 200369 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 650 Townsend St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011472.2786 | 2108553.20224 | 37.7703317423487 | -122.403657370911 | (37.7703317423487, -122.403657370911) | 14 | 2 | 9 | 28853 | 34 | |||
| 129360 | 129755 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2407 Clay St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003208.43493 | 2116180.994 | 37.7908106615232 | -122.432786962347 | (37.7908106615232, -122.432786962347) | 13 | 9 | 1 | 29490 | 27 | |||
| 129427 | 142487 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1527 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010095.4595 | 2119399.2703 | 37.8000354558626 | -122.409185274056 | (37.8000354558626, -122.409185274056) | 3 | 1 | 10 | 308 | 23 | |||
| 129470 | 129778 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6012744.14452 | 2119292.42038 | 37.7998901017986 | -122.400012245068 | (37.7998901017986, -122.400012245068) | 3 | 1 | 10 | 28860 | 6 | |||
| 130244 | 17662 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | |||
| 131028 | 96322 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1300X Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6011919 | 2120150.9 | 37.8022012393453 | -122.402927984504 | (37.8022012393453, -122.402927984504) | 3 | 1 | 10 | 28860 | 6 | |||
| 132115 | 129825 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 333 Battery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012609.83657 | 2117389.63944 | 37.7946580314036 | -122.400343282842 | (37.7946580314036, -122.400343282842) | 3 | 1 | 10 | 28860 | 4 | |||
| 132394 | 129794 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011926.85553 | 2120176.70877 | 37.802272542593 | -122.402902616671 | (37.802272542593, -122.402902616671) | 3 | 1 | 10 | 28860 | 6 | |||
| 132689 | 208172 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 154 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994418.09474 | 2099364.41721 | 37.7441342815725 | -122.461980910185 | (37.7441342815725, -122.461980910185) | 1 | 8 | 4 | 59 | 40 | |||
| 132986 | 200334 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 4 | : | Tree | Purchasing Dept 18 | 11/15/1992 12:00:00 AM | 8 | Width 3ft | 6015528.91481 | 2098358.82009 | 37.7425659089002 | -122.388913512973 | (37.7425659089002, -122.388913512973) | 10 | 3 | 8 | 58 | 1 | ||
| 133011 | 49232 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 500 Howard St | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 133100 | 208169 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2590 16th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991440.6028 | 2097828.13237 | 37.7397441663462 | -122.472164360908 | (37.7397441663462, -122.472164360908) | 1 | 8 | 4 | 29491 | 40 | |||
| 133294 | 200351 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6014421.21333 | 2096874.8296 | 37.73842971815 | -122.39263986285 | (37.73842971815, -122.39263986285) | 10 | 3 | 8 | 58 | 1 | |||
| 134027 | 32408 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36942 | 6014160.17669171 | 2116306.66761031 | 37.7917707740774 | -122.394902977188 | (37.7917707740774, -122.394902977188) | 12 | 2 | 9 | 28855 | 6 | |||
| 135729 | 65057 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/1989 12:00:00 AM | 14 | Permit Number 27011 | 6012481.29964 | 2118678.07069 | 37.7981885871952 | -122.400878606079 | (37.7981885871952, -122.400878606079) | 3 | 1 | 10 | 28860 | 6 | ||
| 135786 | 200342 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 779844 | 6015273.79393 | 2098017.0765 | 37.7416134072345 | -122.389771789042 | (37.7416134072345, -122.389771789042) | 10 | 3 | 8 | 58 | 1 | ||
| 136267 | 200360 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1150 Phelps St | 5 | : | Tree | Private 2 | 6 | Width 5ft | 6014196.6239 | 2096573.24629 | 37.737589156905 | -122.393395290662 | (37.737589156905, -122.393395290662) | 10 | 3 | 8 | 58 | 1 | |||
| 136315 | 39385 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2710 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 9 | Permit Number 40925 | 6000567.4477 | 2117199.73959 | 37.7934577323376 | -122.441997780973 | (37.7934577323376, -122.441997780973) | 13 | 9 | 1 | 57 | 27 | ||
| 136630 | 129791 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011942.54079 | 2120045.79904 | 37.8019139721219 | -122.402839125451 | (37.8019139721219, -122.402839125451) | 3 | 1 | 10 | 28860 | 6 | |||
| 137482 | 100694 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 1 | Front Yard : Yard | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | 6 | 2 | 9 | 28855 | 6 | |||
| 139160 | 129789 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011950.17532 | 2119985.5388 | 37.8017489384237 | -122.402808465741 | (37.8017489384237, -122.402808465741) | 3 | 1 | 10 | 28860 | 6 | |||
| 139182 | 106002 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015261.96303 | 2104498.62679 | 37.7594097251897 | -122.390265427813 | (37.7594097251897, -122.390265427813) | 10 | 3 | 8 | 28856 | 29 | |||
| 140150 | 129768 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 489 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6011131.65669 | 2118977.19841 | 37.7989345451634 | -122.405569873672 | (37.7989345451634, -122.405569873672) | 3 | 1 | 10 | 308 | 23 | |||
| 141508 | 200338 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 21 | : | Tree | Private 2 | 9 | Width 2ft | 6015318.39191 | 2098076.99567 | 37.7417804059521 | -122.389621766852 | (37.7417804059521, -122.389621766852) | 10 | 3 | 8 | 58 | 1 | |||
| 141698 | 129750 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2320 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000760.50701 | 2119657.6711 | 37.8002175638503 | -122.441506243943 | (37.8002175638503, -122.441506243943) | 13 | 9 | 1 | 57 | 17 | |||
| 141871 | 108654 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
| 141939 | 15117 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014044.26076 | 2116180.71375 | 37.7914184881275 | -122.395295221814 | (37.7914184881275, -122.395295221814) | 12 | 2 | 9 | 28855 | 6 | |||
| 142001 | 29752 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 532 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3x3 | 6009988.1989 | 2119378.2609 | 37.7999717596155 | -122.409554954705 | (37.7999717596155, -122.409554954705) | 3 | 1 | 10 | 308 | 23 | |||
| 142325 | 228852 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 210 Cumberland St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004131.71858 | 2104545.14122 | 37.7589137859482 | -122.428762589748 | (37.7589137859482, -122.428762589748) | 2 | 4 | 5 | 28862 | 3 | |||
| 143003 | 49225 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 500 Howard St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 143226 | 108037 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1527 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010078.268 | 2119414.52002 | 37.8000763647164 | -122.4092458402 | (37.8000763647164, -122.4092458402) | 3 | 1 | 10 | 308 | 23 | |||||
| 143864 | 142927 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 501 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6011089.2103 | 2118971.3611 | 37.7989161437823 | -122.405716341604 | (37.7989161437823, -122.405716341604) | 3 | 1 | 10 | 308 | 23 | |||
| 144675 | 108036 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1527 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010078.268 | 2119414.52002 | 37.8000763647164 | -122.4092458402 | (37.8000763647164, -122.4092458402) | 3 | 1 | 10 | 308 | 23 | |||||
| 145087 | 106001 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6015262.44728 | 2104479.57944 | 37.7593574521144 | -122.390262422266 | (37.7593574521144, -122.390262422266) | 10 | 3 | 8 | 28856 | 29 | |||
| 145404 | 129841 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 238 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6012688.55113 | 2118531.3338 | 37.7977972409088 | -122.400151139076 | (37.7977972409088, -122.400151139076) | 3 | 1 | 10 | 28860 | 6 | |||
| 148471 | 108655 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
| 149057 | 39386 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2710 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 9 | Permit Number 40925 | 6000600.16704 | 2117204.05937 | 37.7934714577907 | -122.441884880082 | (37.7934714577907, -122.441884880082) | 13 | 9 | 1 | 57 | 27 | ||
| 149502 | 129783 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6012712.81893 | 2119514.81479 | 37.8004989968021 | -122.400136271497 | (37.8004989968021, -122.400136271497) | 3 | 1 | 10 | 28860 | 6 | |||
| 149516 | 49588 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2333 REVISED Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2003 12:00:00 AM | 16 | Permit Number 46464 | 6003709.90767 | 2116419.21464 | 37.7914931831193 | -122.431068901134 | (37.7914931831193, -122.431068901134) | 13 | 9 | 1 | 29490 | 27 | ||
| 150134 | 200363 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 5 | : | Tree | Private 2 | 8 | Width 5ft | 6014137.38405 | 2096492.68968 | 37.7373646735385 | -122.393594476122 | (37.7373646735385, -122.393594476122) | 10 | 3 | 8 | 58 | 1 | |||
| 150172 | 129834 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 733 Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012777.11642 | 2118676.94706 | 37.7982019978752 | -122.399854906882 | (37.7982019978752, -122.399854906882) | 3 | 1 | 10 | 28860 | 6 | |||
| 150606 | 200358 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1150 Phelps St | 3 | : | Tree | Private 2 | 12 | Width 5ft | 6014239.8641 | 2096632.70057 | 37.7377548084229 | -122.393249946754 | (37.7377548084229, -122.393249946754) | 10 | 3 | 8 | 58 | 1 | |||
| 150690 | 129823 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 333 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012601.68821 | 2117444.33686 | 37.7948077631249 | -122.400375321165 | (37.7948077631249, -122.400375321165) | 3 | 1 | 10 | 28860 | 4 | |||
| 151268 | 17647 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 650X Phelps St | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 153275 | 129770 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 80 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012963.29649 | 2119273.7997 | 37.7998511899251 | -122.399252584145 | (37.7998511899251, -122.399252584145) | 3 | 1 | 10 | 28860 | 6 | |||
| 153804 | 108695 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 511 Alvarado St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774625 | 6003049.10666 | 2102687.45843 | 37.7537516993963 | -122.432374086122 | (37.7537516993963, -122.432374086122) | 2 | 4 | 5 | 28862 | 22 | |
| 153980 | 7766 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 325X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006199.471782 | 2111757.686674 | 37.7788345313197 | -122.422123721721 | (37.7788345313197, -122.422123721721) | 7 | 9 | 11 | 28852 | 10 | |||
| 154440 | 208174 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 170 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994830.69157 | 2099413.59203 | 37.7442930488025 | -122.460557814002 | (37.7442930488025, -122.460557814002) | 1 | 8 | 4 | 59 | 40 | |||
| 154946 | 208171 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 158 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994395.10908 | 2099344.18308 | 37.744077400365 | -122.462058921884 | (37.744077400365, -122.462058921884) | 1 | 8 | 4 | 59 | 40 | |||
| 155249 | 100145 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 222X Cumberland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004147.2 | 2104574.7 | 37.7589958235368 | -122.428711154895 | (37.7589958235368, -122.428711154895) | 2 | 4 | 5 | 28862 | 3 | |||||
| 155747 | 129836 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 733 Front St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012782.07244 | 2118635.55361 | 37.7980886176578 | -122.399834849323 | (37.7980886176578, -122.399834849323) | 3 | 1 | 10 | 28860 | 6 | |||
| 155881 | 108653 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 1200x SANSOME ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011928 | 2119969 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | 3 | 1 | 10 | 28860 | 23 | ||||
| 156135 | 129772 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 80 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6012910.45018 | 2119266.99952 | 37.7998295729323 | -122.399434975651 | (37.7998295729323, -122.399434975651) | 3 | 1 | 10 | 28860 | 6 | |||
| 156702 | 200367 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 9 | : | Tree | Private 2 | 17 | Width 5ft | 6014030.85339 | 2096351.68064 | 37.7369715717905 | -122.393952936896 | (37.7369715717905, -122.393952936896) | 10 | 3 | 8 | 58 | 1 | |||
| 157192 | 129757 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2315 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6003704.65718 | 2116456.32668 | 37.7915947858084 | -122.431089717742 | (37.7915947858084, -122.431089717742) | 13 | 9 | 1 | 29490 | 27 | |||
| 158167 | 17659 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | |||
| 158425 | 129805 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6010365.08882 | 2116862.85785 | 37.793086186442 | -122.408073273289 | (37.793086186442, -122.408073273289) | 3 | 1 | 10 | 28857 | 4 | |||
| 158867 | 64146 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 465 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24921 | 6002780.16143913 | 2098575.90057442 | 37.7424470739996 | -122.433010428517 | (37.7424470739996, -122.433010428517) | 2 | 7 | 5 | 63 | 22 | ||
| 160674 | 200336 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 8 | : | Tree | Private 2 | 9 | Width 3ft | 6015493.51667 | 2098314.62088 | 37.7424425848476 | -122.38903282511 | (37.7424425848476, -122.38903282511) | 10 | 3 | 8 | 58 | 1 | |||
| 160698 | 140288 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1960 HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998467.9884 | 2110034.371 | 37.7736636426957 | -122.44874570038 | (37.7736636426957, -122.44874570038) | 15 | 5 | 11 | 29492 | 16 | |||
| 160863 | 129781 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012720.0769 | 2119456.93183 | 37.8003404688016 | -122.40010708848 | (37.8003404688016, -122.40010708848) | 3 | 1 | 10 | 28860 | 6 | |||
| 161885 | 129848 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 103 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012543.75409 | 2118806.63113 | 37.7985450667665 | -122.400671529986 | (37.7985450667665, -122.400671529986) | 3 | 1 | 10 | 28860 | 6 | |||
| 162056 | 228849 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 210 Cumberland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004184.64448 | 2104547.65023 | 37.7589236704217 | -122.428579726085 | (37.7589236704217, -122.428579726085) | 2 | 4 | 5 | 28862 | 3 | |||
| 162059 | 129754 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2407 Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003179.18897 | 2116177.33789 | 37.7907989640458 | -122.432887890589 | (37.7907989640458, -122.432887890589) | 13 | 9 | 1 | 29490 | 27 | |||
| 162528 | 15119 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6014087.04677 | 2116219.82682 | 37.7915282629576 | -122.395149922854 | (37.7915282629576, -122.395149922854) | 12 | 2 | 9 | 28855 | 6 | |||
| 163484 | 208173 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 170 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5994847.17518 | 2099430.14012 | 37.7443394340168 | -122.460502016448 | (37.7443394340168, -122.460502016448) | 1 | 8 | 4 | 59 | 40 | |||
| 163498 | 200355 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 19 | : | Tree | Private 2 | 11 | Width 5ft | 6014345.08354 | 2096773.39107 | 37.7381469605042 | -122.392895989784 | (37.7381469605042, -122.392895989784) | 10 | 3 | 8 | 58 | 1 | |||
| 163545 | 96319 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1300X Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6011919 | 2120150.9 | 37.8022012393453 | -122.402927984504 | (37.8022012393453, -122.402927984504) | 3 | 1 | 10 | 28860 | 6 | |||
| 164665 | 208168 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2590 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5991441.45062 | 2097800.63089 | 37.7396687033598 | -122.472159425416 | (37.7396687033598, -122.472159425416) | 1 | 8 | 4 | 29491 | 40 | |||
| 164754 | 66490 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 280 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2015 12:00:00 AM | 3 | Permit Number 775748 | 6010181.76408 | 2110999.12752 | 37.7769755118394 | -122.408293821201 | (37.7769755118394, -122.408293821201) | 8 | 2 | 9 | 28853 | 34 | |
| 165029 | 129803 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 3ft | 6010302.01456 | 2116853.58579 | 37.7930571958732 | -122.408290860643 | (37.7930571958732, -122.408290860643) | 3 | 1 | 10 | 28857 | 4 | |||
| 165976 | 50616 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 222X Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2004 12:00:00 AM | Permit Number 47216 | 6004288.29588296 | 2104553.28636794 | 37.7589450112214 | -122.42822165267 | (37.7589450112214, -122.42822165267) | 2 | 4 | 5 | 28862 | 3 | |||
| 166454 | 129833 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 354 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012379.77908 | 2117177.70394 | 37.7940632755513 | -122.401124417756 | (37.7940632755513, -122.401124417756) | 3 | 1 | 10 | 28860 | 4 | |||
| 167306 | 200346 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 4 | : | Tree | Private 2 | 9 | Width 4ft | 6014640.20968 | 2097167.32462 | 37.7392450093596 | -122.391903121137 | (37.7392450093596, -122.391903121137) | 10 | 3 | 8 | 58 | 1 | |||
| 168767 | 142327 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1652 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999940 | 2110256 | 37.7743562446262 | -122.443669726916 | (37.7743562446262, -122.443669726916) | 15 | 5 | 11 | 29492 | 16 | |||
| 170707 | 200364 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 6 | : | Tree | Private 2 | 13 | Width 5ft | 6014077.79977 | 2096412.7772 | 37.7371419393345 | -122.393794896313 | (37.7371419393345, -122.393794896313) | 10 | 3 | 8 | 58 | 1 | |||
| 170852 | 51593 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1960 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53890 | 5998519.8939 | 2110042.61 | 37.7736892328814 | -122.448566745533 | (37.7736892328814, -122.448566745533) | 15 | 5 | 11 | 29492 | 16 | |
| 170900 | 100697 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 4 | Front Yard : Yard | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | 6 | 2 | 9 | 28855 | 6 | |||
| 171204 | 129782 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012716.05958 | 2119492.70449 | 37.8004384679276 | -122.400123503796 | (37.8004384679276, -122.400123503796) | 3 | 1 | 10 | 28860 | 6 | |||
| 172376 | 129777 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6012748.89649 | 2119266.86751 | 37.7998202046943 | -122.399994005922 | (37.7998202046943, -122.399994005922) | 3 | 1 | 10 | 28860 | 6 | |||
| 173894 | 114104 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 400x ARBALLO DR | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 3x3 | 5988116 | 2090625 | 37.7197732605649 | -122.48313145165 | (37.7197732605649, -122.48313145165) | 1 | 8 | 4 | 64 | 14 | |||
| 175740 | 32406 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36942 | 6014160.17669171 | 2116306.66761031 | 37.7917707740774 | -122.394902977188 | (37.7917707740774, -122.394902977188) | 12 | 2 | 9 | 28855 | 6 | |||
| 176976 | 129829 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 354 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012523.94966 | 2117203.16491 | 37.7941412269928 | -122.400627358876 | (37.7941412269928, -122.400627358876) | 3 | 1 | 10 | 28860 | 4 | |||
| 178568 | 129817 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 241 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012643.50693 | 2117148.0023 | 37.793996430738 | -122.400209799159 | (37.793996430738, -122.400209799159) | 4 | 1 | 10 | 28860 | 6 | |||
| 178768 | 15113 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6013991.51326 | 2116128.24604 | 37.7912714903321 | -122.395474051105 | (37.7912714903321, -122.395474051105) | 12 | 2 | 9 | 28855 | 6 | |||
| 178875 | 129839 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 238 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012727.89407 | 2118536.52905 | 37.7978136994111 | -122.400015365729 | (37.7978136994111, -122.400015365729) | 3 | 1 | 10 | 28860 | 6 | |||
| 179889 | 200347 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 9 | : | Tree | Private 2 | 11 | Width 4ft | 6014556.03183 | 2097054.78425 | 37.7389313231291 | -122.392186304173 | (37.7389313231291, -122.392186304173) | 10 | 3 | 8 | 58 | 1 | |||
| 180124 | 129818 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 241 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012648.53437 | 2117119.11483 | 37.7939173929283 | -122.400190373809 | (37.7939173929283, -122.400190373809) | 4 | 1 | 10 | 28860 | 6 | |||
| 180476 | 129773 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 80 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012883.50017 | 2119263.61 | 37.7998187639863 | -122.399527995233 | (37.7998187639863, -122.399527995233) | 3 | 1 | 10 | 28860 | 6 | |||
| 180495 | 200337 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 9 | : | Tree | Private 2 | 10 | Width 4ft | 6015484.25752 | 2098301.13552 | 37.7424050435698 | -122.389063899405 | (37.7424050435698, -122.389063899405) | 10 | 3 | 8 | 58 | 1 | |||
| 180511 | 200352 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 16 | : | Tree | Private 2 | 14 | Width 5ft | 6014405.80816 | 2096853.92235 | 37.7383714555731 | -122.392691664697 | (37.7383714555731, -122.392691664697) | 10 | 3 | 8 | 58 | 1 | |||
| 182062 | 100700 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 200X 01st St | 7 | Front Yard : Yard | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | 6 | 2 | 9 | 28855 | 6 | |||
| 182143 | 227934 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1731 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005814.85418 | 2107243.32997 | 37.7664174935056 | -122.423133300469 | (37.7664174935056, -122.423133300469) | 8 | 4 | 5 | 28853 | 19 | |||
| 182985 | 200349 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 11 | : | Tree | Private 2 | 8 | Width 4ft | 6014526.62987 | 2097016.75387 | 37.7388252669773 | -122.392285304228 | (37.7388252669773, -122.392285304228) | 10 | 3 | 8 | 58 | 1 | |||
| 183416 | 50615 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 222X Cumberland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2004 12:00:00 AM | Permit Number 47216 | 6004288.29588296 | 2104553.28636794 | 37.7589450112214 | -122.42822165267 | (37.7589450112214, -122.42822165267) | 2 | 4 | 5 | 28862 | 3 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );