trees
2,180 rows where qSpecies_id = 57 sorted by qAddress
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11334 | 51578 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47872 | ||||||||||||||
74377 | 177096 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 5989524.60255 | 2090740.45181 | 37.7201721325212 | -122.478270901482 | (37.7201721325212, -122.478270901482) | 1 | 8 | 4 | 64 | 14 | ||||
134830 | 177095 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 48 | 5989637.49515 | 2090738.06528 | 37.720172132515 | -122.47788049948 | (37.720172132515, -122.47788049948) | 1 | 8 | 4 | 64 | 14 | ||||
23570 | 122138 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5991116.91399 | 2114978.91933 | 37.7868169072323 | -122.474534863989 | (37.7868169072323, -122.474534863989) | 11 | 6 | 1 | 54 | 33 | ||||
26550 | 122134 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5991116.74625 | 2115003.65081 | 37.7868848032576 | -122.4745372499 | (37.7868848032576, -122.4745372499) | 11 | 6 | 1 | 54 | 33 | ||||
26834 | 122133 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5991114.06572 | 2115007.37065 | 37.7868948615896 | -122.474546795399 | (37.7868948615896, -122.474546795399) | 11 | 6 | 1 | 54 | 33 | ||||
42013 | 122135 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 5991115.45698 | 2114997.03818 | 37.78686657212 | -122.474541227661 | (37.78686657212, -122.474541227661) | 11 | 6 | 1 | 54 | 33 | ||||
74409 | 122131 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5991115.12021 | 2115013.7594 | 37.7869124644121 | -122.47454361357 | (37.7869124644121, -122.47454361357) | 11 | 6 | 1 | 54 | 33 | ||||
100229 | 122130 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 5991115.18782 | 2115016.96334 | 37.7869212654547 | -122.474543613569 | (37.7869212654547, -122.474543613569) | 11 | 6 | 1 | 54 | 33 | ||||
109978 | 122132 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5991115.98152 | 2115010.99351 | 37.7869049199545 | -122.474540431734 | (37.7869049199545, -122.474540431734) | 11 | 6 | 1 | 54 | 33 | ||||
112069 | 122139 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5991116.38675 | 2114975.72508 | 37.7868081061645 | -122.474536454895 | (37.7868081061645, -122.474536454895) | 11 | 6 | 1 | 54 | 33 | ||||
119438 | 122136 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5991117.00305 | 2114994.02901 | 37.7868583993583 | -122.47453565898 | (37.7868583993583, -122.47453565898) | 11 | 6 | 1 | 54 | 33 | ||||
181449 | 122137 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991115.84231 | 2114982.60549 | 37.786826966306 | -122.47453884083 | (37.786826966306, -122.47453884083) | 11 | 6 | 1 | 54 | 33 | ||||
38760 | 207973 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995100.87909 | 2096206.06428 | 37.7355015111722 | -122.459391325848 | (37.7355015111722, -122.459391325848) | 9 | 7 | 4 | 59 | 40 | |||
138306 | 207974 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995054.28957 | 2096220.48804 | 37.7355384364438 | -122.459553446655 | (37.7355384364438, -122.459553446655) | 9 | 7 | 4 | 59 | 40 | |||
48700 | 191468 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Jack London Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014292.29593 | 2112680.88237 | 37.7818225483087 | -122.394191885869 | (37.7818225483087, -122.394191885869) | 6 | 2 | 9 | 28856 | 6 | |||
96281 | 191467 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Jack London Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014304.88923 | 2112665.08125 | 37.7817798619958 | -122.394147212029 | (37.7817798619958, -122.394147212029) | 6 | 2 | 9 | 28856 | 6 | |||
126424 | 191469 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Jack London Aly | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014280.37989 | 2112692.06341 | 37.7818525865622 | -122.394233893177 | (37.7818525865622, -122.394233893177) | 6 | 2 | 9 | 28856 | 6 | |||
138738 | 191470 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Jack London Aly | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6014270.76431 | 2112702.62209 | 37.7818810438134 | -122.394267898345 | (37.7818810438134, -122.394267898345) | 6 | 2 | 9 | 28856 | 6 | |||
26216 | 207934 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Merced Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5995381.25357 | 2100216.22441 | 37.7465285358768 | -122.458712195626 | (37.7465285358768, -122.458712195626) | 1 | 5 | 4 | 59 | 40 | |||
139439 | 207933 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Merced Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5995331.00373 | 2100187.61073 | 37.746447081563 | -122.458883881613 | (37.746447081563, -122.458883881613) | 1 | 8 | 4 | 59 | 40 | |||
2410 | 207916 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994697.35407 | 2099701.10711 | 37.7450748213407 | -122.461039698642 | (37.7450748213407, -122.461039698642) | 1 | 8 | 4 | 59 | 40 | |||
59396 | 207915 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Pacheco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994699.757 | 2099675.96416 | 37.7450059233763 | -122.461029567757 | (37.7450059233763, -122.461029567757) | 1 | 8 | 4 | 59 | 40 | |||
83471 | 207917 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994692.52857 | 2099722.50735 | 37.7451333033531 | -122.461057935084 | (37.7451333033531, -122.461057935084) | 1 | 8 | 4 | 59 | 40 | |||
7918 | 129616 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6007378.23169 | 2111027.62658 | 37.7768963760054 | -122.417994148015 | (37.7768963760054, -122.417994148015) | 7 | 9 | 9 | 28852 | 36 | |||
167471 | 129617 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6007383.9261 | 2110990.71861 | 37.776795356048 | -122.417971832253 | (37.776795356048, -122.417971832253) | 7 | 9 | 9 | 28852 | 36 | |||
32673 | 226695 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005201.39938 | 2107761.16657 | 37.7678047112414 | -122.425291982748 | (37.7678047112414, -122.425291982748) | 8 | 4 | 5 | 28853 | 19 | |||
78062 | 226696 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Ramona Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005201.48103 | 2107781.05684 | 37.7678593297703 | -122.42529311589 | (37.7678593297703, -122.42529311589) | 8 | 4 | 5 | 28853 | 19 | |||
14672 | 62212 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 11 | Permit Number 22335 | 6001303.33369 | 2093769.88226 | 37.7291669843608 | -122.437772711138 | (37.7291669843608, -122.437772711138) | 9 | 7 | 6 | 28861 | 25 | |
147397 | 177091 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Santa Barbara Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 5993412.52644 | 2086599.2418 | 37.7090262894008 | -122.464531221158 | (37.7090262894008, -122.464531221158) | 9 | 8 | 6 | 28861 | 25 | |||
153953 | 177094 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 5993369.32747 | 2086575.0773 | 37.7089574490044 | -122.464678768412 | (37.7089574490044, -122.464678768412) | 9 | 8 | 6 | 28861 | 25 | |||
171634 | 177092 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Santa Barbara Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5993402.95207 | 2086595.08273 | 37.7090143176374 | -122.464564009531 | (37.7090143176374, -122.464564009531) | 9 | 8 | 6 | 28861 | 25 | |||
173104 | 177093 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Santa Barbara Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 5993374.13741 | 2086578.2467 | 37.7089664287264 | -122.464662374692 | (37.7089664287264, -122.464662374692) | 9 | 8 | 6 | 28861 | 25 | |||
163451 | 227275 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 10 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 6001741.27493 | 2099157.94731 | 37.7439862549578 | -122.436644234652 | (37.7439862549578, -122.436644234652) | 2 | 7 | 5 | 63 | 22 | |||
181135 | 33186 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 10 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37395 | 5996266.46691621 | 2100062.84329994 | 37.7461582283752 | -122.45564015783 | (37.7461582283752, -122.45564015783) | 1 | 5 | 4 | 59 | 40 | ||
35329 | 88365 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 10 Lyon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51347 | 6000409.7 | 2108931.9 | 37.7707473776731 | -122.44194989411 | (37.7707473776731, -122.44194989411) | 15 | 5 | 11 | 29492 | 9 | |||
136618 | 245072 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 10 Lyon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000401.2404 | 2108998.8674 | 37.7709307712672 | -122.441983963405 | (37.7709307712672, -122.441983963405) | 15 | 5 | 11 | 29492 | 9 | |||
160404 | 207955 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 10 Woodside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5996262.83861 | 2100050.55871 | 37.7461242897204 | -122.455651816179 | (37.7461242897204, -122.455651816179) | 1 | 5 | 4 | 59 | 40 | |||
107270 | 226748 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004804.20334 | 2108897.19386 | 37.7709015204117 | -122.42674674767 | (37.7709015204117, -122.42674674767) | 7 | 9 | 5 | 28852 | 10 | |||
182509 | 226747 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004809.8918 | 2108865.505 | 37.7708148320814 | -122.426724814115 | (37.7708148320814, -122.426724814115) | 7 | 9 | 5 | 28852 | 10 | |||
127448 | 207836 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 De Montfort Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5995005.14377 | 2091917.04933 | 37.7237194121086 | -122.459411800719 | (37.7237194121086, -122.459411800719) | 9 | 8 | 4 | 28861 | 24 | |||
131561 | 58390 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1994 12:00:00 AM | Permit Number 17524 | 5998126.0559233 | 2093810.47392433 | 37.7290972609549 | -122.448759699122 | (37.7290972609549, -122.448759699122) | 9 | 7 | 4 | 28861 | 40 | ||
72948 | 207914 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994694.5148 | 2099649.52261 | 37.744933019846 | -122.461045778056 | (37.744933019846, -122.461045778056) | 1 | 8 | 4 | 59 | 40 | |||
192319 | 207913 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Merced Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5994687.05198 | 2099628.96292 | 37.7448761386401 | -122.461070093006 | (37.7448761386401, -122.461070093006) | 1 | 8 | 4 | 59 | 40 | |||
140206 | 227244 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Red Rock Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6000236.67461 | 2100097.15362 | 37.7464794715648 | -122.441914182711 | (37.7464794715648, -122.441914182711) | 2 | 7 | 5 | 63 | 22 | |||
13631 | 207826 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 5999382.74348 | 2093797.47195 | 37.7291333434223 | -122.444414310576 | (37.7291333434223, -122.444414310576) | 9 | 7 | 4 | 28861 | 40 | |||
29772 | 207828 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5999348.94408 | 2093797.91328 | 37.7291326266637 | -122.444531189165 | (37.7291326266637, -122.444531189165) | 9 | 7 | 4 | 28861 | 40 | |||
63173 | 207829 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5999329.28012 | 2093797.53913 | 37.7291304772829 | -122.444599141963 | (37.7291304772829, -122.444599141963) | 9 | 7 | 4 | 28861 | 40 | |||
96553 | 207830 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5999312.24137 | 2093797.37115 | 37.7291290437632 | -122.444658034037 | (37.7291290437632, -122.444658034037) | 9 | 7 | 4 | 28861 | 40 | |||
192433 | 207827 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5999363.86559 | 2093797.08144 | 37.7291311940404 | -122.444479544704 | (37.7291311940404, -122.444479544704) | 9 | 7 | 4 | 28861 | 40 | |||
77144 | 177132 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006974.89341 | 2093300.20785 | 37.728198225668 | -122.418132326164 | (37.728198225668, -122.418132326164) | 9 | 3 | 7 | 309 | 5 | |||
86795 | 177126 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6006914.16107 | 2093507.15679 | 37.7287630439686 | -122.418356948033 | (37.7287630439686, -122.418356948033) | 9 | 3 | 7 | 309 | 5 | |||
89858 | 177129 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006955.53979 | 2093363.24603 | 37.7283702254814 | -122.418203699955 | (37.7283702254814, -122.418203699955) | 9 | 3 | 7 | 309 | 5 | |||
96997 | 177131 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006969.3427 | 2093320.55961 | 37.7282537947592 | -122.418152957489 | (37.7282537947592, -122.418152957489) | 9 | 3 | 7 | 309 | 5 | |||
101453 | 177134 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006986.52486 | 2093261.74193 | 37.7280932612704 | -122.418089389836 | (37.7280932612704, -122.418089389836) | 9 | 3 | 7 | 309 | 5 | |||
109873 | 177128 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006947.17025 | 2093387.19061 | 37.7284355009944 | -122.418234330861 | (37.7284355009944, -122.418234330861) | 9 | 3 | 7 | 309 | 5 | |||
139598 | 177127 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006940.52586 | 2093410.55841 | 37.728499289894 | -122.418258956995 | (37.728499289894, -122.418258956995) | 9 | 3 | 7 | 309 | 5 | |||
181255 | 177133 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006981.25379 | 2093279.99997 | 37.7281430972085 | -122.418108906001 | (37.7281430972085, -122.418108906001) | 9 | 3 | 7 | 309 | 5 | |||
185273 | 177130 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006962.96943 | 2093340.12514 | 37.7283071587297 | -122.41817637676 | (37.7283071587297, -122.41817637676) | 9 | 3 | 7 | 309 | 5 | |||
153600 | 10158 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1001 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6005753.82676 | 2103093.98635 | 37.7550209265961 | -122.423049430612 | (37.7550209265961, -122.423049430612) | 2 | 4 | 5 | 28859 | 19 | |||
22633 | 141822 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1001 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004770.3402 | 2112320.581 | 37.7802993903032 | -122.427107758126 | (37.7802993903032, -122.427107758126) | 7 | 9 | 11 | 29490 | 41 | |||
160331 | 12321 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1001 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004765.45239 | 2112324.55184 | 37.7803100168497 | -122.427124950246 | (37.7803100168497, -122.427124950246) | 7 | 9 | 11 | 29490 | 41 | |||
88757 | 141821 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1005 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004766.0857 | 2112362.1807 | 37.7804133722262 | -122.42712544032 | (37.7804133722262, -122.42712544032) | 7 | 9 | 11 | 29490 | 41 | |||
88265 | 12323 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1005 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6004764.65332 | 2112355.43854 | 37.7803947789189 | -122.427129915227 | (37.7803947789189, -122.427129915227) | 7 | 9 | 11 | 29490 | 41 | |||
143660 | 12324 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1005 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004768.4493 | 2112339.49 | 37.7803512028232 | -122.427115646852 | (37.7803512028232, -122.427115646852) | 7 | 9 | 11 | 29490 | 41 | |||
15127 | 103601 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
40930 | 103608 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
44926 | 103602 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
97966 | 103603 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||
107807 | 103607 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
112331 | 103606 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||||
115155 | 103605 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
126147 | 103604 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||
71923 | 114790 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 100x GILLETTE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013060 | 2086881 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | 10 | 3 | 8 | 309 | 1 | ||||
37558 | 120397 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 23rd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 1ft | 5988633.13859 | 2114628.42785 | 37.7857103339154 | -122.483102343869 | (37.7857103339154, -122.483102343869) | 11 | 6 | 2 | 55 | 26 | |||
64413 | 120396 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 23rd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 5988633.9259 | 2114634.88666 | 37.7857281137897 | -122.483100093611 | (37.7857281137897, -122.483100093611) | 11 | 6 | 2 | 55 | 26 | |||
88097 | 31105 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 3 | Permit Number 34835 | 5998736.13021 | 2093248.30764 | 37.7275885518652 | -122.446610201415 | (37.7275885518652, -122.446610201415) | 9 | 7 | 4 | 28861 | 40 | |
111106 | 31106 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 Edna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 18 | Permit Number 34835 | 5998729.12577 | 2093250.24462 | 37.7275934702536 | -122.446634555042 | (37.7275934702536, -122.446634555042) | 9 | 7 | 4 | 28861 | 40 | |
154549 | 207930 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 San Ramon Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995748.4181 | 2092708.16322 | 37.7259343298845 | -122.456899636325 | (37.7259343298845, -122.456899636325) | 9 | 7 | 4 | 28861 | 40 | |||
187081 | 207929 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 San Ramon Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995760.63845 | 2092696.43129 | 37.7259028185378 | -122.456856543506 | (37.7259028185378, -122.456856543506) | 9 | 7 | 4 | 28861 | 40 | |||
166744 | 40227 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | 12 | Permit Number 41410 | 6014381.3439 | 2112518.01784 | 37.7813803084996 | -122.3938724152 | (37.7813803084996, -122.3938724152) | 6 | 2 | 9 | 28856 | 6 | ||
113499 | 10163 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1013 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2x2 | 6005764.7450429 | 2102960.7456767 | 37.7546556947331 | -122.423002202394 | (37.7546556947331, -122.423002202394) | 2 | 4 | 5 | 28859 | 19 | |||
170995 | 10162 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1013 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6005758.27618 | 2103002.23491 | 37.7547692495131 | -122.423027522221 | (37.7547692495131, -122.423027522221) | 2 | 4 | 5 | 28859 | 19 | |||
30250 | 59329 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1014 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28034 | 6009143.5478602 | 2103242.41669988 | 37.7556191813831 | -122.411337245149 | (37.7556191813831, -122.411337245149) | 2 | 4 | 7 | 28859 | 19 | ||
44258 | 67564 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1015 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/2014 12:00:00 AM | 15 | Permit Number 31116 | 6011653.24401 | 2103633.28884 | 37.756832869858 | -122.402685364734 | (37.756832869858, -122.402685364734) | 10 | 3 | 8 | 28856 | 29 | |
58734 | 17669 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1015X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/1995 12:00:00 AM | 12 | 3X3 | 6002374.7226 | 2112093.816 | 37.7795409904346 | -122.435379071124 | (37.7795409904346, -122.435379071124) | 15 | 5 | 11 | 29490 | 41 | ||
193271 | 177064 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 102 France Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 6001373.70465 | 2090220.37665 | 37.7194248480604 | -122.437275380676 | (37.7194248480604, -122.437275380676) | 9 | 7 | 6 | 28861 | 5 | |||
136976 | 227245 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 102 Red Rock Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6000206.60136 | 2100087.03899 | 37.7464499854925 | -122.442017446473 | (37.7464499854925, -122.442017446473) | 2 | 7 | 5 | 63 | 22 | |||
168508 | 101482 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1021 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6011947.17708 | 2103416.1545 | 37.7562530733255 | -122.401653568078 | (37.7562530733255, -122.401653568078) | 10 | 3 | 8 | 28856 | 29 | |||
141474 | 141893 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1025 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004747.8859 | 2112480.1251 | 37.7807361892242 | -122.427196805622 | (37.7807361892242, -122.427196805622) | 7 | 9 | 11 | 29490 | 41 | |||
141972 | 141894 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1025 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004753.0858 | 2112452.2345 | 37.7806599025846 | -122.427176829429 | (37.7806599025846, -122.427176829429) | 7 | 9 | 11 | 29490 | 41 | |||
159052 | 12326 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1025 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 4X4 | 6004464 | 2112418 | 37.7805495508812 | -122.428174475606 | (37.7805495508812, -122.428174475606) | 7 | 9 | 11 | 29490 | 41 | |||
172888 | 12327 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1025 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004464 | 2112418 | 37.7805495508812 | -122.428174475606 | (37.7805495508812, -122.428174475606) | 7 | 9 | 11 | 29490 | 41 | |||
27441 | 12328 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1025 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004756.1585 | 2112422.6893 | 37.780578952524 | -122.427164094387 | (37.780578952524, -122.427164094387) | 7 | 9 | 11 | 29490 | 41 | |||
39157 | 114799 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 103 Grattan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998130.9907032 | 2106502.59817932 | 37.7639470183873 | -122.44965687079 | (37.7639470183873, -122.44965687079) | 15 | 5 | 11 | 29492 | 9 | ||||
61993 | 114798 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 103 Grattan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998130.9907032 | 2106502.59817932 | 37.7639470183873 | -122.44965687079 | (37.7639470183873, -122.44965687079) | 15 | 5 | 11 | 29492 | 9 | ||||
88458 | 58585 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 103 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1979 12:00:00 AM | 3x3 | Permit Number 17781 | 5998130.9907032 | 2106502.59817932 | 37.7639470183873 | -122.44965687079 | (37.7639470183873, -122.44965687079) | 15 | 5 | 11 | 29492 | 9 | ||
93252 | 114797 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 103 Grattan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998130.9907032 | 2106502.59817932 | 37.7639470183873 | -122.44965687079 | (37.7639470183873, -122.44965687079) | 15 | 5 | 11 | 29492 | 9 | ||||
148914 | 226738 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010214.75588 | 2103209.35139 | 37.7555884131926 | -122.407630322978 | (37.7555884131926, -122.407630322978) | 2 | 4 | 7 | 28859 | 19 | |||
76196 | 17144 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/1997 12:00:00 AM | 3 | 3X3 | 6017899.57967 | 2093362.52409 | 37.728978186084 | -122.380369198091 | (37.728978186084, -122.380369198091) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );