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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||||
101847 | 101847 | 117472 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1201x MONTGOMERY ST | 2 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 6011733.0 | 2119731.0 | 37.8010379082809 | -122.403542078239 | (37.8010379082809, -122.403542078239) | |||||
101181 | 101181 | 117473 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1201x MONTGOMERY ST | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 6011733.0 | 2119731.0 | 37.8010379082809 | -122.403542078239 | (37.8010379082809, -122.403542078239) | |||||
81560 | 81560 | 117474 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1200x MONTGOMERY ST | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 6011580.0 | 2119440.0 | 37.800230345698 | -122.404051036068 | (37.800230345698, -122.404051036068) | |||||
77831 | 77831 | 117475 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1200x MONTGOMERY ST | 2 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 6011580.0 | 2119440.0 | 37.800230345698 | -122.404051036068 | (37.800230345698, -122.404051036068) | |||||
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) | |||
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) | |||
161540 | 161540 | 135664 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3790 California St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5996336.60886 | 2114624.27331 | 37.786144190959504 | -122.45645039347099 | (37.7861441909595, -122.456450393471) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
158786 | 158786 | 195955 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015700.85592 | 2100342.37267 | 37.7480218628289 | -122.38845740468399 | (37.7480218628289, -122.388457404684) | ||||
74084 | 74084 | 195956 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | 6015682.424790001 | 2100340.57249 | 37.748015898531605 | -122.388521013727 | (37.7480158985316, -122.388521013727) | ||||
60765 | 60765 | 195957 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 6015667.37966 | 2100340.53223 | 37.7480149542209 | -122.38857303683399 | (37.7480149542209, -122.388573036834) | ||||
31601 | 31601 | 195958 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015649.240619999 | 2100340.8983400003 | 37.7480149542299 | -122.388635787013 | (37.7480149542299, -122.388635787013) | ||||
179584 | 179584 | 195959 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015616.60441 | 2100338.74984 | 37.7480072461368 | -122.388748492749 | (37.7480072461368, -122.388748492749) | ||||
46092 | 46092 | 195960 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015597.7328 | 2100337.72732 | 37.748003392560896 | -122.38881367921302 | (37.7480033925609, -122.388813679213) | ||||
175233 | 175233 | 195961 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015577.60391 | 2100335.50195 | 37.7479961664858 | -122.388883129368 | (37.7479961664858, -122.388883129368) | ||||
62177 | 62177 | 195962 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | 6015556.6084199995 | 2100333.99599 | 37.7479908676843 | -122.388955626422 | (37.7479908676843, -122.388955626422) | ||||
74090 | 74090 | 195963 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015537.22246 | 2100333.68578 | 37.7479889413373 | -122.389022641203 | (37.7479889413373, -122.389022641203) | ||||
65985 | 65985 | 195964 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015516.57214 | 2100331.8217700003 | 37.7479826784534 | -122.38909391965001 | (37.7479826784534, -122.38909391965) | ||||
137968 | 137968 | 195965 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015497.16873 | 2100330.63483 | 37.747978343742794 | -122.389160933554 | (37.7479783437428, -122.389160933554) | ||||
38334 | 38334 | 195966 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6015475.98989 | 2100328.78152 | 37.7479720808553 | -122.389234040342 | (37.7479720808553, -122.389234040342) | ||||
33201 | 33201 | 195967 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 13 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 6015456.783980001 | 2100328.64296 | 37.747970635647 | -122.389300444473 | (37.747970635647, -122.389300444473) | ||||
38396 | 38396 | 195968 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 6015437.03514 | 2100327.8138099997 | 37.747967264084295 | -122.389368677829 | (37.7479672640843, -122.389368677829) | ||||
26205 | 26205 | 195969 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015417.97335 | 2100326.09336 | 37.7479614832509 | -122.389434473133 | (37.7479614832509, -122.389434473133) | ||||
33236 | 33236 | 195970 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 16 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015399.1088 | 2100325.42161 | 37.747958592828205 | -122.389499659601 | (37.7479585928282, -122.389499659601) | ||||
171288 | 171288 | 195971 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 17 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 4ft | 6015377.86647 | 2100320.4119700002 | 37.7479436595871 | -122.389572765484 | (37.7479436595871, -122.389572765484) | |||
23421 | 23421 | 195972 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 4ft | 6015355.8319 | 2100319.8042599997 | 37.7479407691514 | -122.389648918288 | (37.7479407691514, -122.389648918288) | |||
173877 | 173877 | 195973 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 19 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 4ft | 6015335.01264 | 2100318.2949099997 | 37.747935470342895 | -122.38972080559601 | (37.7479354703429, -122.389720805596) | |||
171805 | 171805 | 195974 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 20 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 4ft | 6015315.44713 | 2100317.81293 | 37.7479330619596 | -122.389788429193 | (37.7479330619596, -122.389788429193) | |||
61234 | 61234 | 195975 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 21 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 4ft | 6015294.9834 | 2100316.47199 | 37.747928245201 | -122.389859098828 | (37.747928245201, -122.389859098828) | |||
147625 | 147625 | 195976 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 22 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 4ft | 6015275.57642 | 2100315.1093900003 | 37.7479234275315 | -122.38992611271401 | (37.7479234275315, -122.389926112714) | |||
42525 | 42525 | 195977 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 23 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 4ft | 6015256.877230001 | 2100313.90806 | 37.7479190918917 | -122.389990690329 | (37.7479190918917, -122.389990690329) | |||
49446 | 49446 | 195978 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 24 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 4ft | 6015236.23042 | 2100312.22008 | 37.747913311958605 | -122.390061968785 | (37.7479133119586, -122.390061968785) | |||
162455 | 162455 | 195979 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 900 Phelps St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 30 | Width 9ft | 6014704.25324 | 2097268.53042 | 37.739526454869704 | -122.39168875963999 | (37.7395264548697, -122.39168875964) | |||
165153 | 165153 | 195980 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 900 Phelps St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6014694.29284 | 2097256.8818599996 | 37.7394939174204 | -122.39172238440399 | (37.7394939174204, -122.391722384404) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
154008 | 154008 | 195993 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2101 Newcomb Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 3ft | 6012429.27896 | 2097757.0265 | 37.7407412159349 | -122.399588970171 | (37.7407412159349, -122.399588970171) | |||
183132 | 183132 | 195994 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2101 Newcomb Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 3ft | 6012438.11131 | 2097750.05558 | 37.74072256758821 | -122.39955794174999 | (37.7407225675882, -122.39955794175) | |||
156951 | 156951 | 195995 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2101 Newcomb Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 3ft | 6012483.54441 | 2097715.89022 | 37.7406312890986 | -122.399398452383 | (37.7406312890986, -122.399398452383) | |||
39702 | 39702 | 195996 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2101 Newcomb Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6012499.275719999 | 2097703.95349 | 37.7405993901482 | -122.39934322143101 | (37.7405993901482, -122.399343221431) | |||
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) | ||||
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) | ||||
166489 | 166489 | 195999 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6016051.5903 | 2110711.60548 | 37.7765129824099 | -122.387968033214 | (37.7765129824099, -122.387968033214) | ||||
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) | ||||
177942 | 177942 | 196001 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6016008.12939 | 2110708.52586 | 37.776502118610395 | -122.38811816333401 | (37.7765021186104, -122.388118163334) | ||||
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) | ||||
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) | ||||
161996 | 161996 | 196004 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6015940.35109 | 2110704.12187 | 37.776486270757204 | -122.388352322497 | (37.7764862707572, -122.388352322497) | ||||
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) | ||||
168920 | 168920 | 196006 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6015895.59891 | 2110702.13918 | 37.7764783468376 | -122.388506996001 | (37.7764783468376, -122.388506996001) | ||||
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) | ||||
181735 | 181735 | 196008 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6015854.1615699995 | 2110700.296 | 37.7764709894889 | -122.388650212137 | (37.7764709894889, -122.388650212137) | ||||
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) | ||||
149012 | 149012 | 196010 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6015807.5178 | 2110696.90854 | 37.7764591031505 | -122.38881133109 | (37.7764591031505, -122.38881133109) | ||||
178922 | 178922 | 196011 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6015786.39152 | 2110696.3042599997 | 37.776456272983204 | -122.388884371337 | (37.7764562729832, -122.388884371337) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
183325 | 183325 | 196018 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6015632.0470199995 | 2110689.9383799997 | 37.7764302375944 | -122.389417852744 | (37.7764302375944, -122.389417852744) | ||||
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) | ||||
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) | ||||
182597 | 182597 | 196021 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6015567.39764 | 2110686.7089 | 37.7764177856004 | -122.389641269543 | (37.7764177856004, -122.389641269543) | ||||
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) | ||||
173216 | 173216 | 196023 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1670 Owen St | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6013858.29957 | 2107482.27299 | 37.7675242045935 | -122.395329033601 | (37.7675242045935, -122.395329033601) | |||
160001 | 160001 | 196024 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1670 Owen St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6013848.21751 | 2107498.5657599997 | 37.7675683801977 | -122.39536504787701 | (37.7675683801977, -122.395365047877) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
155952 | 155952 | 196030 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2 Lane St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6017023.70578 | 2097046.84349 | 37.739046226814 | -122.38365359234601 | (37.739046226814, -122.383653592346) | |||
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) | |||
187036 | 187036 | 196032 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2 Lane St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 6017018.892530001 | 2097040.8451099999 | 37.7390294904202 | -122.383669817022 | (37.7390294904202, -122.383669817022) | |||
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) | |||
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) | |||
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) | |||
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) | |||
162017 | 162017 | 196037 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6017049.14343 | 2096982.7375599998 | 37.7388716108342 | -122.383561177999 | (37.7388716108342, -122.383561177999) | |||
166201 | 166201 | 196038 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6017052.09274 | 2096987.35134 | 37.7388844423585 | -122.38355130167 | (37.7388844423585, -122.38355130167) | |||
168448 | 168448 | 196039 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 6017058.78761 | 2096996.2330599998 | 37.7389091998064 | -122.38352877183998 | (37.7389091998064, -122.38352877184) |
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");