Street_Tree_List

Data source: data.sfgov.org

2,202 rows where qSpecies = 55 sorted by qAddress

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 1289.753ms · Data source: data.sfgov.org