trees

334 rows where qSpecies_id = 59 sorted by SiteOrder descending

✎ 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)
44966 244263 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 4 Median : Cutout Tree DPW 1     5 Width 0ft   6005610.4338 2110073.0988 37.7741758216851 -122.424041609468 (37.7741758216851, -122.424041609468) 7 9 11 28852 10
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
67742 246560 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 4 Median : Yard Tree DPW 1     5 Width 7ft   6005720.56075 2109380.70244 37.772280885298 -122.423611422347 (37.772280885298, -122.423611422347) 7 9 11 28852 10
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
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
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
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
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
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
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
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
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
113742 119769 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 4 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
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
153530 196036 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 4 Sidewalk: Property side : Yard Tree Private 2     17 Width 10ft   6017046.41048 2096978.72928 37.738860453849 -122.383570348389 (37.738860453849, -122.383570348389) 10 3 8 58 1
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
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
176690 195958 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 4 Back Yard : Yard Tree Private 2     10     6015649.24062 2100340.89834 37.7480149542299 -122.388635787013 (37.7480149542299, -122.388635787013) 10 3 8 58 1
179780 234900 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 4 Sidewalk: Property side : Yard Tree Private 2     17     6009696.65795 2096435.22954 37.7369591476365 -122.40894414348 (37.7369591476365, -122.40894414348) 10 7 7 28859 2
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
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
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
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
1376 263620 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 3 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
6805 19781 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY19 3 Sidewalk: Curb side : Cutout Tree DPW 1     36 50ST                      
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
14196 6096 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 106X Saint Joseph's Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6000733.8426241 2112435.5369559 37.7803859446112 -122.44108008458 (37.7803859446112, -122.44108008458) 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
15701 254211 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 300X Esmeralda Ave 3 Unaccepted Street : Yard Tree DPW 1                              
19788 246559 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 3 Median : Yard Tree DPW 1     6 Width 7ft   6005723.21879 2109372.62983 37.7722588698898 -122.423601653893 (37.7722588698898, -122.423601653893) 7 9 11 28852 10
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
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
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
34981 244429 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102x Octavia St 3 Median : Cutout Tree DPW 1     9 Width 0ft   6005659.2973 2109696.7034 37.7731450894818 -122.4238458121 (37.7731450894818, -122.4238458121) 7 9 11 28852 10
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
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
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
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
53212 119723 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 3 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
64025 119685 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 3 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
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
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
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
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
135590 195990 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 3 Sidewalk: Curb side : Yard Tree Private 2     4     6018348.89198 2099575.3229 37.7460620845153 -122.379247231793 (37.7460620845153, -122.379247231793) 10 3 8 58 1
136935 196026 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2 Lane St 3 Sidewalk: Property side : Yard Tree Private 2     20 Width 10ft   6017039.21913 2097067.45785 37.7391036871735 -122.383601388517 (37.7391036871735, -122.383601388517) 10 3 8 58 1
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
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
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
147228 244262 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 3 Median : Cutout Tree DPW 1     5 Width 0ft   6005612.7252 2110055.5318 37.7741277163216 -122.424032433594 (37.7741277163216, -122.424032433594) 7 9 11 28852 10
153309 119768 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 3 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
173532 195957 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 3 Back Yard : Yard Tree Private 2     12     6015667.37966 2100340.53223 37.7480149542209 -122.388573036834 (37.7480149542209, -122.388573036834) 10 3 8 58 1
191905 248123 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 109 Brewster St 3 Front Yard : Yard Tree Private 2     13     6010392.06783 2099413.07866 37.7451746083214 -122.406749590819 (37.7451746083214, -122.406749590819) 2 7 7 28859 2
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
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
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
164057 196049 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 26 Sidewalk: Property side : Yard Tree Private 2     35 Width 10ft   6017090.91062 2097040.61449 37.7390328376916 -122.383420792935 (37.7390328376916, -122.383420792935) 10 3 8 58 1
12447 19841 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY25 25 Sidewalk: Curb side : Cutout Tree DPW 1     12 60X                      
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
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
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
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
145025 195977 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 23 Back Yard : Yard Tree Private 2     5 Width 4ft   6015256.87723 2100313.90806 37.7479190918917 -122.389990690329 (37.7479190918917, -122.389990690329)   3 8 58 1
159019 196047 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 23 Sidewalk: Property side : Yard Tree Private 2     21 Width 10ft   6017083.09876 2097027.5652 37.7389965752218 -122.383446894874 (37.7389965752218, -122.383446894874) 10 3 8 58 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
185019 195976 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 22 Back Yard : Yard Tree Private 2     5 Width 4ft   6015275.57642 2100315.10939 37.7479234275315 -122.389926112714 (37.7479234275315, -122.389926112714)   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
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
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
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
153116 24282 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 300X Winding Way 20 Median : Cutout Tree DPW 1     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117) 9 7 6 28861 5
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
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
1959 19904 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY34 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 6X6                      
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
10225 263619 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 2 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
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
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
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
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
36058 6095 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 106X Saint Joseph's Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/19/2015 12:00:00 AM 12 3X3   6000733.8426241 2112435.5369559 37.7803859446112 -122.44108008458 (37.7803859446112, -122.44108008458) 15 5 1 29490 41
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
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
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
56641 119767 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 2 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
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
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
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
74269 119684 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 2 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
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
81955 246558 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 2 Median : Yard Tree DPW 1     7 Width 7ft   6005725.55596 2109365.49138 37.7722394013476 -122.423593061791 (37.7722394013476, -122.423593061791) 7 9 11 28852 10
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
100001 244261 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 2 Median : Cutout Tree DPW 1     5 Width 0ft   6005613.489 2110034.9096 37.7740711358709 -122.424028324662 (37.7740711358709, -122.424028324662) 7 9 11 28852 10
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
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
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
113560 119722 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 2 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          

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