Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82103 | 82103 | 101351 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 94717 | 94717 | 101347 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 102247 | 102247 | 101355 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 102702 | 102702 | 101349 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 110407 | 110407 | 101354 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 118971 | 118971 | 101348 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 125359 | 125359 | 101352 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 144865 | 144865 | 101346 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 600 Chestnut St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 157442 | 157442 | 44283 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 2269 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2001 12:00:00 AM | 9 | Permit Number 43705 | 6002051.58302 | 2119095.77467 | 37.7987482128118 | -122.43699837417101 | (37.7987482128118, -122.436998374171) | ||
| 82032 | 82032 | 39247 | Significant Tree 6 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 3524 Jackson St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 5x10 | Permit Number 772836 | 5997387.02929021 | 2116081.37513577 | 37.790205252620794 | -122.452921449726 | (37.7902052526208, -122.452921449726) | ||
| 79435 | 79435 | 113168 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 3902 CLAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996089.0 | 2115262.0 | 37.7878809990319 | -122.45735320225701 | (37.7878809990319, -122.457353202257) | ||||
| 115104 | 115104 | 113167 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 3902 CLAY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996089.0 | 2115262.0 | 37.7878809990319 | -122.45735320225701 | (37.7878809990319, -122.457353202257) | ||||
| 124788 | 124788 | 104692 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 2201 SUTTER ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001996.0 | 2114241.0 | 37.7854150975946 | -122.436842984948 | (37.7854150975946, -122.436842984948) | ||||
| 9761 | 9761 | 122592 | Planning Code 138.1 required 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 72 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 60892 | 60892 | 123270 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 460 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5993763.95635 | 2112364.19662 | 37.7797906029426 | -122.465186799304 | (37.7797906029426, -122.465186799304) | |||
| 165644 | 165644 | 68924 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1950 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 7 | Permit Number 32908 | 5992571.67801 | 2112081.68714 | 37.7789460828372 | -122.469290808374 | (37.7789460828372, -122.469290808374) | |
| 82169 | 82169 | 103330 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1600X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001400.4 | 2111522.1 | 37.7779158216762 | -122.438708684362 | (37.7779158216762, -122.438708684362) | ||||
| 141020 | 141020 | 103331 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1600X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001400.4 | 2111522.1 | 37.7779158216762 | -122.438708684362 | (37.7779158216762, -122.438708684362) | ||||
| 165096 | 165096 | 124496 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 2700 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5996613.10439 | 2111315.1019 | 37.7770739514615 | -122.455254565574 | (37.7770739514615, -122.455254565574) | |||
| 182249 | 182249 | 124498 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 2700 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5996593.30125 | 2111311.24634 | 37.7770622288898 | -122.455322791721 | (37.7770622288898, -122.455322791721) | |||
| 70404 | 70404 | 124499 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 2700 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5996580.00237 | 2111310.8837099997 | 37.7770604701507 | -122.45536877021601 | (37.7770604701507, -122.455368770216) | |||
| 160764 | 160764 | 124500 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 2700 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996567.31944 | 2111309.2274 | 37.7770551946305 | -122.45541252443701 | (37.7770551946305, -122.455412524437) | |||
| 23818 | 23818 | 124501 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 2700 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5996544.31989 | 2111306.29255 | 37.7770458165813 | -122.45549187441601 | (37.7770458165813, -122.455491874416) | |||
| 178384 | 178384 | 37625 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 675 17th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 9 | Permit Number 40046 | 5990637.59379 | 2110880.1121400003 | 37.7755349350232 | -122.47589373474199 | (37.7755349350232, -122.475893734742) | ||
| 150174 | 150174 | 37623 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 675 17th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 9 | Permit Number 40046 | 5990638.79232 | 2110815.35438 | 37.775357197462505 | -122.475884858491 | (37.7753571974625, -122.475884858491) | ||
| 66710 | 66710 | 37627 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 675 17th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 7 | Permit Number 40046 | 5990643.14238 | 2110768.20372 | 37.7752279868902 | -122.47586636665599 | (37.7752279868902, -122.475866366656) | ||
| 32443 | 32443 | 75280 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 675 17th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 6 | 5990643.53954 | 2110726.24693 | 37.7751128080708 | -122.47586192808001 | (37.7751128080708, -122.47586192808) | ||
| 54099 | 54099 | 74768 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1600 Cabrillo St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 8 | 5990514.864440001 | 2110644.23309 | 37.774880159247296 | -122.476301047048 | (37.7748801592473, -122.476301047048) | ||
| 135293 | 135293 | 74586 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1600 Cabrillo St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 9 | 5990452.1273300005 | 2110641.5902299997 | 37.7748692642271 | -122.47651787251499 | (37.7748692642271, -122.476517872515) | ||
| 89794 | 89794 | 103329 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1194X Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001718.9 | 2110136.9 | 37.7741305241547 | -122.437507661432 | (37.7741305241547, -122.437507661432) | ||||
| 81486 | 81486 | 103328 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 242 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3x3 | 6001866.0 | 2109053.0 | 37.7711627667236 | -122.436921205648 | (37.7711627667236, -122.436921205648) | |||
| 102585 | 102585 | 103332 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 245 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001802.8 | 2109052.7 | 37.7711583507176 | -122.43713979494301 | (37.7711583507176, -122.437139794943) | ||||
| 143218 | 143218 | 103327 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 234 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001874.0 | 2108997.0 | 37.771009459311706 | -122.43688952378 | (37.7710094593117, -122.43688952378) | ||||
| 23233 | 23233 | 5150 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 243 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2016 12:00:00 AM | 2 | 3x3 | 6001815.3824 | 2108971.2006 | 37.7709352888143 | -122.437090436044 | (37.7709352888143, -122.437090436044) | ||
| 139919 | 139919 | 103333 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 243 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001783.9 | 2108958.2 | 37.7708978028329 | -122.43719840332399 | (37.7708978028329, -122.437198403324) | ||||
| 18809 | 18809 | 5147 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 228 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2016 12:00:00 AM | 3 | 3x3 | 6001883.9625 | 2108955.9605 | 37.7708973412472 | -122.436852124872 | (37.7708973412472, -122.436852124872) | ||
| 100542 | 100542 | 103326 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 224 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001907.0 | 2108933.4 | 37.7708367050105 | -122.43677082248301 | (37.7708367050105, -122.436770822483) | ||||
| 554 | 554 | 31894 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 333 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 6 | Permit Number 35323 | 6008421.36423 | 2108725.6861900003 | 37.7706344442547 | -122.41422271959999 | (37.7706344442547, -122.4142227196) | |
| 120532 | 120532 | 103325 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 200 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001895.0 | 2108750.0 | 37.7703324520775 | -122.436799199856 | (37.7703324520775, -122.436799199856) | ||||
| 83307 | 83307 | 24349 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 85 Duboce Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2003 12:00:00 AM | 3 | 2x2 | 6006210.36104 | 2108383.4741700003 | 37.769570370002604 | -122.421846308181 | (37.7695703700026, -122.421846308181) | ||
| 159175 | 159175 | 241391 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1 Scott St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6002400.13721 | 2108362.4084400004 | 37.769296916741 | -122.43502420851401 | (37.769296916741, -122.435024208514) | |||
| 66364 | 66364 | 239126 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1451 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999586.93736 | 2107523.6297299997 | 37.766833703329 | -122.44469459688601 | (37.766833703329, -122.444694596886) | |||
| 61356 | 61356 | 239127 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1451 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999589.58615 | 2107503.40425 | 37.7667783203868 | -122.44468398129601 | (37.7667783203868, -122.444683981296) | |||
| 168706 | 168706 | 213884 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1253 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996733.912719999 | 2107071.6515099998 | 37.7654294668219 | -122.45453003065201 | (37.7654294668219, -122.454530030652) | |||
| 30939 | 30939 | 31497 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1252 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | 6 | Permit Number 44477 | 5995846.10209 | 2106936.0287 | 37.7650061226505 | -122.45759093080099 | (37.7650061226505, -122.457590930801) | |
| 39584 | 39584 | 213855 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1256 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994259.5242 | 2106932.80934 | 37.7649060173314 | -122.463078233283 | (37.7649060173314, -122.463078233283) | |||
| 136390 | 136390 | 239135 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 8 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997054.7082 | 2106607.75583 | 37.76417412116329 | -122.45338698333599 | (37.7641741211633, -122.453386983336) | |||
| 180454 | 180454 | 241397 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 132 Grattan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997957.14127 | 2106523.41576 | 37.7639942306689 | -122.45025966195 | (37.7639942306689, -122.45025966195) | |||
| 168082 | 168082 | 197009 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 200 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014260.56873 | 2106154.62322 | 37.763901134655704 | -122.393844683695 | (37.7639011346557, -122.393844683695) | |||
| 45221 | 45221 | 197010 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 200 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6014261.77906 | 2106133.05094 | 37.7638419691574 | -122.393838987388 | (37.7638419691574, -122.393838987388) | |||
| 42907 | 42907 | 213883 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1333 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995159.576219999 | 2106514.56541 | 37.7638094334909 | -122.459934903072 | (37.7638094334909, -122.459934903072) | |||
| 66791 | 66791 | 197011 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 200 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014262.15311 | 2106107.81384 | 37.7637726943902 | -122.393835927003 | (37.7637726943902, -122.393835927003) | |||
| 137454 | 137454 | 213856 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1319 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5994227.36109 | 2106511.03116 | 37.763746071749104 | -122.463158870085 | (37.7637460717491, -122.463158870085) | |||
| 185046 | 185046 | 239134 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 28 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5997077.24933 | 2106444.80273 | 37.7637279854922 | -122.45329725527 | (37.7637279854922, -122.45329725527) | |||
| 71879 | 71879 | 197012 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 200 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014262.54318 | 2106085.39774 | 37.763711166361105 | -122.393833008691 | (37.7637111663611, -122.393833008691) | |||
| 63944 | 63944 | 239138 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 249 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 5997503.33133 | 2106418.97592 | 37.7636814842479 | -122.45182171331699 | (37.7636814842479, -122.451821713317) | |||
| 162453 | 162453 | 239139 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 247 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 5997487.69645 | 2106417.0109599996 | 37.763675193483 | -122.451875647467 | (37.763675193483, -122.451875647467) | |||
| 23629 | 23629 | 197013 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 208 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6014266.34495 | 2106050.86806 | 37.7636165666862 | -122.393817442323 | (37.7636165666862, -122.393817442323) | |||
| 52813 | 52813 | 197014 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 208 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014267.3142 | 2106029.28035 | 37.763557345419 | -122.393812578804 | (37.763557345419, -122.393812578804) | |||
| 157492 | 157492 | 197015 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 208 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014265.7589 | 2106008.0241 | 37.7634988939735 | -122.393816470175 | (37.7634988939735, -122.393816470175) | |||
| 45707 | 45707 | 197016 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 208 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014268.20228 | 2105989.76799 | 37.7634489024704 | -122.393806741299 | (37.7634489024704, -122.393806741299) | |||
| 48403 | 48403 | 197017 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 208 Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014269.53802 | 2105972.3744 | 37.7634012177041 | -122.393800903811 | (37.7634012177041, -122.393800903811) | |||
| 168696 | 168696 | 197018 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 208 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6014270.00743 | 2105953.87788 | 37.763350456389205 | -122.39379798549999 | (37.7633504563892, -122.3937979855) | |||
| 69293 | 69293 | 38297 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 239 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | 14 | Permit Number 40374 | 6013208.30487 | 2105936.95317 | 37.7632449272463 | -122.39746890657699 | (37.7632449272463, -122.397468906577) | |
| 35589 | 35589 | 239133 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 48 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997104.10967 | 2106248.8991099996 | 37.7631916235237 | -122.45319021077 | (37.7631916235237, -122.45319021077) | |||
| 168156 | 168156 | 213857 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1347 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993615.825 | 2106318.1770900004 | 37.7631812975144 | -122.46525995889799 | (37.7631812975144, -122.465259958898) | |||
| 47042 | 47042 | 239132 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 48 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997107.26688 | 2106225.7182299998 | 37.763128155674295 | -122.45317761755899 | (37.7631281556743, -122.453177617559) | |||
| 32827 | 32827 | 241398 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 146 Alma St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997904.83001 | 2106203.9092200003 | 37.7631139526706 | -122.450417555946 | (37.7631139526706, -122.450417555946) | |||
| 160763 | 160763 | 239131 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 62 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997117.0518 | 2106149.37077 | 37.762919085762796 | -122.45313826323799 | (37.7629190857628, -122.453138263238) | |||
| 150664 | 150664 | 239130 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 62 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997119.03338 | 2106135.27891 | 37.762880506665894 | -122.453130392348 | (37.7628805066659, -122.453130392348) | |||
| 71830 | 71830 | 239136 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 79 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997078.63554 | 2106086.03977 | 37.762742993126395 | -122.453266558717 | (37.7627429931264, -122.453266558717) | |||
| 58772 | 58772 | 241393 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 66 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005160.70352 | 2105758.78708 | 37.7623043550961 | -122.425290238962 | (37.7623043550961, -122.425290238962) | |||
| 51528 | 51528 | 239137 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 128 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5997045.82374 | 2105845.81512 | 37.762081516563 | -122.453362698034 | (37.762081516563, -122.453362698034) | |||
| 38620 | 38620 | 213862 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1422 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5993680.98078 | 2105782.7905200003 | 37.7617150230552 | -122.464995722789 | (37.7617150230552, -122.464995722789) | |||
| 134066 | 134066 | 213858 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1427 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5992396.3175800005 | 2105723.70303 | 37.7614786263699 | -122.469434514712 | (37.7614786263699, -122.469434514712) | |||
| 160714 | 160714 | 213861 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1430 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5992443.36702 | 2105705.84611 | 37.761432314878505 | -122.46927049184299 | (37.7614323148785, -122.469270491843) | |||
| 39785 | 39785 | 213860 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1448 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5992447.46544 | 2105601.66923 | 37.7611465094251 | -122.46924873453699 | (37.7611465094251, -122.469248734537) | |||
| 75688 | 75688 | 213859 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1447 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992399.4356 | 2105595.93354 | 37.7611279851974 | -122.469414430147 | (37.7611279851974, -122.469414430147) | |||
| 135627 | 135627 | 213863 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 827 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5992302.54475 | 2105211.64406 | 37.7600672276448 | -122.469721553127 | (37.7600672276448, -122.469721553127) | |||
| 68515 | 68515 | 213907 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 9 Locksley Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5994127.50266 | 2104950.54632 | 37.759455632884396 | -122.463390998614 | (37.7594556328844, -122.463390998614) | |||
| 134659 | 134659 | 213908 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 9 Locksley Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5994103.8781 | 2104889.3347400003 | 37.7592862006088 | -122.46346826115101 | (37.7592862006088, -122.463468261151) | |||
| 150668 | 150668 | 197019 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 586 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6013514.03834 | 2104373.90914 | 37.7589701689629 | -122.39630191030399 | (37.7589701689629, -122.396301910304) | |||
| 29493 | 29493 | 213880 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 531 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5992597.19998 | 2104535.76314 | 37.7582284620821 | -122.468653311406 | (37.7582284620821, -122.468653311406) | |||
| 46802 | 46802 | 213881 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1658 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992500.1434 | 2104162.33535 | 37.7571975197705 | -122.46896179684799 | (37.7571975197705, -122.468961796848) | |||
| 29753 | 29753 | 213882 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1666 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992501.4307 | 2104115.72478 | 37.7570696136933 | -122.46895395297199 | (37.7570696136933, -122.468953952972) | |||
| 24112 | 24112 | 213879 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1667 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992447.253280001 | 2104111.52703 | 37.75705495743 | -122.469141011975 | (37.75705495743, -122.469141011975) | |||
| 166454 | 166454 | 241396 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 952 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010191.29772 | 2103654.4580900003 | 37.7568092635594 | -122.407742832678 | (37.7568092635594, -122.407742832678) | |||
| 173456 | 173456 | 213885 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 310 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5993322.888280001 | 2103946.18748 | 37.75665153504929 | -122.466100743157 | (37.7566515350493, -122.466100743157) | |||
| 167714 | 167714 | 213886 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1032 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990730.33666 | 2102492.76003 | 37.7525108935626 | -122.4749605429 | (37.7525108935626, -122.4749605429) | |||
| 39696 | 39696 | 241394 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1398 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011408.3222900005 | 2101904.99844 | 37.7520736872555 | -122.403410815482 | (37.7520736872555, -122.403410815482) | |||
| 42476 | 42476 | 241395 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 2500 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011393.117330001 | 2101862.71198 | 37.7519567286313 | -122.403460422082 | (37.7519567286313, -122.403460422082) | |||
| 45167 | 45167 | 241392 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1400 Potrero Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6010755.0647 | 2100977.86196 | 37.7494914656774 | -122.405604594682 | (37.7494914656774, -122.405604594682) | |||
| 91652 | 91652 | 7587 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 3000X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.41382093686701 | (37.7492862752884, -122.413820936867) | |||
| 76728 | 76728 | 213900 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 273 Magellan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994701.36928 | 2100318.44631 | 37.7467701108664 | -122.461070552565 | (37.7467701108664, -122.461070552565) | |||
| 60442 | 60442 | 213899 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 273 Magellan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994690.46222 | 2100307.26006 | 37.746738768579 | -122.46110745715599 | (37.746738768579, -122.461107457156) | |||
| 120553 | 120553 | 22818 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 60 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/12/1997 12:00:00 AM | 3 | 3X3 | 5998904.0126134 | 2099759.7693507997 | 37.745477066338 | -122.446498092976 | (37.745477066338, -122.446498092976) | ||
| 84527 | 84527 | 22821 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 64 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2008 12:00:00 AM | 3 | 3x3 | 5998921.4611914 | 2099744.1843889 | 37.7454352704129 | -122.446436637784 | (37.7454352704129, -122.446436637784) | ||
| 26940 | 26940 | 213898 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 521 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994465.82932 | 2099713.9197 | 37.7450966757864 | -122.461841193329 | (37.7450966757864, -122.461841193329) | |||
| 180476 | 180476 | 213897 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 2365 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5992305.54148 | 2099333.17505 | 37.7439266478918 | -122.46928331439399 | (37.7439266478918, -122.469283314394) | |||
| 155587 | 155587 | 213869 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 119 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992750.5547 | 2098352.69692 | 37.74126020928 | -122.467673282394 | (37.74126020928, -122.467673282394) |
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");