Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, qCareAssistant
qSiteInfo ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7848 | 7848 | 51578 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | Permit Number 47872 | |||||||||
24097 | 24097 | 177096 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 5989524.60255 | 2090740.4518099998 | 37.720172132521206 | -122.47827090148199 | (37.7201721325212, -122.478270901482) | ||||
55289 | 55289 | 177095 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | 5989637.49515 | 2090738.06528 | 37.720172132515 | -122.47788049948 | (37.720172132515, -122.47788049948) | ||||
24194 | 24194 | 122139 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5991116.38675 | 2114975.72508 | 37.7868081061645 | -122.474536454895 | (37.7868081061645, -122.474536454895) | ||||
34798 | 34798 | 122131 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.120209999 | 2115013.7594 | 37.786912464412104 | -122.47454361357 | (37.7869124644121, -122.47454361357) | ||||
44820 | 44820 | 122132 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.98152 | 2115010.99351 | 37.7869049199545 | -122.47454043173401 | (37.7869049199545, -122.474540431734) | ||||
46096 | 46096 | 122133 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5991114.065719999 | 2115007.37065 | 37.7868948615896 | -122.474546795399 | (37.7868948615896, -122.474546795399) | ||||
155404 | 155404 | 122134 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991116.74625 | 2115003.65081 | 37.78688480325761 | -122.4745372499 | (37.7868848032576, -122.4745372499) | ||||
159062 | 159062 | 122138 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5991116.91399 | 2114978.91933 | 37.7868169072323 | -122.47453486398899 | (37.7868169072323, -122.474534863989) | ||||
167000 | 167000 | 122135 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 5991115.45698 | 2114997.03818 | 37.78686657212 | -122.47454122766099 | (37.78686657212, -122.474541227661) | ||||
167324 | 167324 | 122130 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 5991115.18782 | 2115016.9633400002 | 37.7869212654547 | -122.474543613569 | (37.7869212654547, -122.474543613569) | ||||
182203 | 182203 | 122137 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991115.84231 | 2114982.60549 | 37.786826966306 | -122.47453884083001 | (37.786826966306, -122.47453884083) | ||||
186663 | 186663 | 122136 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5991117.00305 | 2114994.0290099997 | 37.786858399358294 | -122.47453565898 | (37.7868583993583, -122.47453565898) | ||||
150511 | 150511 | 207974 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995054.28957 | 2096220.4880400002 | 37.7355384364438 | -122.45955344665501 | (37.7355384364438, -122.459553446655) | |||
183099 | 183099 | 207973 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995100.87909 | 2096206.0642799998 | 37.7355015111722 | -122.459391325848 | (37.7355015111722, -122.459391325848) | |||
29762 | 29762 | 191469 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014280.37989 | 2112692.06341 | 37.7818525865622 | -122.39423389317699 | (37.7818525865622, -122.394233893177) | |||
31932 | 31932 | 191468 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014292.29593 | 2112680.8823700002 | 37.7818225483087 | -122.394191885869 | (37.7818225483087, -122.394191885869) | |||
40077 | 40077 | 191470 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6014270.7643099995 | 2112702.62209 | 37.7818810438134 | -122.39426789834499 | (37.7818810438134, -122.394267898345) | |||
166395 | 166395 | 191467 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6014304.88923 | 2112665.08125 | 37.781779861995794 | -122.394147212029 | (37.7817798619958, -122.394147212029) | |||
35744 | 35744 | 207933 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5995331.00373 | 2100187.61073 | 37.746447081563 | -122.458883881613 | (37.746447081563, -122.458883881613) | |||
56259 | 56259 | 207934 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Merced Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5995381.25357 | 2100216.22441 | 37.7465285358768 | -122.45871219562599 | (37.7465285358768, -122.458712195626) | |||
26130 | 26130 | 207916 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994697.354069999 | 2099701.1071099997 | 37.7450748213407 | -122.46103969864201 | (37.7450748213407, -122.461039698642) | |||
130205 | 130205 | 207917 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994692.52857 | 2099722.50735 | 37.7451333033531 | -122.461057935084 | (37.7451333033531, -122.461057935084) | |||
175359 | 175359 | 207915 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994699.757 | 2099675.96416 | 37.7450059233763 | -122.461029567757 | (37.7450059233763, -122.461029567757) | |||
50828 | 50828 | 129616 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6007378.23169 | 2111027.62658 | 37.776896376005396 | -122.417994148015 | (37.7768963760054, -122.417994148015) | |||
76053 | 76053 | 129617 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6007383.9261 | 2110990.71861 | 37.776795356048005 | -122.417971832253 | (37.776795356048, -122.417971832253) | |||
130102 | 130102 | 226696 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Ramona Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005201.48103 | 2107781.05684 | 37.767859329770296 | -122.42529311588999 | (37.7678593297703, -122.42529311589) | |||
156680 | 156680 | 226695 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Ramona Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005201.39938 | 2107761.16657 | 37.767804711241396 | -122.42529198274799 | (37.7678047112414, -122.425291982748) | |||
179289 | 179289 | 62212 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 11 | Permit Number 22335 | 6001303.33369 | 2093769.8822599999 | 37.729166984360795 | -122.437772711138 | (37.7291669843608, -122.437772711138) | |
48603 | 48603 | 177091 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993412.52644 | 2086599.2418 | 37.709026289400796 | -122.46453122115801 | (37.7090262894008, -122.464531221158) | |||
57617 | 57617 | 177094 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993369.32747 | 2086575.0773 | 37.708957449004394 | -122.464678768412 | (37.7089574490044, -122.464678768412) | |||
131503 | 131503 | 177093 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 5993374.13741 | 2086578.2467 | 37.7089664287264 | -122.464662374692 | (37.7089664287264, -122.464662374692) | |||
171783 | 171783 | 177092 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5993402.95207 | 2086595.08273 | 37.7090143176374 | -122.464564009531 | (37.7090143176374, -122.464564009531) | |||
71530 | 71530 | 227275 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 10 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6001741.27493 | 2099157.9473099997 | 37.7439862549578 | -122.43664423465201 | (37.7439862549578, -122.436644234652) | |||
140794 | 140794 | 33186 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 10 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37395 | 5996266.46691621 | 2100062.84329994 | 37.7461582283752 | -122.45564015783 | (37.7461582283752, -122.45564015783) | ||
68510 | 68510 | 245072 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 10 Lyon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000401.2404 | 2108998.8674 | 37.7709307712672 | -122.441983963405 | (37.7709307712672, -122.441983963405) | |||
78421 | 78421 | 88365 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 10 Lyon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51347 | 6000409.7 | 2108931.9 | 37.7707473776731 | -122.44194989411001 | (37.7707473776731, -122.44194989411) | |||
169340 | 169340 | 207955 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 10 Woodside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5996262.83861 | 2100050.55871 | 37.7461242897204 | -122.45565181617901 | (37.7461242897204, -122.455651816179) | |||
26750 | 26750 | 226747 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004809.8918 | 2108865.505 | 37.7708148320814 | -122.426724814115 | (37.7708148320814, -122.426724814115) | |||
177334 | 177334 | 226748 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004804.2033400005 | 2108897.19386 | 37.7709015204117 | -122.42674674767001 | (37.7709015204117, -122.42674674767) | |||
149329 | 149329 | 207836 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 De Montfort Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5995005.14377 | 2091917.0493299998 | 37.7237194121086 | -122.459411800719 | (37.7237194121086, -122.459411800719) | |||
107291 | 107291 | 58390 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/08/1994 12:00:00 AM | Permit Number 17524 | 5998126.0559233 | 2093810.47392433 | 37.7290972609549 | -122.44875969912201 | (37.7290972609549, -122.448759699122) | ||
149567 | 149567 | 207914 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994694.5148 | 2099649.52261 | 37.744933019846 | -122.46104577805599 | (37.744933019846, -122.461045778056) | |||
149944 | 149944 | 207913 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Merced Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5994687.05198 | 2099628.96292 | 37.7448761386401 | -122.461070093006 | (37.7448761386401, -122.461070093006) | |||
175469 | 175469 | 227244 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Red Rock Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000236.67461 | 2100097.15362 | 37.7464794715648 | -122.44191418271099 | (37.7464794715648, -122.441914182711) | |||
27413 | 27413 | 207830 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Staples Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5999312.24137 | 2093797.37115 | 37.7291290437632 | -122.444658034037 | (37.7291290437632, -122.444658034037) | |||
30591 | 30591 | 207827 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5999363.8655900005 | 2093797.08144 | 37.7291311940404 | -122.444479544704 | (37.7291311940404, -122.444479544704) | |||
39162 | 39162 | 207829 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Staples Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5999329.280119999 | 2093797.53913 | 37.7291304772829 | -122.44459914196301 | (37.7291304772829, -122.444599141963) | |||
131311 | 131311 | 207826 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 5999382.743480001 | 2093797.47195 | 37.7291333434223 | -122.444414310576 | (37.7291333434223, -122.444414310576) | |||
185719 | 185719 | 207828 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Staples Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5999348.944080001 | 2093797.91328 | 37.729132626663706 | -122.444531189165 | (37.7291326266637, -122.444531189165) | |||
44444 | 44444 | 177130 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006962.9694300005 | 2093340.1251400001 | 37.7283071587297 | -122.41817637676 | (37.7283071587297, -122.41817637676) | |||
58071 | 58071 | 177132 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6006974.89341 | 2093300.20785 | 37.728198225668 | -122.418132326164 | (37.728198225668, -122.418132326164) | |||
67652 | 67652 | 177131 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006969.3427 | 2093320.5596099999 | 37.728253794759205 | -122.418152957489 | (37.7282537947592, -122.418152957489) | |||
155596 | 155596 | 177127 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006940.5258599995 | 2093410.5584099998 | 37.728499289893996 | -122.41825895699499 | (37.728499289894, -122.418258956995) | |||
158347 | 158347 | 177126 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006914.161069999 | 2093507.1567900002 | 37.7287630439686 | -122.41835694803301 | (37.7287630439686, -122.418356948033) | |||
160583 | 160583 | 177133 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6006981.25379 | 2093279.99997 | 37.7281430972085 | -122.418108906001 | (37.7281430972085, -122.418108906001) | |||
166818 | 166818 | 177134 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6006986.52486 | 2093261.74193 | 37.7280932612704 | -122.41808938983601 | (37.7280932612704, -122.418089389836) | |||
169954 | 169954 | 177129 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006955.53979 | 2093363.24603 | 37.7283702254814 | -122.418203699955 | (37.7283702254814, -122.418203699955) | |||
185105 | 185105 | 177128 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006947.17025 | 2093387.19061 | 37.728435500994394 | -122.418234330861 | (37.7284355009944, -122.418234330861) | |||
20274 | 20274 | 10158 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1001 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6005753.82676 | 2103093.98635 | 37.7550209265961 | -122.423049430612 | (37.7550209265961, -122.423049430612) | |||
68546 | 68546 | 141822 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1001 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004770.3402 | 2112320.581 | 37.7802993903032 | -122.427107758126 | (37.7802993903032, -122.427107758126) | |||
138359 | 138359 | 12321 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1001 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004765.45239 | 2112324.5518400003 | 37.780310016849704 | -122.427124950246 | (37.7803100168497, -122.427124950246) | |||
56094 | 56094 | 141821 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1005 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004766.0857 | 2112362.1807 | 37.78041337222621 | -122.42712544032 | (37.7804133722262, -122.42712544032) | |||
7554 | 7554 | 12324 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1005 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004768.4493 | 2112339.49 | 37.780351202823205 | -122.427115646852 | (37.7803512028232, -122.427115646852) | |||
93778 | 93778 | 12323 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1005 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6004764.65332 | 2112355.43854 | 37.780394778918904 | -122.427129915227 | (37.7803947789189, -122.427129915227) | |||
18011 | 18011 | 103601 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | |||
79176 | 79176 | 103608 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | |||
81087 | 81087 | 103602 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | |||
102161 | 102161 | 103603 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | ||
102544 | 102544 | 103607 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | |||
103847 | 103847 | 103606 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | ||||
106555 | 106555 | 103605 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | |||
107186 | 107186 | 103604 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | ||
86603 | 86603 | 114790 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100x GILLETTE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013060.0 | 2086881.0 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | ||||
168055 | 168055 | 120397 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 23rd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 1ft | 5988633.138590001 | 2114628.42785 | 37.785710333915404 | -122.48310234386899 | (37.7857103339154, -122.483102343869) | |||
182263 | 182263 | 120396 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 23rd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5988633.9259 | 2114634.88666 | 37.7857281137897 | -122.48310009361099 | (37.7857281137897, -122.483100093611) | |||
134922 | 134922 | 31105 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 3 | Permit Number 34835 | 5998736.13021 | 2093248.3076400002 | 37.7275885518652 | -122.446610201415 | (37.7275885518652, -122.446610201415) | |
176161 | 176161 | 31106 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 Edna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 18 | Permit Number 34835 | 5998729.12577 | 2093250.24462 | 37.7275934702536 | -122.446634555042 | (37.7275934702536, -122.446634555042) | |
35298 | 35298 | 207929 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 San Ramon Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995760.63845 | 2092696.4312900002 | 37.7259028185378 | -122.45685654350599 | (37.7259028185378, -122.456856543506) | |||
40319 | 40319 | 207930 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 San Ramon Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995748.4181 | 2092708.16322 | 37.7259343298845 | -122.45689963632499 | (37.7259343298845, -122.456899636325) | |||
58120 | 58120 | 40227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | 12 | Permit Number 41410 | 6014381.3439 | 2112518.0178400003 | 37.78138030849961 | -122.39387241520001 | (37.7813803084996, -122.3938724152) | ||
22091 | 22091 | 10162 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1013 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6005758.27618 | 2103002.2349099996 | 37.7547692495131 | -122.42302752222099 | (37.7547692495131, -122.423027522221) | |||
99786 | 99786 | 10163 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1013 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2x2 | 6005764.7450429 | 2102960.7456767 | 37.7546556947331 | -122.423002202394 | (37.7546556947331, -122.423002202394) | |||
124281 | 124281 | 59329 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1014 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28034 | 6009143.5478602005 | 2103242.41669988 | 37.755619181383096 | -122.411337245149 | (37.7556191813831, -122.411337245149) | ||
26969 | 26969 | 67564 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1015 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/2014 12:00:00 AM | 15 | Permit Number 31116 | 6011653.24401 | 2103633.28884 | 37.756832869857995 | -122.402685364734 | (37.756832869858, -122.402685364734) | |
5679 | 5679 | 17669 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1015X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/1995 12:00:00 AM | 12 | 3X3 | 6002374.7226 | 2112093.816 | 37.779540990434604 | -122.435379071124 | (37.7795409904346, -122.435379071124) | ||
156675 | 156675 | 177064 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 102 France Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 6001373.70465 | 2090220.37665 | 37.7194248480604 | -122.437275380676 | (37.7194248480604, -122.437275380676) | |||
24752 | 24752 | 227245 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 102 Red Rock Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000206.60136 | 2100087.0389900003 | 37.746449985492504 | -122.442017446473 | (37.7464499854925, -122.442017446473) | |||
166879 | 166879 | 101482 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1021 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6011947.177080001 | 2103416.1545 | 37.7562530733255 | -122.401653568078 | (37.7562530733255, -122.401653568078) | |||
72166 | 72166 | 141893 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1025 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004747.8859 | 2112480.1251 | 37.78073618922421 | -122.427196805622 | (37.7807361892242, -122.427196805622) | |||
120368 | 120368 | 12326 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1025 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4X4 | 6004464.0 | 2112418.0 | 37.780549550881204 | -122.428174475606 | (37.7805495508812, -122.428174475606) | |||
131440 | 131440 | 141894 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1025 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004753.0858 | 2112452.2345 | 37.7806599025846 | -122.427176829429 | (37.7806599025846, -122.427176829429) | |||
141998 | 141998 | 12327 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1025 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004464.0 | 2112418.0 | 37.780549550881204 | -122.428174475606 | (37.7805495508812, -122.428174475606) | |||
1858 | 1858 | 12328 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1025 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004756.1585 | 2112422.6893 | 37.780578952523996 | -122.427164094387 | (37.780578952524, -122.427164094387) | |||
83821 | 83821 | 114799 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 103 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998130.990703201 | 2106502.59817932 | 37.7639470183873 | -122.44965687078998 | (37.7639470183873, -122.44965687079) | ||||
89620 | 89620 | 114798 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 103 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998130.990703201 | 2106502.59817932 | 37.7639470183873 | -122.44965687078998 | (37.7639470183873, -122.44965687079) | ||||
92026 | 92026 | 58585 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 103 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1979 12:00:00 AM | 3x3 | Permit Number 17781 | 5998130.990703201 | 2106502.59817932 | 37.7639470183873 | -122.44965687078998 | (37.7639470183873, -122.44965687079) | ||
95860 | 95860 | 114797 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 103 Grattan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998130.990703201 | 2106502.59817932 | 37.7639470183873 | -122.44965687078998 | (37.7639470183873, -122.44965687079) | ||||
38011 | 38011 | 226738 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010214.75588 | 2103209.35139 | 37.7555884131926 | -122.407630322978 | (37.7555884131926, -122.407630322978) | |||
14433 | 14433 | 17144 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/1997 12:00:00 AM | 3 | 3X3 | 6017899.57967 | 2093362.5240900002 | 37.728978186084 | -122.38036919809099 | (37.728978186084, -122.380369198091) |
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");