trees

334 rows where qSpecies_id = 59 sorted by Zip Codes

✎ View and edit SQL

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)
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
73440 116094 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
80147 116095 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
118842 116091 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
145439 116093 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
154885 116096 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
170444 116097 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
177168 116092 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
21224 196043 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 15 Sidewalk: Property side : Yard Tree Private 2     13 Width 10ft   6017069.89025 2097009.95172 37.7389474821301 -122.383491338448 (37.7389474821301, -122.383491338448) 10 3 8 58 1
21347 201996 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1799 Carroll Ave 4 Sidewalk: Curb side : Yard Tree Private 2     2     6013312.67339 2092499.74696 37.7263550129554 -122.396166145968 (37.7263550129554, -122.396166145968) 10 3 8 58 1
28533 195986 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 7 Sidewalk: Curb side : Yard Tree Private 2     3     6018468.61509 2099561.76349 37.7460314544851 -122.378832298987 (37.7460314544851, -122.378832298987) 10 3 8 58 1
29793 195970 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 16 Back Yard : Yard Tree Private 2     8     6015399.1088 2100325.42161 37.7479585928282 -122.389499659601 (37.7479585928282, -122.389499659601)   3 8 58 1
32210 195994 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2101 Newcomb Ave 3 Side Yard : Yard Tree Private 2     20 Width 3ft   6012438.11131 2097750.05558 37.7407225675882 -122.39955794175 (37.7407225675882, -122.39955794175) 10 3 8 58 1
35055 196038 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 7 Sidewalk: Property side : Yard Tree Private 2     15 Width 10ft   6017052.09274 2096987.35134 37.7388844423585 -122.38355130167 (37.7388844423585, -122.38355130167) 10 3 8 58 1
37731 196046 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 20 Sidewalk: Property side : Yard Tree Private 2     15 Width 10ft   6017076.84536 2097020.98628 37.7389781652152 -122.383468058608 (37.7389781652152, -122.383468058608) 10 3 8 58 1
38227 196030 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2 Lane St 9 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   6017023.70578 2097046.84349 37.739046226814 -122.383653592346 (37.739046226814, -122.383653592346) 10 3 8 58 1
41514 195974 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 20 Back Yard : Yard Tree Private 2     12 Width 4ft   6015315.44713 2100317.81293 37.7479330619596 -122.389788429193 (37.7479330619596, -122.389788429193)   3 8 58 1
42007 195956 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 2 Back Yard : Yard Tree Private 2     9     6015682.42479 2100340.57249 37.7480158985316 -122.388521013727 (37.7480158985316, -122.388521013727) 10 3 8 58 1
47866 195983 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 10 Sidewalk: Curb side : Yard Tree Private 2     4     6018491.3513 2099573.26629 37.7460642923356 -122.378754477939 (37.7460642923356, -122.378754477939) 10 3 8 58 1
52665 254470 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1601 Evans Ave 11 Sidewalk: Property side : Yard Tree Private 2       3x3   6015397 2098706 37.7435118805521 -122.389393878977 (37.7435118805521, -122.389393878977) 10 3 8 58 1
52670 196039 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 9 Sidewalk: Property side : Yard Tree Private 2     17 Width 10ft   6017058.78761 2096996.23306 37.7389091998064 -122.38352877184 (37.7389091998064, -122.38352877184) 10 3 8 58 1
53808 195978 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 24 Back Yard : Yard Tree Private 2     9 Width 4ft   6015236.23042 2100312.22008 37.7479133119586 -122.390061968785 (37.7479133119586, -122.390061968785)   3 8 58 1
55799 195988 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 5 Sidewalk: Curb side : Yard Tree Private 2     3     6018362.60368 2099564.59582 37.7460333862374 -122.379199073078 (37.7460333862374, -122.379199073078) 10 3 8 58 1
61218 201995 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1799 Carroll Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2     6013319.20907 2092521.70031 37.7264156560521 -122.396145090149 (37.7264156560521, -122.396145090149) 10 3 8 58 1
61534 195959 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 5 Back Yard : Yard Tree Private 2     10     6015616.60441 2100338.74984 37.7480072461368 -122.388748492749 (37.7480072461368, -122.388748492749) 10 3 8 58 1
62379 195992 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 1 Sidewalk: Curb side : Yard Tree Private 2     5     6018320.61791 2099573.80473 37.7460563567193 -122.379344895446 (37.7460563567193, -122.379344895446) 10 3 8 58 1
63271 195965 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 11 Back Yard : Yard Tree Private 2     8     6015497.16873 2100330.63483 37.7479783437428 -122.389160933554 (37.7479783437428, -122.389160933554) 10 3 8 58 1
64076 195969 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 15 Back Yard : Yard Tree Private 2     8     6015417.97335 2100326.09336 37.7479614832509 -122.389434473133 (37.7479614832509, -122.389434473133)   3 8 58 1
64096 195982 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 11 Sidewalk: Curb side : Yard Tree Private 2     10     6018502.10258 2099556.87815 37.7460198865213 -122.378716163238 (37.7460198865213, -122.378716163238) 10 3 8 58 1
66956 196045 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 19 Sidewalk: Property side : Yard Tree Private 2     12 Width 10ft   6017076.58838 2097018.35028 37.7389709130863 -122.383468763681 (37.7389709130863, -122.383468763681) 10 3 8 58 1
72063 196028 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2 Lane St 6 Sidewalk: Property side : Yard Tree Private 2     11 Width 10ft   6017030.63637 2097056.65947 37.7390735625998 -122.383630312507 (37.7390735625998, -122.383630312507) 10 3 8 58 1
72670 196032 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2 Lane St 11 Sidewalk: Property side : Yard Tree Private 2     14 Width 10ft   6017018.89253 2097040.84511 37.7390294904202 -122.383669817022 (37.7390294904202, -122.383669817022) 10 3 8 58 1
74182 195980 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Phelps St 2 Side Yard : Yard Tree Private 2     24     6014694.29284 2097256.88186 37.7394939174204 -122.391722384404 (37.7394939174204, -122.391722384404) 10 3 8 58 1
79032 195968 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 14 Back Yard : Yard Tree Private 2     7     6015437.03514 2100327.81381 37.7479672640843 -122.389368677829 (37.7479672640843, -122.389368677829)   3 8 58 1
79693 196025 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2 Lane St 2 Sidewalk: Property side : Yard Tree Private 2     20 Width 10ft   6017042.18161 2097072.11853 37.7391166482065 -122.383591469892 (37.7391166482065, -122.383591469892) 10 3 8 58 1
81240 195975 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 21 Back Yard : Yard Tree Private 2     9 Width 4ft   6015294.9834 2100316.47199 37.747928245201 -122.389859098828 (37.747928245201, -122.389859098828)   3 8 58 1
82059 195984 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 9 Sidewalk: Curb side : Yard Tree Private 2     5     6018485.16554 2099556.70792 37.7460184853642 -122.378774718093 (37.7460184853642, -122.378774718093) 10 3 8 58 1
90159 195962 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 8 Back Yard : Yard Tree Private 2     9     6015556.60842 2100333.99599 37.7479908676843 -122.388955626422 (37.7479908676843, -122.388955626422) 10 3 8 58 1
91426 196034 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 1 Sidewalk: Property side : Yard Tree Private 2     19 Width 10ft   6017038.23562 2096967.92235 37.7388303283508 -122.38359786136 (37.7388303283508, -122.38359786136) 10 3 8 58 1
93753 195995 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2101 Newcomb Ave 4 Side Yard : Yard Tree Private 2     23 Width 3ft   6012483.54441 2097715.89022 37.7406312890986 -122.399398452383 (37.7406312890986, -122.399398452383) 10 3 8 58 1
97183 201993 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1799 Carroll Ave 5 Sidewalk: Curb side : Yard Tree Private 2     2     6013314.35101 2092488.44605 37.7263240762942 -122.396159554816 (37.7263240762942, -122.396159554816) 10 3 8 58 1
98268 196037 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 6 Sidewalk: Property side : Yard Tree Private 2     15 Width 10ft   6017049.14343 2096982.73756 37.7388716108342 -122.383561177999 (37.7388716108342, -122.383561177999) 10 3 8 58 1
98771 195973 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 19 Back Yard : Yard Tree Private 2     10 Width 4ft   6015335.01264 2100318.29491 37.7479354703429 -122.389720805596 (37.7479354703429, -122.389720805596)   3 8 58 1
99139 195989 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 4 Sidewalk: Curb side : Yard Tree Private 2     3     6018358.23149 2099573.02507 37.7460562901585 -122.379214777067 (37.7460562901585, -122.379214777067) 10 3 8 58 1
102343 196033 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2 Lane St 13 Sidewalk: Property side : Yard Tree Private 2     6 Width 10ft   6017016.3348 2097035.41086 37.7390144276853 -122.383678282325 (37.7390144276853, -122.383678282325) 10 3 8 58 1
103959 195966 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 12 Back Yard : Yard Tree Private 2     6     6015475.98989 2100328.78152 37.7479720808553 -122.389234040342 (37.7479720808553, -122.389234040342)   3 8 58 1
104734 196035 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 2 Sidewalk: Property side : Yard Tree Private 2     18 Width 10ft   6017042.43736 2096973.93304 37.7388470647366 -122.383583751905 (37.7388470647366, -122.383583751905) 10 3 8 58 1
104890 201994 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1799 Carroll Ave 3 Sidewalk: Curb side : Yard Tree Private 2     2     6013316.6056 2092506.69666 37.7263743142142 -122.396153039251 (37.7263743142142, -122.396153039251) 10 3 8 58 1
110153 196040 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 10 Sidewalk: Property side : Yard Tree Private 2     12 Width 10ft   6017061.14337 2096999.06361 37.7389171021312 -122.383520823632 (37.7389171021312, -122.383520823632) 10 3 8 58 1
112062 196048 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 25 Sidewalk: Property side : Yard Tree Private 2     16 Width 10ft   6017086.86394 2097032.16257 37.7390094067689 -122.383434196434 (37.7390094067689, -122.383434196434) 10 3 8 58 1
115902 195996 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2101 Newcomb Ave 5 Side Yard : Yard Tree Private 2     14 Width 3ft   6012499.27572 2097703.95349 37.7405993901482 -122.399343221431 (37.7405993901482, -122.399343221431) 10 3 8 58 1
120240 195985 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 8 Sidewalk: Curb side : Yard Tree Private 2     5     6018474.35913 2099556.32192 37.7460168297129 -122.378812058831 (37.7460168297129, -122.378812058831) 10 3 8 58 1

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