trees
172 rows where qSpecies_id = 189 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 67839 | 213904 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 82 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995638.93402 | 2093163.65377 | 37.7271787101128 | -122.457311050068 | (37.7271787101128, -122.457311050068) | 9 | 7 | 4 | 28861 | 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 | |||
| 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 | |||
| 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 | |||
| 78045 | 239129 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 319 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006586.63568 | 2096080.71636 | 37.7358110308482 | -122.419671752359 | (37.7358110308482, -122.419671752359) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | ||||
| 87882 | 213906 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 1434 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995899.59842 | 2093547.71862 | 37.7282482279527 | -122.456437701364 | (37.7282482279527, -122.456437701364) | 9 | 7 | 4 | 28861 | 40 | |||
| 92123 | 239141 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 479 Andover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007510.96611 | 2096684.13991 | 37.7375199243887 | -122.416518701402 | (37.7375199243887, -122.416518701402) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 122207 | 239140 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 479 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007508.73883 | 2096670.31141 | 37.7374818291124 | -122.416525422908 | (37.7374818291124, -122.416525422908) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 140035 | 56918 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 757 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1974 12:00:00 AM | 8 | 3x3 | Permit Number 14160 | 6002721.67474 | 2088983.89704 | 37.716106284944 | -122.432527678806 | (37.716106284944, -122.432527678806) | 9 | 7 | 6 | 28861 | 5 | |
| 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 | |||
| 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 | ||||
| 166771 | 22818 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 60 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/12/1997 12:00:00 AM | 3 | 3X3 | 5998904.0126134 | 2099759.7693508 | 37.745477066338 | -122.446498092976 | (37.745477066338, -122.446498092976) | 2 | 7 | 5 | 63 | 7 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 186617 | 213903 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 82 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995638.7479 | 2093177.24169 | 37.7272160085872 | -122.457312676053 | (37.7272160085872, -122.457312676053) | 9 | 7 | 4 | 28861 | 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 | |||
| 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 | |||
| 192760 | 59356 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 401 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/1981 12:00:00 AM | Permit Number 770924 | 6003905.57557543 | 2096316.85188886 | 37.7363080142655 | -122.428958058919 | (37.7363080142655, -122.428958058919) | 2 | 7 | 5 | 63 | 7 | |||
| 193336 | 213901 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 95 Westwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995124.96941 | 2093273.24619 | 37.7274500913228 | -122.459095741174 | (37.7274500913228, -122.459095741174) | 9 | 7 | 4 | 28861 | 40 | |||
| 4878 | 213890 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 404 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991686.41791 | 2097763.49025 | 37.7395808980372 | -122.47130973605 | (37.7395808980372, -122.47130973605) | 1 | 8 | 4 | 29491 | 40 | |||
| 7910 | 213897 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2365 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5992305.54148 | 2099333.17505 | 37.7439266478918 | -122.469283314394 | (37.7439266478918, -122.469283314394) | 1 | 8 | 4 | 29491 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 33762 | 213899 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 273 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994690.46222 | 2100307.26006 | 37.746738768579 | -122.461107457156 | (37.746738768579, -122.461107457156) | 1 | 8 | 4 | 29491 | 40 | |||
| 49440 | 213894 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 740 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990581.97816 | 2097726.13845 | 37.739414390369 | -122.47512564584 | (37.739414390369, -122.47512564584) | 1 | 8 | 4 | 29491 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 68194 | 213895 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 744 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990568.43351 | 2097726.13088 | 37.739413584555 | -122.475172476244 | (37.739413584555, -122.475172476244) | 1 | 8 | 4 | 29491 | 40 | |||
| 69711 | 213892 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 734 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990616.45042 | 2097727.17 | 37.7394192206197 | -122.475006532441 | (37.7394192206197, -122.475006532441) | 1 | 8 | 4 | 29491 | 40 | |||
| 82002 | 213900 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 273 Magellan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994701.36928 | 2100318.44631 | 37.7467701108664 | -122.461070552565 | (37.7467701108664, -122.461070552565) | 1 | 8 | 4 | 29491 | 40 | |||
| 83136 | 84676 | Permitted Site 7 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 25 Josiah Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49727 | 5996908.75152474 | 2089951.72351373 | 37.7184323567088 | -122.452689612121 | (37.7184323567088, -122.452689612121) | 9 | 8 | 6 | 28861 | 24 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 110303 | 213889 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2595 15th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991720.61669 | 2097822.06078 | 37.739743696013 | -122.471195758689 | (37.739743696013, -122.471195758689) | 1 | 8 | 4 | 29491 | 40 | |||
| 111997 | 213888 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2595 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991720.70941 | 2097838.59924 | 37.739789111779 | -122.471196642726 | (37.739789111779, -122.471196642726) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 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 | |||
| 126237 | 213898 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 521 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994465.82932 | 2099713.9197 | 37.7450966757864 | -122.461841193329 | (37.7450966757864, -122.461841193329) | 1 | 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 | |||
| 134118 | 213896 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 750 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990556.3666 | 2097726.38561 | 37.7394135845816 | -122.475214216469 | (37.7394135845816, -122.475214216469) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 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 | |||
| 147413 | 213891 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 730 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990628.53589 | 2097727.79467 | 37.7394216362019 | -122.474964792217 | (37.7394216362019, -122.474964792217) | 1 | 8 | 4 | 29491 | 40 | |||
| 162837 | 213887 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2567 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991715.1256 | 2097973.83861 | 37.7401601216784 | -122.471225799651 | (37.7401601216784, -122.471225799651) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 183594 | 213893 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 738 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990593.74457 | 2097725.59661 | 37.7394135845647 | -122.475084923648 | (37.7394135845647, -122.475084923648) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 150038 | 44283 | DPW Maintained 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 2269 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2001 12:00:00 AM | 9 | Permit Number 43705 | 6002051.58302 | 2119095.77467 | 37.7987482128118 | -122.436998374171 | (37.7987482128118, -122.436998374171) | 13 | 9 | 1 | 57 | 17 |
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) );