Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, PlantDate, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
149400 | 149400 | 196040 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6017061.14337 | 2096999.0636099998 | 37.738917102131204 | -122.383520823632 | (37.7389171021312, -122.383520823632) | |||
150116 | 150116 | 196042 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6017068.02223 | 2097008.3641400002 | 37.7389430197102 | -122.383497686772 | (37.7389430197102, -122.383497686772) | |||
152860 | 152860 | 196043 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6017069.89025 | 2097009.95172 | 37.7389474821301 | -122.38349133844801 | (37.7389474821301, -122.383491338448) | |||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
4763 | 4763 | 220524 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 110 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1974 12:00:00 AM | 38 | Width 3ft | Permit Number 14125 | 6003373.13767 | 2108706.4584 | 37.770296793780396 | -122.431683217203 | (37.7702967937804, -122.431683217203) | |
86843 | 86843 | 109377 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
96460 | 96460 | 109375 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
112237 | 112237 | 109378 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
118325 | 118325 | 109374 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
127758 | 127758 | 109376 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
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) | |||||
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) | |||
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) | |||||
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) | |||
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) | |||
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) | |||||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | ||||
51312 | 51312 | 96980 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2090@Buchanan Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 25529 | 6003561.0 | 2117963.0 | 37.7957235834131 | -122.43169438827101 | (37.7957235834131, -122.431694388271) | ||||
87484 | 87484 | 96979 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2090@Buchanan Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 25529 | 6003561.0 | 2117963.0 | 37.7957235834131 | -122.43169438827101 | (37.7957235834131, -122.431694388271) | ||||
106073 | 106073 | 96984 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2090@Buchanan Vallejo St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 25529 | 6003561.0 | 2117963.0 | 37.7957235834131 | -122.43169438827101 | (37.7957235834131, -122.431694388271) | ||||
139286 | 139286 | 96978 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2090@Buchanan Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 25529 | 6003561.0 | 2117963.0 | 37.7957235834131 | -122.43169438827101 | (37.7957235834131, -122.431694388271) | ||||
141279 | 141279 | 96981 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2090@Buchanan Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 25529 | 6003561.0 | 2117963.0 | 37.7957235834131 | -122.43169438827101 | (37.7957235834131, -122.431694388271) |
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");