trees
172 rows where qSpecies_id = 189 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193768 | 101346 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 77065 | 101347 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 156483 | 101348 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 106751 | 101349 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 42166 | 101351 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 23334 | 101352 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 149873 | 101354 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 97106 | 101355 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 600 Chestnut St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 170184 | 103325 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 200 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001895 | 2108750 | 37.7703324520775 | -122.436799199856 | (37.7703324520775, -122.436799199856) | 15 | 5 | 5 | 29492 | 9 | ||||
| 109887 | 103326 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 224 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001907 | 2108933.4 | 37.7708367050105 | -122.436770822483 | (37.7708367050105, -122.436770822483) | 15 | 5 | 11 | 29492 | 9 | ||||
| 176175 | 103327 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 234 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001874 | 2108997 | 37.7710094593117 | -122.43688952378 | (37.7710094593117, -122.43688952378) | 15 | 5 | 11 | 29492 | 9 | ||||
| 42547 | 103328 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 242 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6001866 | 2109053 | 37.7711627667236 | -122.436921205648 | (37.7711627667236, -122.436921205648) | 15 | 5 | 11 | 29492 | 9 | |||
| 74091 | 103329 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1194X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001718.9 | 2110136.9 | 37.7741305241547 | -122.437507661432 | (37.7741305241547, -122.437507661432) | 15 | 5 | 11 | 29492 | 10 | ||||
| 44063 | 103330 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1600X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001400.4 | 2111522.1 | 37.7779158216762 | -122.438708684362 | (37.7779158216762, -122.438708684362) | 15 | 5 | 11 | 29490 | 41 | ||||
| 185951 | 103331 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1600X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001400.4 | 2111522.1 | 37.7779158216762 | -122.438708684362 | (37.7779158216762, -122.438708684362) | 15 | 5 | 11 | 29490 | 41 | ||||
| 109953 | 103332 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 245 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001802.8 | 2109052.7 | 37.7711583507176 | -122.437139794943 | (37.7711583507176, -122.437139794943) | 15 | 5 | 11 | 29492 | 9 | ||||
| 181441 | 103333 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 243 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001783.9 | 2108958.2 | 37.7708978028329 | -122.437198403324 | (37.7708978028329, -122.437198403324) | 15 | 5 | 11 | 29492 | 9 | ||||
| 34461 | 104692 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2201 SUTTER ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6001996 | 2114241 | 37.7854150975946 | -122.436842984948 | (37.7854150975946, -122.436842984948) | 13 | 6 | 11 | 29490 | 13 | ||||
| 57281 | 105023 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 761 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6002706.48951 | 2088960.92893 | 37.7160423584316 | -122.432578526497 | (37.7160423584316, -122.432578526497) | 9 | 7 | 6 | 28861 | 5 | |||
| 107398 | 106725 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 421 CAMBRIDGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6006955.4 | 2092560.1 | 37.7261649524701 | -122.418147266884 | (37.7261649524701, -122.418147266884) | 9 | 3 | 7 | 309 | 28 | ||||
| 84312 | 110388 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 601X JOOST AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998083 | 2094940 | 37.7321962100447 | -122.448989879749 | (37.7321962100447, -122.448989879749) | 9 | 7 | 4 | 59 | 40 | ||||
| 20187 | 110389 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 601X JOOST AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998083 | 2094940 | 37.7321962100447 | -122.448989879749 | (37.7321962100447, -122.448989879749) | 9 | 7 | 4 | 59 | 40 | ||||
| 179238 | 110390 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 601X JOOST AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998083 | 2094940 | 37.7321962100447 | -122.448989879749 | (37.7321962100447, -122.448989879749) | 9 | 7 | 4 | 59 | 40 | ||||
| 148768 | 110391 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 601X JOOST AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998083 | 2094940 | 37.7321962100447 | -122.448989879749 | (37.7321962100447, -122.448989879749) | 9 | 7 | 4 | 59 | 40 | ||||
| 159581 | 110392 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 601X JOOST AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998083 | 2094940 | 37.7321962100447 | -122.448989879749 | (37.7321962100447, -122.448989879749) | 9 | 7 | 4 | 59 | 40 | ||||
| 146524 | 113167 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 3902 CLAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996089 | 2115262 | 37.7878809990319 | -122.457353202257 | (37.7878809990319, -122.457353202257) | 11 | 6 | 1 | 54 | 31 | ||||
| 48413 | 113168 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 3902 CLAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996089 | 2115262 | 37.7878809990319 | -122.457353202257 | (37.7878809990319, -122.457353202257) | 11 | 6 | 1 | 54 | 31 | ||||
| 19209 | 122592 | Planning Code 138.1 required 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 72 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
| 65319 | 123270 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 460 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5993763.95635 | 2112364.19662 | 37.7797906029426 | -122.465186799304 | (37.7797906029426, -122.465186799304) | 11 | 6 | 2 | 54 | 11 | |||
| 88074 | 124496 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2700 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996613.10439 | 2111315.1019 | 37.7770739514615 | -122.455254565574 | (37.7770739514615, -122.455254565574) | 11 | 6 | 2 | 54 | 16 | |||
| 36098 | 124498 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2700 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996593.30125 | 2111311.24634 | 37.7770622288898 | -122.455322791721 | (37.7770622288898, -122.455322791721) | 11 | 6 | 2 | 54 | 16 | |||
| 174690 | 124499 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2700 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996580.00237 | 2111310.88371 | 37.7770604701507 | -122.455368770216 | (37.7770604701507, -122.455368770216) | 11 | 6 | 2 | 54 | 16 | |||
| 138001 | 124500 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2700 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996567.31944 | 2111309.2274 | 37.7770551946305 | -122.455412524437 | (37.7770551946305, -122.455412524437) | 11 | 6 | 2 | 54 | 16 | |||
| 60863 | 124501 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2700 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5996544.31989 | 2111306.29255 | 37.7770458165813 | -122.455491874416 | (37.7770458165813, -122.455491874416) | 11 | 6 | 2 | 54 | 16 | |||
| 136454 | 16004 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 10X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6002126.588544 | 2094889.952748 | 37.732289219947 | -122.435006728573 | (37.732289219947, -122.435006728573) | 9 | 7 | 4 | 63 | 40 | |||
| 174913 | 16008 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 100X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 04/06/1998 12:00:00 AM | 12 | 8 | 6001411.9312264 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | 9 | 7 | 4 | 63 | 40 | ||
| 72506 | 16011 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 100X Monterey Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6 | 4 | 6001411.9312264 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | 9 | 7 | 4 | 63 | 40 | |||
| 70584 | 16046 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 200X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12 | 5 | 6000746.7708385 | 2094693.2718477 | 37.731670735926 | -122.439762966254 | (37.731670735926, -122.439762966254) | 9 | 7 | 4 | 63 | 40 | |||
| 28064 | 16073 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 258X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12 | 5 | 6000364.9354737 | 2094709.7194476 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | 9 | 7 | 4 | 63 | 40 | |||
| 120955 | 16074 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 258X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12 | 5 | 6000364.9354737 | 2094709.7194476 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | 9 | 7 | 4 | 63 | 40 | |||
| 141918 | 16075 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 258X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12 | 5 | 6000364.9354737 | 2094709.7194476 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | 9 | 7 | 4 | 63 | 40 | |||
| 133234 | 16076 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 258X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12 | 5 | 6000364.9354737 | 2094709.7194476 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | 9 | 7 | 4 | 63 | 40 | |||
| 104482 | 16077 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 258X Monterey Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12 | 5 | 6000364.9354737 | 2094709.7194476 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | 9 | 7 | 4 | 63 | 40 | |||
| 192114 | 16107 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 300X Monterey Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12 | 5 | 6000087.9926577 | 2094703.0882103 | 37.7316601694212 | -122.442041191715 | (37.7316601694212, -122.442041191715) | 9 | 7 | 4 | 63 | 40 | |||
| 78893 | 16109 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 300X Monterey Blvd | 7 | Median : Cutout | Tree | DPW 1 | 12 | 5 | 6000087.9926577 | 2094703.0882103 | 37.7316601694212 | -122.442041191715 | (37.7316601694212, -122.442041191715) | 9 | 7 | 4 | 63 | 40 | |||
| 29932 | 16155 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 400X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 5 | 5999414.3973652 | 2094721.8518036 | 37.731673280479 | -122.444371284807 | (37.731673280479, -122.444371284807) | 9 | 7 | 4 | 59 | 40 | |||
| 74241 | 16157 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 400X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 5 | 5999414.3973652 | 2094721.8518036 | 37.731673280479 | -122.444371284807 | (37.731673280479, -122.444371284807) | 9 | 7 | 4 | 59 | 40 | |||
| 124242 | 16158 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 400X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 04/06/1998 12:00:00 AM | 3 | 5 | 5999414.3973652 | 2094721.8518036 | 37.731673280479 | -122.444371284807 | (37.731673280479, -122.444371284807) | 9 | 7 | 4 | 59 | 40 | ||
| 176599 | 16160 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 400X Monterey Blvd | 6 | Median : Cutout | Tree | DPW 1 | 02/18/1999 12:00:00 AM | 3 | 5 | 5999414.3973652 | 2094721.8518036 | 37.731673280479 | -122.444371284807 | (37.731673280479, -122.444371284807) | 9 | 7 | 4 | 59 | 40 | ||
| 134069 | 16186 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 460X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 5 | 5999032.7804746 | 2094728.5162104 | 37.731669798591 | -122.445691084837 | (37.731669798591, -122.445691084837) | 9 | 7 | 4 | 59 | 40 | |||
| 113125 | 16188 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 460X Monterey Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 5 | 5999032.7804746 | 2094728.5162104 | 37.731669798591 | -122.445691084837 | (37.731669798591, -122.445691084837) | 9 | 7 | 4 | 59 | 40 | |||
| 85969 | 18658 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 7 Richards Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016334.44824 | 2095879.16334 | 37.7358018906208 | -122.385955379296 | (37.7358018906208, -122.385955379296) | 10 | 3 | 8 | 58 | 1 | |||
| 136253 | 18659 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 7 Richards Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016312.43294 | 2095882.6817 | 37.7358103329414 | -122.386031740711 | (37.7358103329414, -122.386031740711) | 10 | 3 | 8 | 58 | 1 | |||
| 121640 | 197009 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 200 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014260.56873 | 2106154.62322 | 37.7639011346557 | -122.393844683695 | (37.7639011346557, -122.393844683695) | 14 | 3 | 8 | 28856 | 29 | |||
| 148206 | 197010 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 200 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014261.77906 | 2106133.05094 | 37.7638419691574 | -122.393838987388 | (37.7638419691574, -122.393838987388) | 14 | 3 | 8 | 28856 | 29 | |||
| 144384 | 197011 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 200 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014262.15311 | 2106107.81384 | 37.7637726943902 | -122.393835927003 | (37.7637726943902, -122.393835927003) | 14 | 3 | 8 | 28856 | 29 | |||
| 127921 | 197012 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 200 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014262.54318 | 2106085.39774 | 37.7637111663611 | -122.393833008691 | (37.7637111663611, -122.393833008691) | 14 | 3 | 8 | 28856 | 29 | |||
| 1486 | 197013 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 208 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014266.34495 | 2106050.86806 | 37.7636165666862 | -122.393817442323 | (37.7636165666862, -122.393817442323) | 14 | 3 | 8 | 28856 | 29 | |||
| 172463 | 197014 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 208 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014267.3142 | 2106029.28035 | 37.763557345419 | -122.393812578804 | (37.763557345419, -122.393812578804) | 14 | 3 | 8 | 28856 | 29 | |||
| 74172 | 197015 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 208 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014265.7589 | 2106008.0241 | 37.7634988939735 | -122.393816470175 | (37.7634988939735, -122.393816470175) | 14 | 3 | 8 | 28856 | 29 | |||
| 154834 | 197016 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 208 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014268.20228 | 2105989.76799 | 37.7634489024704 | -122.393806741299 | (37.7634489024704, -122.393806741299) | 14 | 3 | 8 | 28856 | 29 | |||
| 140765 | 197017 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 208 Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014269.53802 | 2105972.3744 | 37.7634012177041 | -122.393800903811 | (37.7634012177041, -122.393800903811) | 14 | 3 | 8 | 28856 | 29 | |||
| 165304 | 197018 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 208 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014270.00743 | 2105953.87788 | 37.7633504563892 | -122.3937979855 | (37.7633504563892, -122.3937979855) | 14 | 3 | 8 | 28856 | 29 | |||
| 41618 | 197019 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 586 Missouri St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6013514.03834 | 2104373.90914 | 37.7589701689629 | -122.396301910304 | (37.7589701689629, -122.396301910304) | 10 | 3 | 8 | 28856 | 29 | |||
| 73228 | 197020 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2251 Silver Ave | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6012818.66799 | 2096282.81423 | 37.7367150356725 | -122.398139200966 | (37.7367150356725, -122.398139200966) | 10 | 3 | 8 | 58 | 1 | |||
| 25591 | 197021 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 48 Lucy St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6014107.2197 | 2093837.90133 | 37.7300734919821 | -122.393513026302 | (37.7300734919821, -122.393513026302) | 10 | 3 | 8 | 58 | 1 | |||
| 100193 | 197022 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1609 Kirkwood Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6015117.14922 | 2096785.42707 | 37.7382228632804 | -122.390227390097 | (37.7382228632804, -122.390227390097) | 10 | 3 | 8 | 58 | 1 | |||
| 52390 | 197023 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1609 Kirkwood Ave | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6015126.90438 | 2096778.6631 | 37.738204831888 | -122.390193188884 | (37.738204831888, -122.390193188884) | 10 | 3 | 8 | 58 | 1 | |||
| 9672 | 213855 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1256 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994259.5242 | 2106932.80934 | 37.7649060173314 | -122.463078233283 | (37.7649060173314, -122.463078233283) | 11 | 5 | 11 | 56 | 12 | |||
| 122366 | 213856 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1319 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5994227.36109 | 2106511.03116 | 37.7637460717491 | -122.463158870085 | (37.7637460717491, -122.463158870085) | 1 | 5 | 11 | 56 | 12 | |||
| 29347 | 213857 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1347 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993615.825 | 2106318.17709 | 37.7631812975144 | -122.465259958898 | (37.7631812975144, -122.465259958898) | 1 | 8 | 11 | 56 | 12 | |||
| 114241 | 213858 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1427 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5992396.31758 | 2105723.70303 | 37.7614786263699 | -122.469434514712 | (37.7614786263699, -122.469434514712) | 1 | 8 | 4 | 56 | 12 | |||
| 140680 | 213859 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1447 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992399.4356 | 2105595.93354 | 37.7611279851974 | -122.469414430147 | (37.7611279851974, -122.469414430147) | 1 | 8 | 4 | 56 | 12 | |||
| 20481 | 213860 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1448 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5992447.46544 | 2105601.66923 | 37.7611465094251 | -122.469248734537 | (37.7611465094251, -122.469248734537) | 1 | 8 | 4 | 56 | 12 | |||
| 107321 | 213861 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1430 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5992443.36702 | 2105705.84611 | 37.7614323148785 | -122.469270491843 | (37.7614323148785, -122.469270491843) | 1 | 8 | 4 | 56 | 12 | |||
| 179205 | 213862 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1422 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5993680.98078 | 2105782.79052 | 37.7617150230552 | -122.464995722789 | (37.7617150230552, -122.464995722789) | 1 | 8 | 11 | 56 | 12 | |||
| 183975 | 213863 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 827 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5992302.54475 | 2105211.64406 | 37.7600672276448 | -122.469721553127 | (37.7600672276448, -122.469721553127) | 1 | 8 | 4 | 56 | 12 | |||
| 96077 | 213864 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 141 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992921.67848 | 2098165.74978 | 37.7407567787025 | -122.467068013472 | (37.7407567787025, -122.467068013472) | 1 | 8 | 4 | 59 | 40 | |||
| 146896 | 213865 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 141 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992915.09669 | 2098161.84312 | 37.7407456720873 | -122.467090486661 | (37.7407456720873, -122.467090486661) | 1 | 8 | 4 | 59 | 40 | |||
| 60520 | 213866 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 149 Wawona St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992897.54808 | 2098137.40144 | 37.740677548444 | -122.467149385961 | (37.740677548444, -122.467149385961) | 1 | 8 | 4 | 59 | 40 | |||
| 179516 | 213867 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 149 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992890.5132 | 2098130.93383 | 37.7406593839363 | -122.467173239557 | (37.7406593839363, -122.467173239557) | 1 | 8 | 4 | 59 | 40 | |||
| 22397 | 213868 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 119 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992740.26119 | 2098324.92506 | 37.7411833604331 | -122.467706854104 | (37.7411833604331, -122.467706854104) | 1 | 8 | 4 | 59 | 40 | |||
| 62015 | 213869 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 119 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992750.5547 | 2098352.69692 | 37.74126020928 | -122.467673282394 | (37.74126020928, -122.467673282394) | 1 | 8 | 4 | 59 | 40 | |||
| 10313 | 213870 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 340 San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992329.85759 | 2094645.8649 | 37.7310578809121 | -122.468858209345 | (37.7310578809121, -122.468858209345) | 9 | 8 | 4 | 59 | 40 | |||
| 189415 | 213871 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995619.92029 | 2093040.27058 | 37.7268388374274 | -122.457367857563 | (37.7268388374274, -122.457367857563) | 9 | 7 | 4 | 28861 | 40 | |||
| 112952 | 213872 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 59 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995621.30563 | 2093030.05014 | 37.7268108541226 | -122.457362329428 | (37.7268108541226, -122.457362329428) | 9 | 7 | 4 | 28861 | 40 | |||
| 30982 | 213873 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 59 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5995622.40469 | 2093021.42815 | 37.7267872433344 | -122.457357906543 | (37.7267872433344, -122.457357906543) | 9 | 7 | 4 | 28861 | 40 | |||
| 90737 | 213874 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 31 Northgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5994391.73766 | 2093905.51808 | 37.7291439769931 | -122.461676330511 | (37.7291439769931, -122.461676330511) | 9 | 8 | 4 | 59 | 40 | |||
| 133101 | 213875 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 31 Northgate Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994388.13111 | 2093892.32997 | 37.729107558052 | -122.46168784274 | (37.729107558052, -122.46168784274) | 9 | 8 | 4 | 59 | 40 | |||
| 26692 | 213876 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 31 Northgate Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994382.65367 | 2093880.64548 | 37.7290751599873 | -122.461705931702 | (37.7290751599873, -122.461705931702) | 9 | 8 | 4 | 59 | 40 | |||
| 182677 | 213877 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 31 Northgate Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994375.02344 | 2093863.23534 | 37.7290269167553 | -122.461731047976 | (37.7290269167553, -122.461731047976) | 9 | 8 | 4 | 59 | 40 | |||
| 104557 | 213878 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1 Northgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5994368.96004 | 2093846.3092 | 37.7289800926592 | -122.461750782687 | (37.7289800926592, -122.461750782687) | 9 | 8 | 4 | 59 | 40 | |||
| 49655 | 213879 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1667 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992447.25328 | 2104111.52703 | 37.75705495743 | -122.469141011975 | (37.75705495743, -122.469141011975) | 1 | 8 | 4 | 56 | 12 | |||
| 67523 | 213880 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 531 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5992597.19998 | 2104535.76314 | 37.7582284620821 | -122.468653311406 | (37.7582284620821, -122.468653311406) | 1 | 8 | 4 | 56 | 12 | |||
| 104510 | 213881 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1658 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992500.1434 | 2104162.33535 | 37.7571975197705 | -122.468961796848 | (37.7571975197705, -122.468961796848) | 1 | 8 | 4 | 56 | 12 | |||
| 166056 | 213882 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1666 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992501.4307 | 2104115.72478 | 37.7570696136933 | -122.468953952972 | (37.7570696136933, -122.468953952972) | 1 | 8 | 4 | 56 | 12 | |||
| 95361 | 213883 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1333 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995159.57622 | 2106514.56541 | 37.7638094334909 | -122.459934903072 | (37.7638094334909, -122.459934903072) | 15 | 5 | 11 | 56 | 12 | |||
| 110741 | 213884 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1253 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996733.91272 | 2107071.65151 | 37.7654294668219 | -122.454530030652 | (37.7654294668219, -122.454530030652) | 15 | 5 | 11 | 29492 | 12 | |||
| 118785 | 213885 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 310 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5993322.88828 | 2103946.18748 | 37.7566515350493 | -122.466100743157 | (37.7566515350493, -122.466100743157) | 1 | 8 | 4 | 56 | 12 | |||
| 83287 | 213886 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1032 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5990730.33666 | 2102492.76003 | 37.7525108935626 | -122.4749605429 | (37.7525108935626, -122.4749605429) | 1 | 8 | 4 | 56 | 12 |
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) );