trees
228 rows where qCaretaker_id = 2 and qSpecies_id = 59 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1248 | 260958 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 6 | 1 | 54 | 31 | ||||
14173 | 140080 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6000726.8608 | 2112462.5832 | 37.7804598090154 | -122.441106178881 | (37.7804598090154, -122.441106178881) | 15 | 5 | 1 | 29490 | 41 | |||
15414 | 96980 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
17671 | 260957 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 6 | 1 | 54 | 31 | ||||
37565 | 125723 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | Width 4ft | 6003539.04242 | 2117994.60754 | 37.7958091249389 | -122.431772623315 | (37.7958091249389, -122.431772623315) | 13 | 9 | 1 | 57 | 17 | |||
47415 | 125722 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 43 | Width 4ft | 6003540.89789 | 2117978.17849 | 37.7957641201722 | -122.431765029446 | (37.7957641201722, -122.431765029446) | 13 | 9 | 1 | 57 | 17 | |||
49152 | 125724 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 4ft | 6003536.06003 | 2118009.60299 | 37.7958501295278 | -122.431784014136 | (37.7958501295278, -122.431784014136) | 13 | 9 | 1 | 57 | 17 | |||
59791 | 96983 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | Permit Number 25529 | 6003522.34271 | 2118089.29041 | 37.796068153086 | -122.431837171257 | (37.796068153086, -122.431837171257) | 13 | 9 | 1 | 57 | 17 | |||
63685 | 135663 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5996346.46825 | 2114626.15487 | 37.7861499232377 | -122.456416418905 | (37.7861499232377, -122.456416418905) | 11 | 6 | 1 | 54 | 31 | |||
74255 | 96979 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
78015 | 135666 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3001 Divisadero St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 42 | Width 9ft | 6000472.49775 | 2118651.89467 | 37.7974395562567 | -122.442430617479 | (37.7974395562567, -122.442430617479) | 13 | 9 | 1 | 57 | 17 | |||
91372 | 96982 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 41 | Permit Number 25529 | 6003530.13563 | 2118059.26209 | 37.7959861448054 | -122.431808061115 | (37.7959861448054, -122.431808061115) | 13 | 9 | 1 | 57 | 17 | |||
123430 | 96984 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
126030 | 140081 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104 Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000726.184 | 2112472.3974 | 37.7804867177527 | -122.441109224562 | (37.7804867177527, -122.441109224562) | 15 | 5 | 1 | 29490 | 41 | |||
138606 | 135664 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5996336.60886 | 2114624.27331 | 37.7861441909595 | -122.456450393471 | (37.7861441909595, -122.456450393471) | 11 | 6 | 1 | 54 | 31 | |||
152832 | 140079 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000729.2298 | 2112451.4153 | 37.7804292797496 | -122.441097181955 | (37.7804292797496, -122.441097181955) | 15 | 5 | 1 | 29490 | 41 | |||
154261 | 140083 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6000722.7998 | 2112497.1022 | 37.7805543580623 | -122.441122705034 | (37.7805543580623, -122.441122705034) | 15 | 5 | 1 | 29490 | 41 | |||
154598 | 135665 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 5996326.40952 | 2114621.95963 | 37.7861372526689 | -122.456485512902 | (37.7861372526689, -122.456485512902) | 11 | 6 | 1 | 54 | 31 | |||
156312 | 104131 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 6003522.94878 | 2118100.93382 | 37.7961001572485 | -122.431835905912 | (37.7961001572485, -122.431835905912) | 13 | 9 | 1 | 57 | 17 | ||||
166467 | 125725 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | Width 4ft | 6003533.81623 | 2118024.94741 | 37.7958921341649 | -122.431792874238 | (37.7958921341649, -122.431792874238) | 13 | 9 | 1 | 57 | 17 | |||
171267 | 96981 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
187717 | 96978 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
4419 | 260950 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 460x Davis Ct | 2 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6013239 | 2118152 | 37.7967863568579 | -122.398219792292 | (37.7967863568579, -122.398219792292) | 3 | 1 | 10 | 28860 | 6 | ||||
12617 | 249797 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 199 Chestnut St | 5 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6010839.41961 | 2121064.72571 | 37.8046500380318 | -122.406728311085 | (37.8046500380318, -122.406728311085) | 3 | 1 | 10 | 308 | 23 | |||
13002 | 260949 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 460x Davis Ct | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6013239 | 2118152 | 37.7967863568579 | -122.398219792292 | (37.7967863568579, -122.398219792292) | 3 | 1 | 10 | 28860 | 6 | ||||
24272 | 117475 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1200x MONTGOMERY ST | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 6011580 | 2119440 | 37.800230345698 | -122.404051036068 | (37.800230345698, -122.404051036068) | 3 | 1 | 10 | 308 | 23 | |||||
26017 | 109376 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 3 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
27833 | 249798 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 199 Chestnut St | 6 | Front Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6010832.73906 | 2121063.1197 | 37.8046452545423 | -122.406751316639 | (37.8046452545423, -122.406751316639) | 3 | 1 | 10 | 308 | 23 | |||
35274 | 249899 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1497 Montgomery St | 3 | Side Yard : Yard | Tree | Private 2 | 17 | Width 0ft | 6011381.09793 | 2120471.14228 | 37.8030504957345 | -122.404811954701 | (37.8030504957345, -122.404811954701) | 3 | 1 | 10 | 28860 | 6 | |||
42959 | 117474 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1200x MONTGOMERY ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 6011580 | 2119440 | 37.800230345698 | -122.404051036068 | (37.800230345698, -122.404051036068) | 3 | 1 | 10 | 308 | 23 | |||||
64778 | 109377 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 4 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
66019 | 249894 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 230 Greenwich St | 30 | Back Yard : Yard | Tree | Private 2 | 24 | Width 0ft | 6011403.76038 | 2120447.63681 | 37.8029872221404 | -122.404731874586 | (37.8029872221404, -122.404731874586) | 3 | 1 | 10 | 28860 | 6 | |||
77598 | 249893 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 230 Greenwich St | 29 | Back Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6011394.80053 | 2120441.53452 | 37.8029699659579 | -122.404762450627 | (37.8029699659579, -122.404762450627) | 3 | 1 | 10 | 28860 | 6 | |||
78217 | 249800 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 199 Chestnut St | 8 | Front Yard : Yard | Tree | Private 2 | 16 | Width 0ft | 6010811.58408 | 2121055.18857 | 37.8046222939481 | -122.406823966551 | (37.8046222939481, -122.406823966551) | 3 | 1 | 10 | 308 | 23 | |||
84676 | 109375 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 2 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
86942 | 103067 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 255 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2014 12:00:00 AM | 3 | 6x6 | Permit Number 769997 | 6012256.1 | 2118721.6 | 37.7982955442476 | -122.401660929382 | (37.7982955442476, -122.401660929382) | 3 | 1 | 10 | 28860 | 6 | |
95955 | 117473 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201x MONTGOMERY ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 6011733 | 2119731 | 37.8010379082809 | -122.403542078239 | (37.8010379082809, -122.403542078239) | 3 | 1 | 10 | 308 | 23 | |||||
98514 | 249895 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 230 Greenwich St | 31 | Back Yard : Yard | Tree | Private 2 | 18 | Width 0ft | 6011395.76102 | 2120447.38073 | 37.8029860719045 | -122.404759538639 | (37.8029860719045, -122.404759538639) | 3 | 1 | 10 | 28860 | 6 | |||
114094 | 117472 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201x MONTGOMERY ST | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 6011733 | 2119731 | 37.8010379082809 | -122.403542078239 | (37.8010379082809, -122.403542078239) | 3 | 1 | 10 | 308 | 23 | |||||
137889 | 109378 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 5 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
142161 | 249896 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 230 Greenwich St | 32 | Back Yard : Yard | Tree | Private 2 | 24 | Width 0ft | 6011386.30387 | 2120437.51769 | 37.8029584618196 | -122.404791570676 | (37.8029584618196, -122.404791570676) | 3 | 1 | 10 | 28860 | 6 | |||
150059 | 249897 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1497 Montgomery St | 5 | Side Yard : Yard | Tree | Private 2 | 20 | Width 0ft | 6011384.61876 | 2120458.08201 | 37.8030148322229 | -122.404798850701 | (37.8030148322229, -122.404798850701) | 3 | 1 | 10 | 28860 | 6 | |||
155569 | 109374 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 1 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
16015 | 220524 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 110 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1974 12:00:00 AM | 38 | Width 3ft | Permit Number 14125 | 6003373.13767 | 2108706.4584 | 37.7702967937804 | -122.431683217203 | (37.7702967937804, -122.431683217203) | 15 | 9 | 11 | 29492 | 10 | |
74379 | 246918 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 3ft | 5997638.10514 | 2107510.95773 | 37.7666875068428 | -122.451434340243 | (37.7666875068428, -122.451434340243) | 15 | 5 | 11 | 29492 | 9 | |||
83859 | 139060 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1455 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 39 | Width 0ft | 5999670.4186 | 2113895.7324 | 37.7843346353185 | -122.444863945857 | (37.7843346353185, -122.444863945857) | 15 | 6 | 11 | 29490 | 31 | |||
96656 | 248613 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 5997648.1233 | 2107524.615 | 37.766725579885 | -122.451400674442 | (37.766725579885, -122.451400674442) | 15 | 5 | 11 | 29492 | 9 | |||
102733 | 248614 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5997650.5459 | 2107506.4452 | 37.7666758289672 | -122.451390984496 | (37.7666758289672, -122.451390984496) | 15 | 5 | 11 | 29492 | 9 | |||
145764 | 246917 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 5997637.48509 | 2107521.28402 | 37.766715824697 | -122.451437229753 | (37.766715824697, -122.451437229753) | 15 | 5 | 11 | 29492 | 9 | |||
148446 | 53540 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 308 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/1969 12:00:00 AM | 24 | Permit Number 6452 | 5994656.44022 | 2113376.70713 | 37.7826221103339 | -122.462172779062 | (37.7826221103339, -122.462172779062) | 11 | 6 | 2 | 54 | 11 | ||
193664 | 121867 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 382 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990303.78145 | 2112825.75308 | 37.7808577673116 | -122.477190674715 | (37.7808577673116, -122.477190674715) | 11 | 6 | 2 | 55 | 26 | |||
55125 | 98312 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 160 Stanford Heights Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5998064.7 | 2096544.4 | 37.7366004632858 | -122.449168689734 | (37.7366004632858, -122.449168689734) | 9 | 7 | 4 | 59 | 40 | |||||
109416 | 212850 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 32 Malta Dr | 32 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 3ft | 5999489.82188 | 2096117.1264 | 37.7355086796695 | -122.444210754429 | (37.7355086796695, -122.444210754429) | 9 | 7 | 4 | 63 | 40 | |||
140069 | 212849 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992374.69215 | 2098410.70315 | 37.7413977704887 | -122.468977090726 | (37.7413977704887, -122.468977090726) | 1 | 8 | 4 | 59 | 40 | |||
111973 | 247225 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 754 Duboce Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6002109.57301 | 2108309.81574 | 37.7691360073432 | -122.4360254903 | (37.7691360073432, -122.4360254903) | 15 | 5 | 5 | 29492 | 9 | ||||
142556 | 256880 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2701 Alemany Blvd | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5997600 | 2087902 | 37.7128438731446 | -122.450152604107 | (37.7128438731446, -122.450152604107) | 9 | 7 | 6 | 28861 | 25 | ||||
3136 | 234897 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6009692.09622 | 2096449.43711 | 37.7369979030329 | -122.408960917621 | (37.7369979030329, -122.408960917621) | 10 | 7 | 7 | 28859 | 2 | ||||
19126 | 234903 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6009692.65358 | 2096419.54828 | 37.7369158659624 | -122.408956882348 | (37.7369158659624, -122.408956882348) | 10 | 7 | 7 | 28859 | 2 | ||||
19786 | 248125 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 5 | Front Yard : Yard | Tree | Private 2 | 7 | 6010397.04877 | 2099427.00914 | 37.7452131370768 | -122.406733349058 | (37.7452131370768, -122.406733349058) | 2 | 7 | 7 | 28859 | 2 | ||||
20810 | 248173 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 218 Esmeralda Ave | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 6007303.95131 | 2098726.55555 | 37.743116300271 | -122.417379150221 | (37.743116300271, -122.417379150221) | 2 | 7 | 7 | 28859 | 2 | ||||
21087 | 234873 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6010726.23893 | 2100862.83367 | 37.7491740112676 | -122.405696174457 | (37.7491740112676, -122.405696174457) | 10 | 4 | 7 | 28859 | 19 | ||||
23378 | 234893 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 7 | Front Yard : Yard | Tree | Private 2 | 17 | 6010664.01336 | 2100659.8191 | 37.7486130978165 | -122.405897053323 | (37.7486130978165, -122.405897053323) | 2 | 7 | 7 | 28859 | 2 | ||||
24893 | 234872 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | 6010732.42318 | 2100864.09022 | 37.7491778073048 | -122.405674877619 | (37.7491778073048, -122.405674877619) | 10 | 4 | 7 | 28859 | 19 | ||||
34861 | 234884 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6010535.25533 | 2100821.90556 | 37.7490509498578 | -122.406353718268 | (37.7490509498578, -122.406353718268) | 10 | 4 | 7 | 28859 | 19 | ||||
35297 | 248111 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 1 | Side Yard : Yard | Tree | Private 2 | 24 | 6010383.71107 | 2099443.85944 | 37.7452586580609 | -122.406780656096 | (37.7452586580609, -122.406780656096) | 2 | 7 | 7 | 28859 | 2 | ||||
37570 | 248117 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 7 | Side Yard : Yard | Tree | Private 2 | 6 | 6010378.29952 | 2099414.5285 | 37.7451778188963 | -122.406797301657 | (37.7451778188963, -122.406797301657) | 2 | 7 | 7 | 28859 | 2 | ||||
40536 | 248113 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 3 | Side Yard : Yard | Tree | Private 2 | 17 | 6010385.30327 | 2099441.28079 | 37.7452516667373 | -122.406774968811 | (37.7452516667373, -122.406774968811) | 2 | 7 | 7 | 28859 | 2 | ||||
40830 | 248124 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 4 | Front Yard : Yard | Tree | Private 2 | 10 | 6010394.26479 | 2099420.04988 | 37.7451938726969 | -122.406742485274 | (37.7451938726969, -122.406742485274) | 2 | 7 | 7 | 28859 | 2 | ||||
47166 | 234889 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 3 | Front Yard : Yard | Tree | Private 2 | 25 | 6010620.28496 | 2100677.87035 | 37.7486602169168 | -122.406049537871 | (37.7486602169168, -122.406049537871) | 2 | 7 | 7 | 28859 | 2 | ||||
49707 | 234909 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6009677.77783 | 2096362.72232 | 37.7367590008107 | -122.409004306302 | (37.7367590008107, -122.409004306302) | 10 | 7 | 7 | 28859 | 2 | |||
52513 | 234888 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 2 | Front Yard : Yard | Tree | Private 2 | 33 | 6010611.763 | 2100694.95228 | 37.7487066435094 | -122.406080210127 | (37.7487066435094, -122.406080210127) | 2 | 7 | 7 | 28859 | 2 | ||||
56401 | 234907 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6009682.36778 | 2096375.42259 | 37.7367941301369 | -122.408989332604 | (37.7367941301369, -122.408989332604) | 10 | 7 | 7 | 28859 | 2 | |||
58340 | 234904 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6009689.76503 | 2096405.45865 | 37.7368770170648 | -122.408965875569 | (37.7368770170648, -122.408965875569) | 10 | 7 | 7 | 28859 | 2 | ||||
66581 | 234875 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6010693.4536 | 2100854.39807 | 37.7491490155229 | -122.405808953037 | (37.7491490155229, -122.405808953037) | 10 | 4 | 7 | 28859 | 19 | ||||
76548 | 234891 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 5 | Front Yard : Yard | Tree | Private 2 | 12 | 6010619.31212 | 2100642.55964 | 37.7485632070257 | -122.406050414705 | (37.7485632070257, -122.406050414705) | 2 | 7 | 7 | 28859 | 2 | ||||
77949 | 248121 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6010387.39582 | 2099398.52057 | 37.7451343735684 | -122.406764720109 | (37.7451343735684, -122.406764720109) | 2 | 7 | 7 | 28859 | 2 | ||||
78172 | 234882 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6010551.46993 | 2100825.34606 | 37.7490613037485 | -122.406297890147 | (37.7490613037485, -122.406297890147) | 10 | 4 | 7 | 28859 | 19 | ||||
80514 | 248115 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 5 | Side Yard : Yard | Tree | Private 2 | 7 | 6010382.66989 | 2099427.30215 | 37.7452131370921 | -122.406783089664 | (37.7452131370921, -122.406783089664) | 2 | 7 | 7 | 28859 | 2 | ||||
80814 | 248172 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 218 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6007302.01446 | 2098729.32454 | 37.7431237943252 | -122.417386043537 | (37.7431237943252, -122.417386043537) | 2 | 7 | 7 | 28859 | 2 | ||||
83040 | 234899 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6009698.94501 | 2096439.52165 | 37.7369710609585 | -122.408936538802 | (37.7369710609585, -122.408936538802) | 10 | 7 | 7 | 28859 | 2 | ||||
87689 | 248119 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 9 | Side Yard : Yard | Tree | Private 2 | 18 | 6010375.35501 | 2099399.67941 | 37.7451368817742 | -122.406806436993 | (37.7451368817742, -122.406806436993) | 2 | 7 | 7 | 28859 | 2 | ||||
89186 | 248114 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 4 | Side Yard : Yard | Tree | Private 2 | 15 | 6010381.0463 | 2099434.05906 | 37.7452315992509 | -122.406789179902 | (37.7452315992509, -122.406789179902) | 2 | 7 | 7 | 28859 | 2 | ||||
97525 | 234890 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 4 | Front Yard : Yard | Tree | Private 2 | 14 | 6010623.85334 | 2100666.44158 | 37.7486290355994 | -122.406036393361 | (37.7486290355994, -122.406036393361) | 2 | 7 | 7 | 28859 | 2 | ||||
99978 | 234895 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3255x 24th St | 6 | Side Yard : Cutout | Tree | Private 2 | 40 | Width 10ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
104444 | 248116 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 6 | Side Yard : Yard | Tree | Private 2 | 9 | 6010379.57479 | 2099419.47211 | 37.745191464328 | -122.406793240314 | (37.745191464328, -122.406793240314) | 2 | 7 | 7 | 28859 | 2 | ||||
110194 | 234887 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6010600.22161 | 2100713.10517 | 37.7487558418292 | -122.406121399085 | (37.7487558418292, -122.406121399085) | 2 | 7 | 7 | 28859 | 2 | ||||
111007 | 234892 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 6 | Front Yard : Yard | Tree | Private 2 | 18 | 6010653.55518 | 2100656.49907 | 37.7486033968442 | -122.40593298392 | (37.7486033968442, -122.40593298392) | 2 | 7 | 7 | 28859 | 2 | ||||
111134 | 234874 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6010703.27515 | 2100855.87105 | 37.7491536092595 | -122.40577509356 | (37.7491536092595, -122.40577509356) | 10 | 4 | 7 | 28859 | 19 | ||||
113044 | 248122 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 2 | Front Yard : Yard | Tree | Private 2 | 14 | 6010390.78091 | 2099407.55033 | 37.7451593567256 | -122.406753651253 | (37.7451593567256, -122.406753651253) | 2 | 7 | 7 | 28859 | 2 | ||||
114900 | 234880 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6010577.49101 | 2100830.77043 | 37.7490776534227 | -122.406208290698 | (37.7490776534227, -122.406208290698) | 10 | 4 | 7 | 28859 | 19 | ||||
115793 | 234881 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 6010567.07854 | 2100828.40228 | 37.749070568567 | -122.406244130469 | (37.749070568567, -122.406244130469) | 10 | 4 | 7 | 28859 | 19 | ||||
117375 | 234878 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6010615.53478 | 2100839.32379 | 37.7491032670092 | -122.406077336824 | (37.7491032670092, -122.406077336824) | 10 | 4 | 7 | 28859 | 19 | ||||
121047 | 234886 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 6010522.64734 | 2100819.38367 | 37.7490433200014 | -122.406397139344 | (37.7490433200014, -122.406397139344) | 10 | 4 | 7 | 28859 | 19 | ||||
121304 | 234879 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 6010587.10266 | 2100832.95642 | 37.7490841933025 | -122.406175207346 | (37.7490841933025, -122.406175207346) | 10 | 4 | 7 | 28859 | 19 | ||||
122830 | 234901 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6009690.97834 | 2096436.62736 | 37.7369626675976 | -122.408963879105 | (37.7369626675976, -122.408963879105) | 10 | 7 | 7 | 28859 | 2 | ||||
125376 | 234906 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6009686.02423 | 2096384.83518 | 37.7368201799074 | -122.408977354526 | (37.7368201799074, -122.408977354526) | 10 | 7 | 7 | 28859 | 2 | |||
125984 | 234908 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6009679.55053 | 2096368.23252 | 37.7367742299367 | -122.408998565949 | (37.7367742299367, -122.408998565949) | 10 | 7 | 7 | 28859 | 2 | |||
126542 | 248127 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 7 | Front Yard : Yard | Tree | Private 2 | 18 | 6010399.6226 | 2099438.06548 | 37.7452436393873 | -122.406725228187 | (37.7452436393873, -122.406725228187) | 2 | 7 | 7 | 28859 | 2 | ||||
131745 | 234883 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 6010542.26084 | 2100823.35069 | 37.7490553097539 | -122.406329594845 | (37.7490553097539, -122.406329594845) | 10 | 4 | 7 | 28859 | 19 | ||||
142091 | 234885 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6010529.65259 | 2100820.82881 | 37.7490476799194 | -122.406373016826 | (37.7490476799194, -122.406373016826) | 10 | 4 | 7 | 28859 | 19 |
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) );