Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
495 | 495 | 248613 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 5997648.1233 | 2107524.615 | 37.766725579885 | -122.451400674442 | (37.766725579885, -122.451400674442) | |||
3855 | 3855 | 248614 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997650.5459 | 2107506.4452 | 37.7666758289672 | -122.451390984496 | (37.7666758289672, -122.451390984496) | |||
23464 | 23464 | 121867 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 382 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990303.78145 | 2112825.7530799997 | 37.7808577673116 | -122.477190674715 | (37.7808577673116, -122.477190674715) | |||
26304 | 26304 | 140079 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 100 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000729.2298 | 2112451.4153 | 37.780429279749605 | -122.44109718195499 | (37.7804292797496, -122.441097181955) | |||
44122 | 44122 | 212849 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1201 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992374.69215 | 2098410.70315 | 37.7413977704887 | -122.468977090726 | (37.7413977704887, -122.468977090726) | |||
46771 | 46771 | 140080 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6000726.8608 | 2112462.5832 | 37.7804598090154 | -122.441106178881 | (37.7804598090154, -122.441106178881) | |||
164715 | 164715 | 139060 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1455 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 39 | Width 0ft | 5999670.4186 | 2113895.7324 | 37.7843346353185 | -122.444863945857 | (37.7843346353185, -122.444863945857) | |||
169265 | 169265 | 140081 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104 Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6000726.183999999 | 2112472.3974 | 37.7804867177527 | -122.441109224562 | (37.7804867177527, -122.441109224562) | |||
175227 | 175227 | 140083 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6000722.7998 | 2112497.1022 | 37.7805543580623 | -122.441122705034 | (37.7805543580623, -122.441122705034) | |||
188309 | 188309 | 234896 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 10ft | 6007240.7393 | 2101963.9408299997 | 37.7520018736867 | -122.41782715109501 | (37.7520018736867, -122.417827151095) | |||
25205 | 25205 | 195981 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6018524.13374 | 2099557.3325900002 | 37.746022348857295 | -122.37864001312799 | (37.7460223488573, -122.378640013128) | ||||
26910 | 26910 | 195984 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6018485.16554 | 2099556.70792 | 37.7460184853642 | -122.378774718093 | (37.7460184853642, -122.378774718093) | ||||
29206 | 29206 | 195983 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6018491.3513 | 2099573.26629 | 37.7460642923356 | -122.378754477939 | (37.7460642923356, -122.378754477939) | ||||
46984 | 46984 | 195986 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6018468.61509 | 2099561.7634900003 | 37.7460314544851 | -122.378832298987 | (37.7460314544851, -122.378832298987) | ||||
49096 | 49096 | 212850 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 32 Malta Dr | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | Width 3ft | 5999489.821880001 | 2096117.1264 | 37.7355086796695 | -122.444210754429 | (37.7355086796695, -122.444210754429) | |||
51068 | 51068 | 201994 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1799 Carroll Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6013316.6056 | 2092506.69666 | 37.7263743142142 | -122.396153039251 | (37.7263743142142, -122.396153039251) | ||||
61850 | 61850 | 195989 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6018358.23149 | 2099573.02507 | 37.7460562901585 | -122.37921477706699 | (37.7460562901585, -122.379214777067) | ||||
69871 | 69871 | 195990 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6018348.89198 | 2099575.3229 | 37.746062084515295 | -122.379247231793 | (37.7460620845153, -122.379247231793) | ||||
78277 | 78277 | 98312 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 160 Stanford Heights Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5998064.7 | 2096544.4 | 37.7366004632858 | -122.449168689734 | (37.7366004632858, -122.449168689734) | |||||
120047 | 120047 | 195988 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6018362.603680001 | 2099564.59582 | 37.7460333862374 | -122.379199073078 | (37.7460333862374, -122.379199073078) | ||||
130066 | 130066 | 195985 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6018474.359130001 | 2099556.32192 | 37.74601682971289 | -122.378812058831 | (37.7460168297129, -122.378812058831) | ||||
130871 | 130871 | 195987 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6018466.53487 | 2099573.76457 | 37.7460642923433 | -122.378840325441 | (37.7460642923433, -122.378840325441) | ||||
132662 | 132662 | 201996 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1799 Carroll Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6013312.67339 | 2092499.74696 | 37.7263550129554 | -122.396166145968 | (37.7263550129554, -122.396166145968) | ||||
137250 | 137250 | 201997 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1799 Carroll Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6013313.68951 | 2092516.98736 | 37.7264024081338 | -122.39616384100201 | (37.7264024081338, -122.396163841002) | ||||
149276 | 149276 | 195992 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6018320.61791 | 2099573.80473 | 37.7460563567193 | -122.379344895446 | (37.7460563567193, -122.379344895446) | ||||
157844 | 157844 | 201995 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1799 Carroll Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6013319.20907 | 2092521.7003099998 | 37.726415656052104 | -122.396145090149 | (37.7264156560521, -122.396145090149) | ||||
164241 | 164241 | 201993 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1799 Carroll Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6013314.351009999 | 2092488.44605 | 37.726324076294205 | -122.396159554816 | (37.7263240762942, -122.396159554816) | ||||
176864 | 176864 | 135666 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3001 Divisadero St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | Width 9ft | 6000472.49775 | 2118651.8946700003 | 37.797439556256705 | -122.442430617479 | (37.7974395562567, -122.442430617479) | |||
177923 | 177923 | 195991 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6018339.20952 | 2099575.6179 | 37.7460623605839 | -122.379280733321 | (37.7460623605839, -122.379280733321) | ||||
187127 | 187127 | 195982 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6018502.102580001 | 2099556.87815 | 37.746019886521296 | -122.378716163238 | (37.7460198865213, -122.378716163238) | ||||
30434 | 30434 | 248121 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 109 Brewster St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010387.395819999 | 2099398.52057 | 37.7451343735684 | -122.40676472010901 | (37.7451343735684, -122.406764720109) | ||||
32347 | 32347 | 248125 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 109 Brewster St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6010397.048769999 | 2099427.00914 | 37.745213137076796 | -122.406733349058 | (37.7452131370768, -122.406733349058) | ||||
33120 | 33120 | 249800 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 199 Chestnut St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 0ft | 6010811.58408 | 2121055.18857 | 37.8046222939481 | -122.406823966551 | (37.8046222939481, -122.406823966551) | |||
35883 | 35883 | 248126 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 109 Brewster St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010387.789530001 | 2099433.6295 | 37.7452307970734 | -122.40676583257401 | (37.7452307970734, -122.406765832574) | ||||
46578 | 46578 | 234892 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010653.55518 | 2100656.49907 | 37.7486033968442 | -122.40593298392 | (37.7486033968442, -122.40593298392) | ||||
50221 | 50221 | 234891 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6010619.31212 | 2100642.55964 | 37.748563207025704 | -122.406050414705 | (37.7485632070257, -122.406050414705) | ||||
51090 | 51090 | 248124 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 109 Brewster St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6010394.26479 | 2099420.04988 | 37.7451938726969 | -122.406742485274 | (37.7451938726969, -122.406742485274) | ||||
65833 | 65833 | 249798 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 199 Chestnut St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010832.73906 | 2121063.1197 | 37.8046452545423 | -122.406751316639 | (37.8046452545423, -122.406751316639) | |||
72921 | 72921 | 234889 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6010620.28496 | 2100677.87035 | 37.7486602169168 | -122.406049537871 | (37.7486602169168, -122.406049537871) | ||||
129839 | 129839 | 248123 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 109 Brewster St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6010392.06783 | 2099413.0786599996 | 37.7451746083214 | -122.40674959081899 | (37.7451746083214, -122.406749590819) | ||||
146490 | 146490 | 234888 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 6010611.762999999 | 2100694.95228 | 37.7487066435094 | -122.40608021012699 | (37.7487066435094, -122.406080210127) | ||||
146994 | 146994 | 234890 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6010623.85334 | 2100666.44158 | 37.7486290355994 | -122.40603639336099 | (37.7486290355994, -122.406036393361) | ||||
149461 | 149461 | 234894 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6010729.67514 | 2100698.35511 | 37.7487225812957 | -122.405672708429 | (37.7487225812957, -122.405672708429) | ||||
154711 | 154711 | 249797 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 199 Chestnut St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6010839.41961 | 2121064.72571 | 37.804650038031795 | -122.40672831108499 | (37.8046500380318, -122.406728311085) | |||
168626 | 168626 | 234893 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6010664.01336 | 2100659.8191 | 37.7486130978165 | -122.405897053323 | (37.7486130978165, -122.405897053323) | ||||
170865 | 170865 | 234887 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2827 Cesar Chavez St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6010600.221609999 | 2100713.10517 | 37.7487558418292 | -122.40612139908501 | (37.7487558418292, -122.406121399085) | ||||
182677 | 182677 | 248122 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 109 Brewster St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6010390.78091 | 2099407.55033 | 37.7451593567256 | -122.406753651253 | (37.7451593567256, -122.406753651253) | ||||
185609 | 185609 | 248127 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 109 Brewster St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010399.6226 | 2099438.06548 | 37.7452436393873 | -122.40672522818701 | (37.7452436393873, -122.406725228187) | ||||
3856 | 3856 | 246917 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5997637.485090001 | 2107521.28402 | 37.766715824697 | -122.451437229753 | (37.766715824697, -122.451437229753) | |||
24124 | 24124 | 234881 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | 6010567.07854 | 2100828.40228 | 37.749070568567 | -122.40624413046899 | (37.749070568567, -122.406244130469) | ||||
24182 | 24182 | 196031 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2 Lane St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6017021.60504 | 2097043.8381400001 | 37.7390378586108 | -122.383660646635 | (37.7390378586108, -122.383660646635) | |||
25030 | 25030 | 196022 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6015549.75144 | 2110684.1794 | 37.7764098616684 | -122.389702136539 | (37.7764098616684, -122.389702136539) | ||||
28429 | 28429 | 234882 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6010551.469930001 | 2100825.34606 | 37.7490613037485 | -122.406297890147 | (37.7490613037485, -122.406297890147) | ||||
28993 | 28993 | 196012 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6015764.416780001 | 2110694.68671 | 37.7764506135265 | -122.388960275907 | (37.7764506135265, -122.388960275907) | ||||
29497 | 29497 | 135665 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3790 California St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 5996326.409519999 | 2114621.95963 | 37.7861372526689 | -122.45648551290199 | (37.7861372526689, -122.456485512902) | |||
31815 | 31815 | 196007 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6015874.48096 | 2110701.94702 | 37.7764766489106 | -122.388580036236 | (37.7764766489106, -122.388580036236) | ||||
32073 | 32073 | 234877 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | 6010643.54009 | 2100844.31084 | 37.7491185267072 | -122.405980844948 | (37.7491185267072, -122.405980844948) | ||||
33398 | 33398 | 196014 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6015720.48392 | 2110692.27541 | 37.7764415573597 | -122.389112085054 | (37.7764415573597, -122.389112085054) | ||||
35215 | 35215 | 196035 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 10ft | 6017042.43736 | 2096973.9330400003 | 37.7388470647366 | -122.38358375190501 | (37.7388470647366, -122.383583751905) | |||
38488 | 38488 | 196041 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6017065.52556 | 2097005.9762799998 | 37.738936325136706 | -122.383506153 | (37.7389363251367, -122.383506153) | |||
38753 | 38753 | 234884 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6010535.25533 | 2100821.90556 | 37.749050949857796 | -122.406353718268 | (37.7490509498578, -122.406353718268) | ||||
41087 | 41087 | 196003 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6015962.95079 | 2110705.93329 | 37.776492496775106 | -122.388274269443 | (37.7764924967751, -122.388274269443) | ||||
41709 | 41709 | 234885 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010529.65259 | 2100820.82881 | 37.7490476799194 | -122.406373016826 | (37.7490476799194, -122.406373016826) | ||||
45266 | 45266 | 196009 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6015830.73834 | 2110698.70731 | 37.776465329147 | -122.388731129538 | (37.776465329147, -122.388731129538) | ||||
46532 | 46532 | 196000 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6016029.9014099995 | 2110710.35403 | 37.776508344609496 | -122.38804297461999 | (37.7765083446095, -122.38804297462) | ||||
47717 | 47717 | 234909 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 6009677.77783 | 2096362.7223200002 | 37.73675900081071 | -122.409004306302 | (37.7367590008107, -122.409004306302) | |||
47853 | 47853 | 196002 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6015985.51722 | 2110706.0962799997 | 37.7764941946745 | -122.38819621639799 | (37.7764941946745, -122.388196216398) | ||||
48598 | 48598 | 196029 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2 Lane St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6017027.27121 | 2097051.6476 | 37.7390596150087 | -122.383641598974 | (37.7390596150087, -122.383641598974) | |||
51715 | 51715 | 234880 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6010577.49101 | 2100830.77043 | 37.7490776534227 | -122.40620829069799 | (37.7490776534227, -122.406208290698) | ||||
52696 | 52696 | 234902 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6009698.6344099995 | 2096418.94153 | 37.7369145349811 | -122.40893616107799 | (37.7369145349811, -122.408936161078) | ||||
52998 | 52998 | 195998 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6016075.490669999 | 2110714.30849 | 37.776521728336604 | -122.387885542896 | (37.7765217283366, -122.387885542896) | ||||
53814 | 53814 | 196045 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6017076.588380001 | 2097018.35028 | 37.7389709130863 | -122.383468763681 | (37.7389709130863, -122.383468763681) | |||
55335 | 55335 | 234886 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 6010522.647340001 | 2100819.38367 | 37.7490433200014 | -122.40639713934401 | (37.7490433200014, -122.406397139344) | ||||
55642 | 55642 | 196036 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 6017046.41048 | 2096978.7292799999 | 37.738860453849 | -122.383570348389 | (37.738860453849, -122.383570348389) | |||
59758 | 59758 | 234871 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6010740.989580001 | 2100867.24575 | 37.7491869507297 | -122.405645476962 | (37.7491869507297, -122.405645476962) | ||||
60534 | 60534 | 196005 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6015919.22066 | 2110703.31156 | 37.7764828749315 | -122.38842536276 | (37.7764828749315, -122.38842536276) | ||||
61094 | 61094 | 196049 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 10ft | 6017090.910619999 | 2097040.61449 | 37.7390328376916 | -122.38342079293501 | (37.7390328376916, -122.383420792935) | |||
62070 | 62070 | 196033 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2 Lane St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6017016.3348 | 2097035.41086 | 37.7390144276853 | -122.38367828232501 | (37.7390144276853, -122.383678282325) | |||
63128 | 63128 | 196020 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6015589.15281 | 2110687.71234 | 37.7764217471115 | -122.38956608171999 | (37.7764217471115, -122.38956608172) | ||||
65477 | 65477 | 196046 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6017076.84536 | 2097020.9862799998 | 37.7389781652152 | -122.383468058608 | (37.7389781652152, -122.383468058608) | |||
65821 | 65821 | 196027 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2 Lane St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6017034.20589 | 2097061.6668900002 | 37.739087509266604 | -122.383618319135 | (37.7390875092666, -122.383618319135) | |||
68610 | 68610 | 234900 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6009696.65795 | 2096435.2295400002 | 37.7369591476365 | -122.40894414348 | (37.7369591476365, -122.40894414348) | ||||
69044 | 69044 | 196048 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6017086.8639400005 | 2097032.1625700002 | 37.7390094067689 | -122.383434196434 | (37.7390094067689, -122.383434196434) | |||
69678 | 69678 | 195997 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6016094.12732 | 2110713.51522 | 37.776520582607 | -122.387821017432 | (37.776520582607, -122.387821017432) | ||||
69986 | 69986 | 196013 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6015743.28218 | 2110693.6702799997 | 37.7764466511333 | -122.38903331613899 | (37.7764466511333, -122.389033316139) | ||||
71617 | 71617 | 196015 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6015698.09519 | 2110690.66596 | 37.77643589704721 | -122.38918942227899 | (37.7764358970472, -122.389189422279) | ||||
72864 | 72864 | 234906 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 6009686.024230001 | 2096384.83518 | 37.7368201799074 | -122.408977354526 | (37.7368201799074, -122.408977354526) | |||
73079 | 73079 | 196019 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6015611.09455 | 2110687.68162 | 37.776422879345496 | -122.389490176245 | (37.7764228793455, -122.389490176245) | ||||
73353 | 73353 | 196047 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 10ft | 6017083.0987599995 | 2097027.5652 | 37.7389965752218 | -122.383446894874 | (37.7389965752218, -122.383446894874) | |||
73733 | 73733 | 234901 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009690.97834 | 2096436.6273599998 | 37.7369626675976 | -122.408963879105 | (37.7369626675976, -122.408963879105) | ||||
74651 | 74651 | 196034 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 10ft | 6017038.2356199995 | 2096967.92235 | 37.738830328350794 | -122.38359786136002 | (37.7388303283508, -122.38359786136) | |||
102782 | 102782 | 196025 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2 Lane St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 10ft | 6017042.181609999 | 2097072.1185299999 | 37.7391166482065 | -122.38359146989201 | (37.7391166482065, -122.383591469892) | |||
133456 | 133456 | 234878 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6010615.53478 | 2100839.3237900003 | 37.749103267009204 | -122.406077336824 | (37.7491032670092, -122.406077336824) | ||||
134366 | 134366 | 135663 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3790 California St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5996346.46825 | 2114626.15487 | 37.78614992323771 | -122.456416418905 | (37.7861499232377, -122.456416418905) | |||
135800 | 135800 | 196016 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6015678.42156 | 2110690.23877 | 37.77643363342779 | -122.389257449686 | (37.7764336334278, -122.389257449686) | ||||
137504 | 137504 | 196017 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6015653.37625 | 2110690.3321 | 37.776432501193 | -122.389344095768 | (37.776432501193, -122.389344095768) | ||||
146435 | 146435 | 196026 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2 Lane St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 10ft | 6017039.21913 | 2097067.45785 | 37.7391036871735 | -122.383601388517 | (37.7391036871735, -122.383601388517) | |||
147141 | 147141 | 234872 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6010732.42318 | 2100864.09022 | 37.7491778073048 | -122.405674877619 | (37.7491778073048, -122.405674877619) | ||||
147185 | 147185 | 196028 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2 Lane St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6017030.6363699995 | 2097056.65947 | 37.7390735625998 | -122.383630312507 | (37.7390735625998, -122.383630312507) | |||
148840 | 148840 | 196044 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6017074.4672 | 2097014.32935 | 37.7389597551859 | -122.38347581797701 | (37.7389597551859, -122.383475817977) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");