trees

228 rows where qCaretaker_id = 2 and qSpecies_id = 59 sorted by YCoord descending

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 228 ✖
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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
67051 113134 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 50 03rd St 2 Front Yard : Yard Tree Private 2   09/09/2015 12:00:00 AM   10x10 Permit Number 775860 6011822.9 2114512.2 37.7867133521926 -122.402863731968 (37.7867133521926, -122.402863731968) 12 2 9 28853 6
184663 113133 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 50 03rd St 1 Front Yard : Yard Tree Private 2   09/09/2015 12:00:00 AM   10x10 Permit Number 775860 6011822.9 2114512.2 37.7867133521926 -122.402863731968 (37.7867133521926, -122.402863731968) 12 2 9 28853 6
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
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
93639 91056 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 750 FOLSOM ST 6 Sidewalk: Curb side : Cutout Tree Private 2       6x4   6012569 2113092 37.7828554456154 -122.400182606689 (37.7828554456154, -122.400182606689) 6 2 9 28853 34
148445 91057 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 750 FOLSOM ST 7 Sidewalk: Curb side : Cutout Tree Private 2     25 6x4   6012569 2113092 37.7828554456154 -122.400182606689 (37.7828554456154, -122.400182606689) 6 2 9 28853 34
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
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
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
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
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
100061 195998 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 2 Sidewalk: Property side : Yard Tree Private 2     18     6016075.49067 2110714.30849 37.7765217283366 -122.387885542896 (37.7765217283366, -122.387885542896) 14 3 9 310 20
175828 195997 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 1 Sidewalk: Property side : Yard Tree Private 2     23     6016094.12732 2110713.51522 37.776520582607 -122.387821017432 (37.776520582607, -122.387821017432) 14 3 9 310 20
10408 195999 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 3 Sidewalk: Property side : Yard Tree Private 2     16     6016051.5903 2110711.60548 37.7765129824099 -122.387968033214 (37.7765129824099, -122.387968033214) 14 3 9 310 20
32582 196000 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 4 Sidewalk: Property side : Yard Tree Private 2     17     6016029.90141 2110710.35403 37.7765083446095 -122.38804297462 (37.7765083446095, -122.38804297462) 14 3 9 310 20
137112 196001 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 5 Sidewalk: Property side : Yard Tree Private 2     4     6016008.12939 2110708.52586 37.7765021186104 -122.388118163334 (37.7765021186104, -122.388118163334) 14 3 9 310 20
185058 196002 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 6 Sidewalk: Property side : Yard Tree Private 2     18     6015985.51722 2110706.09628 37.7764941946745 -122.388196216398 (37.7764941946745, -122.388196216398) 14 3 9 310 20
121735 196003 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 7 Sidewalk: Property side : Yard Tree Private 2     16     6015962.95079 2110705.93329 37.7764924967751 -122.388274269443 (37.7764924967751, -122.388274269443) 14 3 9 310 20
191532 196004 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 8 Sidewalk: Property side : Yard Tree Private 2     16     6015940.35109 2110704.12187 37.7764862707572 -122.388352322497 (37.7764862707572, -122.388352322497) 14 3 9 310 20
87935 196005 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 9 Sidewalk: Property side : Yard Tree Private 2     15     6015919.22066 2110703.31156 37.7764828749315 -122.38842536276 (37.7764828749315, -122.38842536276) 14 3 9 310 20
80958 196006 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 10 Sidewalk: Property side : Yard Tree Private 2     14     6015895.59891 2110702.13918 37.7764783468376 -122.388506996001 (37.7764783468376, -122.388506996001) 14 3 9 310 20
81978 196007 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 11 Sidewalk: Property side : Yard Tree Private 2     15     6015874.48096 2110701.94702 37.7764766489106 -122.388580036236 (37.7764766489106, -122.388580036236) 14 3 9 310 20
145197 196008 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 12 Sidewalk: Property side : Yard Tree Private 2     15     6015854.16157 2110700.296 37.7764709894889 -122.388650212137 (37.7764709894889, -122.388650212137) 14 3 9 310 20
126204 196009 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 13 Sidewalk: Property side : Yard Tree Private 2     16     6015830.73834 2110698.70731 37.776465329147 -122.388731129538 (37.776465329147, -122.388731129538) 14 3 9 310 20
37957 196010 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 14 Sidewalk: Property side : Yard Tree Private 2     17     6015807.5178 2110696.90854 37.7764591031505 -122.38881133109 (37.7764591031505, -122.38881133109) 14 3 9 310 20
84576 196011 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 15 Sidewalk: Property side : Yard Tree Private 2     16     6015786.39152 2110696.30426 37.7764562729832 -122.388884371337 (37.7764562729832, -122.388884371337) 14 3 9 310 20
23490 196012 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 16 Sidewalk: Property side : Yard Tree Private 2     16     6015764.41678 2110694.68671 37.7764506135265 -122.388960275907 (37.7764506135265, -122.388960275907) 14 3 9 310 20
49343 196013 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 17 Sidewalk: Property side : Yard Tree Private 2     17     6015743.28218 2110693.67028 37.7764466511333 -122.389033316139 (37.7764466511333, -122.389033316139) 14 3 9 310 20
30255 196014 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 18 Sidewalk: Property side : Yard Tree Private 2     17     6015720.48392 2110692.27541 37.7764415573597 -122.389112085054 (37.7764415573597, -122.389112085054) 14 3 9 310 20
184380 196015 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 19 Sidewalk: Property side : Yard Tree Private 2     17     6015698.09519 2110690.66596 37.7764358970472 -122.389189422279 (37.7764358970472, -122.389189422279) 14 3 9 310 20
155750 196017 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 21 Sidewalk: Property side : Yard Tree Private 2     16     6015653.37625 2110690.3321 37.776432501193 -122.389344095768 (37.776432501193, -122.389344095768) 14 3 9 310 20
169789 196016 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 20 Sidewalk: Property side : Yard Tree Private 2     15     6015678.42156 2110690.23877 37.7764336334278 -122.389257449686 (37.7764336334278, -122.389257449686) 14 3 9 310 20
6092 196018 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 22 Sidewalk: Property side : Yard Tree Private 2     15     6015632.04702 2110689.93838 37.7764302375944 -122.389417852744 (37.7764302375944, -122.389417852744) 14 3 9 310 20
158107 196020 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 24 Sidewalk: Property side : Yard Tree Private 2     18     6015589.15281 2110687.71234 37.7764217471115 -122.38956608172 (37.7764217471115, -122.38956608172) 14 3 9 310 20
138177 196019 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 23 Sidewalk: Property side : Yard Tree Private 2     17     6015611.09455 2110687.68162 37.7764228793455 -122.389490176245 (37.7764228793455, -122.389490176245) 14 3 9 310 20
39747 196021 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 25 Sidewalk: Property side : Yard Tree Private 2     20     6015567.39764 2110686.7089 37.7764177856004 -122.389641269543 (37.7764177856004, -122.389641269543) 14 3 9 310 20
68586 196022 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 26 Sidewalk: Property side : Yard Tree Private 2     21     6015549.75144 2110684.1794 37.7764098616684 -122.389702136539 (37.7764098616684, -122.389702136539) 14 3 9 310 20
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
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
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
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
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
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
100049 196024 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1670 Owen St 29 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6013848.21751 2107498.56576 37.7675683801977 -122.395365047877 (37.7675683801977, -122.395365047877) 14 3 9 310 20
108842 196023 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1670 Owen St 28 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6013858.29957 2107482.27299 37.7675242045935 -122.395329033601 (37.7675242045935, -122.395329033601) 14 3 9 310 20
88473 85294 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2255 Mariposa St   Sidewalk: Property side : Cutout Landscaping Private 2   07/27/2007 12:00:00 AM   2x50 Permit Number 49675 6010752 2105977 37.7632178155038 -122.405967315915 (37.7632178155038, -122.405967315915) 8 4 8 28859 19
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
150253 234896 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 4 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 10ft   6007240.7393 2101963.94083 37.7520018736867 -122.417827151095 (37.7520018736867, -122.417827151095) 2 4 7 28859 19
165442 234871 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 1 Sidewalk: Property side : Yard Tree Private 2     17     6010740.98958 2100867.24575 37.7491869507297 -122.405645476962 (37.7491869507297, -122.405645476962) 10 4 7 28859 19
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
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
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
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
146008 234876 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 7 Sidewalk: Property side : Yard Tree Private 2     27     6010649.76891 2100846.09542 37.7491237751432 -122.405959431208 (37.7491237751432, -122.405959431208) 10 4 7 28859 19
182229 234877 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 8 Sidewalk: Property side : Yard Tree Private 2     38     6010643.54009 2100844.31084 37.7491185267072 -122.405980844948 (37.7491185267072, -122.405980844948) 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
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
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);