Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90274 | 90274 | 97299 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1051 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||||
| 78153 | 78153 | 104715 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3618 22nd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.42832583872601 | (37.7549616692716, -122.428325838726) | ||||
| 112529 | 112529 | 104716 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3618 22nd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.42832583872601 | (37.7549616692716, -122.428325838726) | ||||
| 97963 | 97963 | 104717 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3618 22nd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.42832583872601 | (37.7549616692716, -122.428325838726) | ||||
| 94535 | 94535 | 108345 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 99148 | 99148 | 108346 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 124212 | 124212 | 108347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 81185 | 81185 | 108348 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 3x3 | 5988501.0 | 2100296.0 | 37.746349726050894 | -122.48250892192699 | (37.7463497260509, -122.482508921927) | |||
| 129230 | 129230 | 108349 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 50099 | 50099 | 108350 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 124192 | 124192 | 108351 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 99222 | 99222 | 108353 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
| 80360 | 80360 | 110171 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
| 120525 | 120525 | 110172 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
| 94629 | 94629 | 110173 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
| 122726 | 122726 | 110174 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
| 127293 | 127293 | 110175 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
| 93107 | 93107 | 116295 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699X DETROIT ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 3x20 | 5999400.0 | 2095202.0 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | |||
| 141152 | 141152 | 116301 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699X DETROIT ST | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 3x20 | 5999400.0 | 2095202.0 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | |||
| 31654 | 31654 | 117698 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4049 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5982870.28986 | 2113072.50922 | 37.7811012062077 | -122.502924603076 | (37.7811012062077, -122.502924603076) | |||
| 135274 | 135274 | 117699 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4027 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5982983.94909 | 2113077.92837 | 37.781122765049 | -122.50253180663601 | (37.781122765049, -122.502531806636) | |||
| 76179 | 76179 | 117700 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4027 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5982971.473069999 | 2113077.09614 | 37.7811197468717 | -122.502574905114 | (37.7811197468717, -122.502574905114) | |||
| 36733 | 36733 | 117761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 39th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 5983797.475319999 | 2112772.58996 | 37.7803321653034 | -122.499694882039 | (37.7803321653034, -122.499694882039) | |||
| 44550 | 44550 | 117813 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5983481.12715 | 2111084.52953 | 37.775678674640396 | -122.500664399599 | (37.7756786746404, -122.500664399599) | |||
| 166581 | 166581 | 117814 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5983453.00574 | 2111081.1088 | 37.7756676313487 | -122.500761423942 | (37.7756676313487, -122.500761423942) | |||
| 179349 | 179349 | 117815 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 5983440.2073 | 2111080.71217 | 37.7756657909172 | -122.50080566686 | (37.7756657909172, -122.50080566686) | |||
| 149616 | 149616 | 117816 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 6ft | 5983419.54459 | 2111079.81342 | 37.775662110061 | -122.50087707664801 | (37.775662110061, -122.500877076648) | |||
| 27504 | 27504 | 117817 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 5983396.39556 | 2111078.07387 | 37.7756559745836 | -122.50095702488899 | (37.7756559745836, -122.500957024889) | |||
| 29129 | 29129 | 117930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 593 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5982838.9134599995 | 2111805.09577 | 37.7776194161311 | -122.502939294109 | (37.7776194161311, -122.502939294109) | |||
| 37574 | 37574 | 117932 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 599 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5982840.28847 | 2111742.07201 | 37.77744645210971 | -122.502929870802 | (37.7774464521097, -122.502929870802) | |||
| 43211 | 43211 | 118078 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7150 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 7ft | 5984743.66491 | 2112532.51161 | 37.7797284549829 | -122.496403902204 | (37.7797284549829, -122.496403902204) | |||
| 39296 | 39296 | 118084 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5984977.6516 | 2112422.66835 | 37.7794405616591 | -122.49558634816002 | (37.7794405616591, -122.49558634816) | |||
| 147263 | 147263 | 118085 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5984968.995209999 | 2112422.4327599998 | 37.779439407894 | -122.495616276446 | (37.779439407894, -122.495616276446) | |||
| 181808 | 181808 | 118086 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5984961.82415 | 2112422.5857 | 37.779439407892795 | -122.495641095089 | (37.7794394078928, -122.495641095089) | |||
| 76845 | 76845 | 118087 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5984956.11601 | 2112422.0770099997 | 37.7794376769099 | -122.495660804133 | (37.7794376769099, -122.495660804133) | |||
| 171608 | 171608 | 118088 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5984949.57327 | 2112422.00658 | 37.7794371003845 | -122.495683432703 | (37.7794371003845, -122.495683432703) | |||
| 178370 | 178370 | 118280 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3245 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5985532.1252 | 2110400.01193 | 37.7739193784435 | -122.493519144142 | (37.7739193784435, -122.493519144142) | |||
| 178055 | 178055 | 118281 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3245 Cabrillo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 5985519.75315 | 2110399.45496 | 37.7739171254243 | -122.493561899449 | (37.7739171254243, -122.493561899449) | |||
| 179080 | 179080 | 118669 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4550 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | 5981412.61192 | 2111005.49415 | 37.7753400136649 | -122.507813913091 | (37.7753400136649, -122.507813913091) | ||||
| 75381 | 75381 | 118704 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4225 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 5982455.1363 | 2110968.5092599997 | 37.775299830770294 | -122.504204899972 | (37.7752998307703, -122.504204899972) | |||
| 157951 | 157951 | 118705 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4225 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5982441.7055 | 2110968.62548 | 37.7752993599927 | -122.504251368027 | (37.7752993599927, -122.504251368027) | |||
| 9867 | 9867 | 118924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 855 La Playa | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | Width 4ft | 5980738.40206 | 2109808.86226 | 37.772014669966396 | -122.510057198601 | (37.7720146699664, -122.510057198601) | ||
| 43202 | 43202 | 118930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 875 La Playa | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5980751.65283 | 2109636.5801 | 37.7715424153171 | -122.509998562861 | (37.7715424153171, -122.509998562861) | |||
| 174258 | 174258 | 119070 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 601 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5981915.41012 | 2111609.48599 | 37.7770280083436 | -122.506119441606 | (37.7770280083436, -122.506119441606) | |||
| 67844 | 67844 | 119114 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 727 46th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 5ft | 5981633.48884 | 2110754.76442 | 37.7746645942414 | -122.50703125858601 | (37.7746645942414, -122.507031258586) | |||
| 67370 | 67370 | 119159 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 837 47th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5981353.13131 | 2110018.81201 | 37.7726273695738 | -122.50794642446002 | (37.7726273695738, -122.50794642446) | |||
| 184137 | 184137 | 119986 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2512 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5987630.129509999 | 2110546.4758099997 | 37.774444031255 | -122.48627264673999 | (37.774444031255, -122.48627264674) | |||
| 66797 | 66797 | 120004 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 530 29th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5986920.19544 | 2112296.72927 | 37.779208328318795 | -122.48885709710599 | (37.7792083283188, -122.488857097106) | |||
| 133819 | 133819 | 120070 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 26th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5987678.122930001 | 2115272.13774 | 37.7874221569894 | -122.48645366177401 | (37.7874221569894, -122.486453661774) | |||
| 63662 | 63662 | 120171 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2300 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5988414.35774 | 2111262.94747 | 37.7764569397419 | -122.48361242435 | (37.7764569397419, -122.48361242435) | |||
| 120444 | 120444 | 120172 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2300 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5988392.10695 | 2111261.25032 | 37.7764509846763 | -122.483689270751 | (37.7764509846763, -122.483689270751) | |||
| 30448 | 30448 | 122000 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3848 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991408.48983 | 2110002.47291 | 37.773169842884 | -122.473163026058 | (37.773169842884, -122.473163026058) | |||
| 178759 | 178759 | 122297 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991554.96298 | 2111299.05 | 37.7767383705979 | -122.472750917629 | (37.7767383705979, -122.472750917629) | |||
| 179668 | 179668 | 122298 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5991539.76663 | 2111298.7220900003 | 37.7767365905508 | -122.472803461891 | (37.7767365905508, -122.472803461891) | |||
| 53699 | 53699 | 122299 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5991529.77112 | 2111298.06861 | 37.7767342176341 | -122.472837991331 | (37.7767342176341, -122.472837991331) | |||
| 151023 | 151023 | 122300 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5991520.86035 | 2111297.3922599996 | 37.7767318447096 | -122.47286876669901 | (37.7767318447096, -122.472868766699) | |||
| 157567 | 157567 | 122301 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5991504.38073 | 2111297.95565 | 37.77673243758429 | -122.47292581513099 | (37.7767324375843, -122.472925815131) | |||
| 157967 | 157967 | 123104 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 446 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 5992530.91894 | 2112401.0043200003 | 37.779820485509504 | -122.469455059019 | (37.7798204855095, -122.469455059019) | |||
| 136321 | 136321 | 124036 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 401 Lake St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5994232.612480001 | 2114839.72684 | 37.7866147536829 | -122.46374525122101 | (37.7866147536829, -122.463745251221) | |||
| 28290 | 28290 | 124056 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 648 Funston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 5991955.56775 | 2111031.62491 | 37.776027276009 | -122.471345630007 | (37.776027276009, -122.471345630007) | |||
| 72833 | 72833 | 124057 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 648 Funston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991955.61428 | 2111026.67231 | 37.776013680206496 | -122.47134510811001 | (37.7760136802065, -122.47134510811) | |||
| 159174 | 159174 | 124497 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2700 Golden Gate Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 5996600.75625 | 2111319.20262 | 37.7770845024867 | -122.45529757783001 | (37.7770845024867, -122.45529757783) | |||
| 93609 | 93609 | 124569 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Jordan Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5996154.91779 | 2114511.96286 | 37.785825384071394 | -122.457070865676 | (37.7858253840714, -122.457070865676) | |||
| 32920 | 32920 | 129104 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2636 Union St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6000393.5421400005 | 2118227.4889 | 37.7962697496128 | -122.442673334618 | (37.7962697496128, -122.442673334618) | |||
| 71892 | 71892 | 129105 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2636 Union St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 3ft | 6000388.79124 | 2118226.33242 | 37.796266303397104 | -122.442689690586 | (37.7962663033971, -122.442689690586) | |||
| 179314 | 179314 | 129106 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2636 Union St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 6000375.51322 | 2118224.2544400003 | 37.7962598408817 | -122.442735485858 | (37.7962598408817, -122.442735485858) | |||
| 70781 | 70781 | 129107 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2636 Union St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6000367.92746 | 2118223.15682 | 37.7962563946628 | -122.442761655219 | (37.7962563946628, -122.442761655219) | |||
| 135348 | 135348 | 129109 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 59 Masonic Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 7ft | 5998845.34118 | 2114112.50917 | 37.7848827262973 | -122.447734024832 | (37.7848827262973, -122.447734024832) | |||
| 66991 | 66991 | 129110 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1119 Mason St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6009422.36839 | 2117185.06321 | 37.7939180557165 | -122.41135792653 | (37.7939180557165, -122.41135792653) | |||
| 66377 | 66377 | 129111 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1119 Mason St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6009422.93827 | 2117173.65707 | 37.793886769202 | -122.411355148517 | (37.793886769202, -122.411355148517) | |||
| 183882 | 183882 | 129112 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 10 Hastings Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007339.93679 | 2119283.26863 | 37.799562187397704 | -122.41871222699801 | (37.7995621873977, -122.418712226998) | ||||
| 39701 | 39701 | 129113 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 10 Hastings Ter | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007329.70066 | 2119282.266 | 37.7995588581063 | -122.418747576633 | (37.7995588581063, -122.418747576633) | ||||
| 64780 | 64780 | 129114 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007312.730219999 | 2119281.87279 | 37.79955682294621 | -122.41880627269899 | (37.7995568229462, -122.418806272699) | ||||
| 149094 | 149094 | 129115 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007304.145280001 | 2119280.40626 | 37.7995523128455 | -122.418835875684 | (37.7995523128455, -122.418835875684) | ||||
| 155571 | 155571 | 129116 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007272.57871 | 2119275.5487599997 | 37.7995371979413 | -122.418944762911 | (37.7995371979413, -122.418944762911) | ||||
| 41994 | 41994 | 129117 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6007264.16981 | 2119273.41538 | 37.7995308667162 | -122.418973709394 | (37.7995308667162, -122.418973709394) | ||||
| 64177 | 64177 | 129118 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1830 Jones St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 6008292.31966 | 2118791.49308 | 37.7982654693386 | -122.415381795543 | (37.7982654693386, -122.415381795543) | |||
| 161625 | 161625 | 129121 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2601 Baker St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 5999603.8651 | 2117816.91109 | 37.79509736461421 | -122.44537623445 | (37.7950973646142, -122.44537623445) | |||
| 170919 | 170919 | 129122 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2936 Divisadero St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6000570.93906 | 2118416.83736 | 37.796799761459496 | -122.442073104613 | (37.7967997614595, -122.442073104613) | |||
| 29962 | 29962 | 129123 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2495 Filbert St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6001080.52047 | 2118605.3023200002 | 37.7973462632737 | -122.44032336202801 | (37.7973462632737, -122.440323362028) | |||
| 175284 | 175284 | 129124 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2495 Filbert St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6001086.23449 | 2118606.42257 | 37.7973496645184 | -122.440303670478 | (37.7973496645184, -122.440303670478) | |||
| 37364 | 37364 | 129125 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3750 Divisadero St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6000188.47224 | 2121175.57148 | 37.8043527059816 | -122.44359480245501 | (37.8043527059816, -122.443594802455) | |||
| 167978 | 167978 | 129126 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3750 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6000189.7805 | 2121161.41053 | 37.804313898432206 | -122.443589257237 | (37.8043138984322, -122.443589257237) | |||
| 136378 | 136378 | 129127 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3740 Divisadero St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6000190.96403 | 2121152.26738 | 37.8042888612987 | -122.44358450433998 | (37.8042888612987, -122.44358450434) | |||
| 67190 | 67190 | 129128 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3740 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6000191.73272 | 2121145.1845299997 | 37.804269457536 | -122.443581335121 | (37.804269457536, -122.443581335121) | |||
| 59190 | 59190 | 129129 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3740 Divisadero St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6000192.65427 | 2121134.45107 | 37.8042400388971 | -122.44357737451901 | (37.8042400388971, -122.443577374519) | |||
| 74421 | 74421 | 129130 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3718 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6000197.85447 | 2121076.2118900004 | 37.8040804263317 | -122.443555192722 | (37.8040804263317, -122.443555192722) | |||
| 129688 | 129688 | 129131 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3542 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6000280.24975 | 2120491.13146 | 37.8024786510429 | -122.443228011273 | (37.8024786510429, -122.443228011273) | |||
| 135513 | 135513 | 129132 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3542 Divisadero St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6000281.80115 | 2120477.64903 | 37.8024417203612 | -122.443221673766 | (37.8024417203612, -122.443221673766) | |||
| 30012 | 30012 | 129133 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Chestnut St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5999835.3006 | 2119536.2494799998 | 37.799831419239204 | -122.44469907640301 | (37.7998314192392, -122.444699076403) | |||
| 167297 | 167297 | 129134 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Chestnut St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5999830.19754 | 2119535.9585700002 | 37.7998303292727 | -122.44471671391001 | (37.7998303292727, -122.44471671391) | |||
| 26195 | 26195 | 129135 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Chestnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5999824.8933 | 2119535.0164400004 | 37.7998274397471 | -122.444735000739 | (37.7998274397471, -122.444735000739) | |||
| 134864 | 134864 | 129136 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Chestnut St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 5999820.13203 | 2119534.7646 | 37.79982647655571 | -122.44475145833799 | (37.7998264765557, -122.444751458338) | |||
| 180876 | 180876 | 129137 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Chestnut St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5999807.57986 | 2119532.56963 | 37.7998197334431 | -122.44479473551 | (37.7998197334431, -122.44479473551) | |||
| 59135 | 59135 | 129138 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Chestnut St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5999775.77706 | 2119527.96815 | 37.7998052840549 | -122.444904453696 | (37.7998052840549, -122.444904453696) | |||
| 135691 | 135691 | 129139 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2540 Chestnut St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5999671.89894 | 2119513.4635 | 37.7997595292311 | -122.445262865882 | (37.7997595292311, -122.445262865882) | |||
| 54485 | 54485 | 129140 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2399 North Point St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999315.42401 | 2120440.5968400002 | 37.8022848336387 | -122.44656313629801 | (37.8022848336387, -122.446563136298) | |||
| 173057 | 173057 | 129141 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2399 North Point St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5999324.440909999 | 2120441.3696 | 37.8022874704637 | -122.44653198918002 | (37.8022874704637, -122.44653198918) | |||
| 60331 | 60331 | 129142 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2399 North Point St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5999327.82814 | 2120441.93946 | 37.802289228618 | -122.44652030878099 | (37.802289228618, -122.446520308781) | |||
| 33330 | 33330 | 129143 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2399 North Point St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999331.215369999 | 2120442.50933 | 37.8022909867986 | -122.44650862838199 | (37.8022909867986, -122.446508628382) |
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");