Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||
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) | |||
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) | |
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) | |||
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) | |||
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) | ||||
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) | ||
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) | ||
15890 | 15890 | 17142 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1992 12:00:00 AM | 3 | 3X3 | 6017965.0245 | 2093314.7049599998 | 37.7288504949441 | -122.380139626367 | (37.7288504949441, -122.380139626367) | ||
99391 | 99391 | 17145 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1992 12:00:00 AM | 6 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.37983116682699 | (37.7286870123052, -122.379831166827) | ||
146083 | 146083 | 17143 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/1999 12:00:00 AM | 3 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.37983116682699 | (37.7286870123052, -122.379831166827) | ||
120523 | 120523 | 61840 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1031 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21879 | 6010263.10380919 | 2103214.40384755 | 37.7556049923888 | -122.40746347613 | (37.7556049923888, -122.40746347613) | ||
20291 | 20291 | 61846 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1032 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21885 | 6010211.80559334 | 2103200.31460596 | 37.7555634350502 | -122.407639888906 | (37.7555634350502, -122.407639888906) | ||
181998 | 181998 | 141820 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1035 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004741.7405 | 2112502.8158 | 37.7807981447488 | -122.42721968229799 | (37.7807981447488, -122.427219682298) | |||
86245 | 86245 | 12329 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1035 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 4X4 | 6004738.4302199995 | 2112529.1477 | 37.7808702584368 | -122.427233010388 | (37.7808702584368, -122.427233010388) | |||
126371 | 126371 | 12330 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1035 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1993 12:00:00 AM | 6 | 4X4 | 6004740.4097 | 2112512.03764 | 37.7808233903837 | -122.427224943262 | (37.7808233903837, -122.427224943262) | ||
33985 | 33985 | 227246 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 104 Red Rock Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000168.90266 | 2100069.23534 | 37.7463989525502 | -122.442146526165 | (37.7463989525502, -122.442146526165) | |||
75453 | 75453 | 60026 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 104 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 16 | Permit Number 19514 | 6014265.094769999 | 2112604.60863 | 37.781611606035 | -122.394280648053 | (37.781611606035, -122.394280648053) | |
93685 | 93685 | 61047 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 104 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32830 | 5999375.36037511 | 2093808.9050602 | 37.7291643148165 | -122.444440655825 | (37.7291643148165, -122.444440655825) | ||
183847 | 183847 | 227240 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1041 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6005776.90584 | 2102650.34664 | 37.753804097106205 | -122.422938087332 | (37.7538040971062, -122.422938087332) | |||
37569 | 37569 | 141819 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1045 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004740.795 | 2112530.2338 | 37.7808733743326 | -122.42722490683998 | (37.7808733743326, -122.42722490684) | |||
62803 | 62803 | 141818 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1045 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004738.0171 | 2112555.418 | 37.7809423668258 | -122.427236311405 | (37.7809423668258, -122.427236311405) | |||
83552 | 83552 | 12331 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1045 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4X4 | 6004735.877669999 | 2112555.20778 | 37.7809416686235 | -122.42724369777201 | (37.7809416686235, -122.427243697772) | |||
32186 | 32186 | 73447 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1045 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 5 | 6007557.7828 | 2115066.68598 | 37.787996759296796 | -122.417659373585 | (37.7879967592968, -122.417659373585) | ||
131591 | 131591 | 70619 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1045 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 10 | 6007580.409 | 2115068.8992 | 37.7880041094384 | -122.417581247698 | (37.7880041094384, -122.417581247698) | ||
124780 | 124780 | 34389 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 105 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38137 | 6004014.39109162 | 2097091.94465812 | 37.7384424015374 | -122.428637072989 | (37.7384424015374, -122.428637072989) | ||
166204 | 166204 | 227327 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 105 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6003998.12904 | 2097070.3333 | 37.738382141325104 | -122.428691759122 | (37.7383821413251, -122.428691759122) | |||
106703 | 106703 | 61847 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1050 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21886 | 6010217.4028677 | 2103099.43948978 | 37.7552867678032 | -122.407613419659 | (37.7552867678032, -122.407613419659) | ||
53835 | 53835 | 64389 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1050 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1988 12:00:00 AM | 4 | Permit Number 25231 | 6006529.57186 | 2114155.94695 | 37.78543818176271 | -122.421152111986 | (37.7854381817627, -122.421152111986) | ||
142944 | 142944 | 61841 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1051 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1991 12:00:00 AM | Permit Number 29816 | 6010269.32300261 | 2103102.32039095 | 37.7552975843096 | -122.40743406658301 | (37.7552975843096, -122.407434066583) | ||
65546 | 65546 | 61848 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1052 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21887 | 6010218.02478734 | 2103088.23113889 | 37.755256026984 | -122.407610478643 | (37.755256026984, -122.407610478643) |
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");