Data source: data.sfgov.org
This data as json, CSV (advanced)
qSiteInfo ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145632 | 145632 | 16107 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 300X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000087.992657701 | 2094703.0882103 | 37.731660169421204 | -122.44204119171499 | (37.7316601694212, -122.442041191715) | |||
78844 | 78844 | 24312 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 258X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | ||||
98506 | 98506 | 16077 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 258X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | |||
108818 | 108818 | 16074 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 258X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | |||
111702 | 111702 | 16076 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 258X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | |||
114201 | 114201 | 16075 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 258X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | |||
127845 | 127845 | 16073 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 258X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | |||
85784 | 85784 | 16046 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 200X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000746.7708385 | 2094693.2718477002 | 37.731670735926 | -122.43976296625401 | (37.731670735926, -122.439762966254) | |||
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) | ||||
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) | ||||
91038 | 91038 | 16011 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 100X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 4 | 6001411.931226401 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | |||
141148 | 141148 | 16008 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 100X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 12 | 8 | 6001411.931226401 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | ||
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) | ||||
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) | ||||
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) | ||
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) | ||
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) | |||
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) | ||||
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) | ||
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) | ||||
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) | ||||
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) | ||||
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) | |||
112123 | 112123 | 16004 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 10X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6002126.588544 | 2094889.952748 | 37.732289219947 | -122.435006728573 | (37.732289219947, -122.435006728573) | |||
11975 | 11975 | 105023 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 761 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6002706.48951 | 2088960.92893 | 37.7160423584316 | -122.432578526497 | (37.7160423584316, -122.432578526497) | |||
11816 | 11816 | 56918 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 757 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1974 12:00:00 AM | 8 | 3x3 | Permit Number 14160 | 6002721.67474 | 2088983.8970400002 | 37.716106284944 | -122.432527678806 | (37.716106284944, -122.432527678806) | |
9634 | 9634 | 59356 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 401 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/1981 12:00:00 AM | Permit Number 770924 | 6003905.57557543 | 2096316.85188886 | 37.7363080142655 | -122.428958058919 | (37.7363080142655, -122.428958058919) | |||
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) | |||
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) | ||
25766 | 25766 | 239129 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 319 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006586.63568 | 2096080.71636 | 37.735811030848204 | -122.41967175235901 | (37.7358110308482, -122.419671752359) | |||
75232 | 75232 | 239128 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 346 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006911.82474 | 2096010.5177799999 | 37.7356365938626 | -122.41854246738701 | (37.7356365938626, -122.418542467387) | |||
101946 | 101946 | 106725 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 421 CAMBRIDGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 6006955.4 | 2092560.1 | 37.7261649524701 | -122.418147266884 | (37.7261649524701, -122.418147266884) | ||||
158578 | 158578 | 239140 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 479 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007508.73883 | 2096670.3114099998 | 37.7374818291124 | -122.416525422908 | (37.7374818291124, -122.416525422908) | |||
131717 | 131717 | 239141 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 479 Andover St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007510.966109999 | 2096684.13991 | 37.73751992438871 | -122.416518701402 | (37.7375199243887, -122.416518701402) | |||
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) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
32032 | 32032 | 197020 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 2251 Silver Ave | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012818.66799 | 2096282.81423 | 37.736715035672496 | -122.398139200966 | (37.7367150356725, -122.398139200966) | |||
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) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
75148 | 75148 | 197021 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 48 Lucy St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6014107.2197 | 2093837.90133 | 37.730073491982104 | -122.39351302630199 | (37.7300734919821, -122.393513026302) | |||
149503 | 149503 | 197022 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1609 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6015117.14922 | 2096785.42707 | 37.7382228632804 | -122.39022739009701 | (37.7382228632804, -122.390227390097) | |||
35034 | 35034 | 197023 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1609 Kirkwood Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015126.90438 | 2096778.6631 | 37.738204831888 | -122.390193188884 | (37.738204831888, -122.390193188884) | |||
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) | |
9410 | 9410 | 24298 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 7 Young Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016301.484983 | 2096086.6955833 | 37.736369908087795 | -122.38608381002399 | (37.7363699080878, -122.386083810024) | |||
114263 | 114263 | 18659 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 7 Richards Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016312.43294 | 2095882.6817 | 37.7358103329414 | -122.386031740711 | (37.7358103329414, -122.386031740711) | |||
9432 | 9432 | 24299 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 10 Young Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016330.713428901 | 2096036.3150308 | 37.736233190852296 | -122.385979243301 | (37.7362331908523, -122.385979243301) | |||
92010 | 92010 | 18658 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 7 Richards Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016334.44824 | 2095879.1633400002 | 37.7358018906208 | -122.38595537929599 | (37.7358018906208, -122.385955379296) |
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");