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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
180467 | 180467 | 246918 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 5997638.105140001 | 2107510.95773 | 37.7666875068428 | -122.451434340243 | (37.7666875068428, -122.451434340243) | |||
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) | |||
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) | |||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
180656 | 180656 | 247225 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 754 Duboce Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6002109.5730099995 | 2108309.81574 | 37.7691360073432 | -122.43602549030001 | (37.7691360073432, -122.4360254903) | ||||
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) | |||
41744 | 41744 | 248172 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 218 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6007302.01446 | 2098729.32454 | 37.74312379432521 | -122.41738604353701 | (37.7431237943252, -122.417386043537) | ||||
56013 | 56013 | 248173 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 218 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6007303.951309999 | 2098726.55555 | 37.743116300271 | -122.41737915022101 | (37.743116300271, -122.417379150221) | ||||
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) | |||
172242 | 172242 | 234908 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 10ft | 6009679.550530001 | 2096368.23252 | 37.73677422993671 | -122.408998565949 | (37.7367742299367, -122.408998565949) | |||
176193 | 176193 | 234907 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 6009682.36778 | 2096375.42259 | 37.7367941301369 | -122.40898933260401 | (37.7367941301369, -122.408989332604) | |||
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) | |||
156252 | 156252 | 234905 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 6009688.58582 | 2096390.10165 | 37.736834783993004 | -122.40896886942 | (37.736834783993, -122.40896886942) | |||
180616 | 180616 | 234904 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6009689.76503 | 2096405.45865 | 37.73687701706479 | -122.408965875569 | (37.7368770170648, -122.408965875569) | ||||
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) | ||||
175927 | 175927 | 234897 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6009692.09622 | 2096449.4371099998 | 37.7369979030329 | -122.408960917621 | (37.7369979030329, -122.408960917621) | ||||
184850 | 184850 | 234903 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6009692.653580001 | 2096419.54828 | 37.7369158659624 | -122.40895688234801 | (37.7369158659624, -122.408956882348) | ||||
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) | ||||
186239 | 186239 | 234899 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6009698.94501 | 2096439.52165 | 37.7369710609585 | -122.408936538802 | (37.7369710609585, -122.408936538802) | ||||
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) | ||||
173066 | 173066 | 234898 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 Alemany Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6009700.61042 | 2096445.6891 | 37.736988088737704 | -122.40893121572901 | (37.7369880887377, -122.408931215729) | ||||
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) | |||
154282 | 154282 | 248120 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6010373.21137 | 2099395.33781 | 37.745124840742 | -122.40681354343701 | (37.745124840742, -122.406813543437) | ||||
24297 | 24297 | 248119 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010375.35501 | 2099399.67941 | 37.7451368817742 | -122.40680643699301 | (37.7451368817742, -122.406806436993) | ||||
54920 | 54920 | 248118 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010376.970919999 | 2099406.95495 | 37.7451569492381 | -122.40680136209 | (37.7451569492381, -122.40680136209) | ||||
148699 | 148699 | 248117 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010378.29952 | 2099414.5285 | 37.7451778188963 | -122.40679730165701 | (37.7451778188963, -122.406797301657) | ||||
38800 | 38800 | 248116 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6010379.57479 | 2099419.47211 | 37.745191464327995 | -122.406793240314 | (37.745191464328, -122.406793240314) | ||||
46620 | 46620 | 248114 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6010381.0463 | 2099434.05906 | 37.7452315992509 | -122.406789179902 | (37.7452315992509, -122.406789179902) | ||||
36690 | 36690 | 248115 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6010382.6698900005 | 2099427.30215 | 37.7452131370921 | -122.406783089664 | (37.7452131370921, -122.406783089664) | ||||
70123 | 70123 | 248111 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010383.711069999 | 2099443.8594400003 | 37.7452586580609 | -122.406780656096 | (37.7452586580609, -122.406780656096) | ||||
130896 | 130896 | 248113 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6010385.30327 | 2099441.28079 | 37.745251666737296 | -122.40677496881099 | (37.7452516667373, -122.406774968811) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
172182 | 172182 | 234883 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 6010542.260840001 | 2100823.35069 | 37.7490553097539 | -122.406329594845 | (37.7490553097539, -122.406329594845) | ||||
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) | ||||
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) | ||||
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) | ||||
182816 | 182816 | 234879 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 6010587.102659999 | 2100832.95642 | 37.7490841933025 | -122.406175207346 | (37.7490841933025, -122.406175207346) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
180682 | 180682 | 234876 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6010649.76891 | 2100846.09542 | 37.749123775143204 | -122.405959431208 | (37.7491237751432, -122.405959431208) | ||||
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) | ||||
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) | ||||
178954 | 178954 | 234875 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6010693.4536 | 2100854.39807 | 37.7491490155229 | -122.405808953037 | (37.7491490155229, -122.405808953037) | ||||
185485 | 185485 | 234874 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6010703.27515 | 2100855.87105 | 37.7491536092595 | -122.40577509356001 | (37.7491536092595, -122.40577509356) | ||||
169608 | 169608 | 234873 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2800 Cesar Chavez St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6010726.23893 | 2100862.83367 | 37.7491740112676 | -122.40569617445699 | (37.7491740112676, -122.405696174457) | ||||
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) | ||||
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) | ||||
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) | ||||
127197 | 127197 | 249899 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1497 Montgomery St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011381.09793 | 2120471.14228 | 37.8030504957345 | -122.404811954701 | (37.8030504957345, -122.404811954701) | |||
171284 | 171284 | 249897 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1497 Montgomery St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011384.61876 | 2120458.08201 | 37.8030148322229 | -122.40479885070101 | (37.8030148322229, -122.404798850701) | |||
74522 | 74522 | 249896 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 32 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011386.30387 | 2120437.51769 | 37.8029584618196 | -122.404791570676 | (37.8029584618196, -122.404791570676) | |||
185525 | 185525 | 249893 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 29 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 0ft | 6011394.800530001 | 2120441.53452 | 37.8029699659579 | -122.404762450627 | (37.8029699659579, -122.404762450627) | |||
61728 | 61728 | 249895 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 31 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011395.76102 | 2120447.38073 | 37.8029860719045 | -122.404759538639 | (37.8029860719045, -122.404759538639) | |||
33977 | 33977 | 249894 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 30 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011403.76038 | 2120447.63681 | 37.802987222140395 | -122.40473187458599 | (37.8029872221404, -122.404731874586) | |||
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) | |||||
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) | |||||
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) | |||||
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) | |||||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) |
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");