trees
979 rows where qSpecies_id = 13 sorted by PlotSize descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50384 | 208857 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1 Gennessee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5997408.76137 | 2093610.56673 | 37.7285073190505 | -122.451225020336 | (37.7285073190505, -122.451225020336) | 9 | 7 | 4 | 28861 | 40 | |||
| 91895 | 230354 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 531 30th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003165.59039 | 2098301.47872 | 37.7417154299181 | -122.431658143201 | (37.7417154299181, -122.431658143201) | 2 | 7 | 5 | 63 | 7 | |||
| 140432 | 177425 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1764 Cayuga Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 5997936.35064 | 2088551.93116 | 37.7146476772225 | -122.449036862763 | (37.7146476772225, -122.449036862763) | 9 | 7 | 6 | 28861 | 25 | |||
| 3991 | 131008 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 3 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013685.84477 | 2117434.71438 | 37.7948417395127 | -122.396623287539 | (37.7948417395127, -122.396623287539) | 4 | 1 | 10 | 28860 | 6 | |||
| 34619 | 131007 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 2 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013687.07221 | 2117423.51513 | 37.7948110573238 | -122.396618254944 | (37.7948110573238, -122.396618254944) | 4 | 1 | 10 | 28860 | 6 | |||
| 68819 | 131009 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 4 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013684.35472 | 2117443.22893 | 37.7948650355324 | -122.396629040522 | (37.7948650355324, -122.396629040522) | 4 | 1 | 10 | 28860 | 6 | |||
| 9085 | 119446 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 885 32nd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5985992 | 2109886 | 37.7725349378609 | -122.491890533583 | (37.7725349378609, -122.491890533583) | 11 | 6 | 2 | 55 | 26 | |||
| 138906 | 230279 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 529 Buchanan St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6004554.65684 | 2110370.74902 | 37.774933432055 | -122.427714942505 | (37.774933432055, -122.427714942505) | 7 | 9 | 11 | 28852 | 10 | |||
| 149130 | 180633 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 500 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 11:31:00 AM | 3 | Width 6ft | 6002463.83622 | 2087495.39703 | 37.7120045661395 | -122.433312589106 | (37.7120045661395, -122.433312589106) | 9 | 7 | 6 | 28861 | 5 | ||
| 187553 | 230331 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 217 Montcalm St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 6ft | 6009886.65194 | 2099610.71375 | 37.745688979177 | -122.408511178357 | (37.745688979177, -122.408511178357) | 2 | 7 | 7 | 28859 | 2 | |||
| 863 | 230293 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006188.70146 | 2104951.15176 | 37.7601448013679 | -122.421677407793 | (37.7601448013679, -122.421677407793) | 2 | 4 | 5 | 28859 | 19 | ||
| 6004 | 230296 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006123.35153 | 2104947.42015 | 37.7601308699707 | -122.421903157405 | (37.7601308699707, -122.421903157405) | 2 | 4 | 5 | 28859 | 19 | ||
| 10512 | 230294 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006176.61067 | 2104951.77673 | 37.760145835588 | -122.421719268545 | (37.760145835588, -122.421719268545) | 2 | 4 | 5 | 28859 | 19 | ||
| 10935 | 230295 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006165.12102 | 2104950.71502 | 37.7601422724637 | -122.421758930432 | (37.7601422724637, -122.421758930432) | 2 | 4 | 5 | 28859 | 19 | ||
| 12327 | 230292 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006199.95177 | 2104950.54929 | 37.7601437815195 | -122.421638455465 | (37.7601437815195, -122.421638455465) | 2 | 4 | 5 | 28859 | 19 | ||
| 32359 | 193327 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1398 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015585.42977 | 2102602.25227 | 37.7542206208044 | -122.389014307158 | (37.7542206208044, -122.389014307158) | 10 | 3 | 8 | 28856 | 29 | |||
| 39488 | 177445 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 15 Karen Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6010506.33995 | 2091553.32971 | 37.7235998004623 | -122.405800920297 | (37.7235998004623, -122.405800920297) | 10 | 3 | 7 | 309 | 28 | |||
| 70004 | 123549 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 65 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5994237.46417 | 2115165.09446 | 37.7875084040974 | -122.463752090061 | (37.7875084040974, -122.463752090061) | 11 | 6 | 1 | 54 | 11 | |||
| 73885 | 123609 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 121 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782700 | 5995062.26821 | 2114886.47744 | 37.786790890934 | -122.460878253711 | (37.786790890934, -122.460878253711) | 11 | 6 | 1 | 54 | 11 |
| 81305 | 230322 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4089 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6003345.45819 | 2100655.86235 | 37.7481902141138 | -122.431204233783 | (37.7481902141138, -122.431204233783) | 2 | 4 | 5 | 63 | 22 | |||
| 98197 | 123608 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 121 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2018 12:00:00 AM | 19 | Width 5ft | 5995078.16732 | 2114887.75716 | 37.7867953195114 | -122.46082333969 | (37.7867953195114, -122.46082333969) | 11 | 6 | 1 | 54 | 11 | ||
| 99498 | 230304 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3689 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6005034.41688 | 2104845.09352 | 37.7597884333033 | -122.425661983621 | (37.7597884333033, -122.425661983621) | 2 | 4 | 5 | 28859 | 19 | |||
| 105404 | 230305 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3689 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6005047.22841 | 2104845.66376 | 37.7597907229735 | -122.425617715395 | (37.7597907229735, -122.425617715395) | 2 | 4 | 5 | 28859 | 19 | |||
| 150305 | 193349 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2501 18th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6010309.72434 | 2105489.81742 | 37.7618553766351 | -122.407462658778 | (37.7618553766351, -122.407462658778) | 10 | 4 | 8 | 28859 | 19 | |||
| 155325 | 208838 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1450 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 5ft | 5991176.37038 | 2105519.18149 | 37.7608464875004 | -122.473638846178 | (37.7608464875004, -122.473638846178) | 1 | 8 | 4 | 56 | 12 | |||
| 160554 | 193348 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2501 18th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6010227.27367 | 2105486.95448 | 37.7618429003376 | -122.407747622459 | (37.7618429003376, -122.407747622459) | 10 | 4 | 8 | 28859 | 19 | |||
| 161402 | 217796 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 21 Sloat Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 5991264.94517 | 2095927.55542 | 37.7345154980788 | -122.472633170284 | (37.7345154980788, -122.472633170284) | 1 | 8 | 4 | 64 | 40 | |||
| 180872 | 122238 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1645 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 5ft | 5990263.53816 | 2114709.99218 | 37.786029027112 | -122.477467650491 | (37.786029027112, -122.477467650491) | 11 | 6 | 2 | 55 | 26 | ||
| 3141 | 117754 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 406 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5983780.49053 | 2113060.07342 | 37.7811205143771 | -122.499774894109 | (37.7811205143771, -122.499774894109) | 11 | 6 | 2 | 55 | 26 | |||
| 4347 | 174997 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 61 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 4ft | 6000632.91251 | 2088182.32659 | 37.7137866806885 | -122.43968998482 | (37.7137866806885, -122.43968998482) | 9 | 7 | 6 | 28861 | 5 | ||
| 4904 | 144219 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 876 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5982678 | 2109818 | 37.7721539708604 | -122.503348768347 | (37.7721539708604, -122.503348768347) | 11 | 6 | 2 | 55 | 26 | ||
| 5427 | 146424 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2131 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6000557.07663 | 2120624.21431 | 37.8028598421591 | -122.442279615007 | (37.8028598421591, -122.442279615007) | 13 | 9 | 1 | 57 | 17 | |||
| 6056 | 147742 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 175 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2019 12:00:00 AM | 3 | Width 4ft | 5993335.44452 | 2114350.58879 | 37.7852199756724 | -122.466813637549 | (37.7852199756724, -122.466813637549) | 11 | 6 | 2 | 54 | 11 | ||
| 10191 | 117755 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 406 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2020 12:00:00 AM | 3 | Width 4ft | 5983780.25118 | 2113048.87393 | 37.7810897498012 | -122.499774894099 | (37.7810897498012, -122.499774894099) | 11 | 6 | 2 | 55 | 26 | ||
| 21839 | 230285 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 112 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6005732.266 | 2100246.49817 | 37.7472011631029 | -122.422921627052 | (37.7472011631029, -122.422921627052) | 2 | 7 | 5 | 28859 | 22 | |||
| 23346 | 177418 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 857 Dartmouth St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6009516.77243 | 2090302.76478 | 37.7201106197971 | -122.409133494811 | (37.7201106197971, -122.409133494811) | 9 | 3 | 7 | 309 | 28 | |||
| 26823 | 130979 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3001 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003392.63825 | 2118710.53887 | 37.7977665875245 | -122.432330365752 | (37.7977665875245, -122.432330365752) | 13 | 9 | 1 | 57 | 17 | |||
| 27143 | 193373 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013783.27133 | 2116255.65231 | 37.7916097334637 | -122.396203501097 | (37.7916097334637, -122.396203501097) | 12 | 2 | 9 | 28855 | 6 | |||
| 29659 | 250186 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 665 Parker Ave | 3 | : | Tree | Private 2 | 2 | Width 4ft | 5997220.39466 | 2110886.14724 | 37.7759309780695 | -122.4531227967 | (37.7759309780695, -122.4531227967) | 15 | 6 | 2 | 54 | 16 | |||
| 34068 | 119038 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 675 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5982249.27103 | 2111200.72651 | 37.7759253222044 | -122.504934234985 | (37.7759253222044, -122.504934234985) | 11 | 6 | 2 | 55 | 26 | |||
| 41323 | 177426 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 125 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003455.72001 | 2092686.06716 | 37.7263132250654 | -122.430254442684 | (37.7263132250654, -122.430254442684) | 9 | 7 | 6 | 28861 | 5 | |||
| 48650 | 250187 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 665 Parker Ave | 4 | : | Tree | Private 2 | 1 | Width 4ft | 5997222.68042 | 2110871.6887 | 37.7758914096851 | -122.453113845732 | (37.7758914096851, -122.453113845732) | 15 | 6 | 2 | 54 | 16 | |||
| 50977 | 130984 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 5999592.95513 | 2120888.49408 | 37.803530487293 | -122.445634974783 | (37.803530487293, -122.445634974783) | 13 | 9 | 1 | 57 | 17 | |||
| 52039 | 250725 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2715 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 782755 | 5987015.16529 | 2114429.97132 | 37.7850711441675 | -122.488685403333 | (37.7850711441675, -122.488685403333) | 11 | 6 | 1 | 55 | 33 |
| 52182 | 230325 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 30 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004684.33252 | 2103302.03118 | 37.7555317594992 | -122.426762864436 | (37.7555317594992, -122.426762864436) | 2 | 4 | 5 | 28862 | 22 | |||
| 54645 | 130980 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3001 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003394.29695 | 2118690.35312 | 37.797711256726 | -122.43232318378 | (37.797711256726, -122.43232318378) | 13 | 9 | 1 | 57 | 17 | |||
| 58397 | 177397 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 650 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002573.73742 | 2089477.35526 | 37.7174528218741 | -122.433074256169 | (37.7174528218741, -122.433074256169) | 9 | 7 | 6 | 28861 | 5 | |||
| 67172 | 193355 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 60 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013990.6766 | 2116456.52969 | 37.7921728340575 | -122.395499955167 | (37.7921728340575, -122.395499955167) | 12 | 2 | 9 | 28855 | 6 | |||
| 68596 | 123366 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 780 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994765.69029 | 2110380.32738 | 37.7744011411578 | -122.461577514019 | (37.7744011411578, -122.461577514019) | 11 | 6 | 2 | 54 | 11 | |||
| 69215 | 130967 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 213 Walnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5998523.7164 | 2115638.03819 | 37.7890530400256 | -122.448956666639 | (37.7890530400256, -122.448956666639) | 13 | 6 | 1 | 54 | 31 | |||
| 69450 | 250184 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 665 Parker Ave | 1 | : | Tree | Private 2 | 2 | Width 4ft | 5997216.13133 | 2110917.44789 | 37.7760166771611 | -122.453139804667 | (37.7760166771611, -122.453139804667) | 15 | 6 | 2 | 54 | 16 | |||
| 70653 | 208855 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 358 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5999047.68761 | 2095262.2243 | 37.7331360864596 | -122.445677914709 | (37.7331360864596, -122.445677914709) | 9 | 7 | 4 | 59 | 40 | |||
| 70704 | 208841 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2134 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993696.59277 | 2101147.80807 | 37.7489894559968 | -122.46460515623 | (37.7489894559968, -122.46460515623) | 1 | 8 | 4 | 29491 | 40 | |||
| 71965 | 124566 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3943 Sacramento St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 5995914.73243 | 2114852.94659 | 37.7867478376308 | -122.457926519067 | (37.7867478376308, -122.457926519067) | 11 | 6 | 1 | 54 | 31 | |||
| 76797 | 177417 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1x Rolph St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 4ft | 6000503.4246 | 2088653.73075 | 37.7150736797726 | -122.440171325345 | (37.7150736797726, -122.440171325345) | 9 | 7 | 6 | 28861 | 5 | |||
| 82285 | 118202 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 744 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5985103.04881 | 2110791.51915 | 37.774969236334 | -122.495032243047 | (37.774969236334, -122.495032243047) | 11 | 6 | 2 | 55 | 26 | |||
| 82405 | 130983 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 5999604.29073 | 2120890.91469 | 37.8035377808009 | -122.44559592174 | (37.8035377808009, -122.44559592174) | 13 | 9 | 1 | 57 | 17 | |||
| 84474 | 230308 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3795 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005100.08631 | 2104263.85733 | 37.7581962060976 | -122.425393501818 | (37.7581962060976, -122.425393501818) | 2 | 4 | 5 | 28859 | 19 | |||
| 86777 | 230289 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3798 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6005260.07773 | 2101390.67485 | 37.7503161538703 | -122.424635797817 | (37.7503161538703, -122.424635797817) | 2 | 4 | 5 | 28859 | 19 | |||
| 89454 | 254862 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2715 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 782755 | 5987015.16529 | 2114429.97132 | 37.7850711441675 | -122.488685403333 | (37.7850711441675, -122.488685403333) | 11 | 6 | 1 | 55 | 33 |
| 90120 | 193368 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 262 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013947.27528 | 2116186.44855 | 37.7914288402078 | -122.395631194149 | (37.7914288402078, -122.395631194149) | 12 | 2 | 9 | 28855 | 6 | |||
| 90501 | 193371 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 264 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013926.24547 | 2116163.52102 | 37.791364716756 | -122.395702350277 | (37.791364716756, -122.395702350277) | 12 | 2 | 9 | 28855 | 6 | |||
| 95844 | 193362 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 246 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014011.61838 | 2116245.86436 | 37.7915955610366 | -122.395412730824 | (37.7915955610366, -122.395412730824) | 12 | 2 | 9 | 28855 | 6 | |||
| 95963 | 123057 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 514 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5991919.13974 | 2111920.98536 | 37.7784671102548 | -122.47153646454 | (37.7784671102548, -122.47153646454) | 11 | 6 | 2 | 54 | 11 | |||
| 96765 | 208842 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 168 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993717.6087 | 2099811.01881 | 37.7453201833801 | -122.46443543704 | (37.7453201833801, -122.46443543704) | 1 | 8 | 4 | 29491 | 40 | |||
| 102407 | 193347 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 444 Mississippi St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6014042.11061 | 2105043.11718 | 37.7608370392312 | -122.394522434371 | (37.7608370392312, -122.394522434371) | 10 | 3 | 8 | 28856 | 29 | |||
| 102452 | 177446 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 323 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6003320.62443 | 2091964.27953 | 37.7243237043587 | -122.43066997804 | (37.7243237043587, -122.43066997804) | 9 | 7 | 6 | 28861 | 5 | |||
| 103563 | 193357 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 62 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014010.13309 | 2116432.89008 | 37.7921090073852 | -122.395430978058 | (37.7921090073852, -122.395430978058) | 12 | 2 | 9 | 28855 | 6 | |||
| 104830 | 177444 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 15 Karen Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010486.61044 | 2091547.46792 | 37.7235826018289 | -122.40586870937 | (37.7235826018289, -122.40586870937) | 10 | 3 | 7 | 309 | 28 | |||
| 107537 | 193351 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1752 Quesada Ave | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6014452.02014 | 2095263.45344 | 37.7340069206852 | -122.392420670182 | (37.7340069206852, -122.392420670182) | 10 | 3 | 8 | 58 | 1 | |||
| 109571 | 177421 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 0 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001079.38248 | 2091791.86287 | 37.7237230579705 | -122.438405269984 | (37.7237230579705, -122.438405269984) | 9 | 7 | 6 | 28861 | 25 | |||
| 109857 | 250185 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 665 Parker Ave | 2 | : | Tree | Private 2 | 2 | Width 4ft | 5997218.61444 | 2110901.95743 | 37.7759742867055 | -122.453130096488 | (37.7759742867055, -122.453130096488) | 15 | 6 | 2 | 54 | 16 | |||
| 110549 | 193372 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013792.54079 | 2116244.01793 | 37.7915783039417 | -122.39617061289 | (37.7915783039417, -122.39617061289) | 12 | 2 | 9 | 28855 | 6 | |||
| 114696 | 193341 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1751 22nd St | 6 | Side Yard : Yard | Tree | Private 2 | 2 | Width 4ft | 6012847.48484 | 2103764.38864 | 37.7572594461781 | -122.398564409431 | (37.7572594461781, -122.398564409431) | 10 | 3 | 8 | 28856 | 29 | |||
| 114911 | 230318 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 107 Valley St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6005160.92225 | 2099293.15868 | 37.7445512558398 | -122.424829478514 | (37.7445512558398, -122.424829478514) | 2 | 7 | 5 | 63 | 22 | |||
| 115148 | 193365 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 260 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6013979.60171 | 2116214.89575 | 37.7915087476865 | -122.395521338359 | (37.7915087476865, -122.395521338359) | 12 | 2 | 9 | 28855 | 6 | |||
| 117667 | 177448 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1022 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001291.58576 | 2086844.22821 | 37.7101500273691 | -122.437317616421 | (37.7101500273691, -122.437317616421) | 9 | 7 | 6 | 28861 | 5 | |||
| 130031 | 230321 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1297 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003909.46951 | 2100753.03201 | 37.7484889652962 | -122.429260828539 | (37.7484889652962, -122.429260828539) | 2 | 4 | 5 | 28862 | 22 | |||
| 130421 | 130982 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3601 Broderick St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5999659.44076 | 2120919.32346 | 37.8036189320344 | -122.445407117147 | (37.8036189320344, -122.445407117147) | 13 | 9 | 1 | 57 | 17 | |||
| 131934 | 193363 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 246 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014000.9996 | 2116238.17517 | 37.7915738577077 | -122.395448933038 | (37.7915738577077, -122.395448933038) | 12 | 2 | 9 | 28855 | 6 | |||
| 132118 | 147269 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 319 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | 5987740.91933 | 2113799.84011 | 37.7833833082347 | -122.48612828182 | (37.7833833082347, -122.48612828182) | 11 | 6 | 2 | 55 | 26 | |||
| 132302 | 143863 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3131 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | 5985738.04922 | 2113178.19583 | 37.78155952089 | -122.493011518265 | (37.78155952089, -122.493011518265) | 11 | 6 | 2 | 55 | 26 | |||
| 132863 | 193366 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 260 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013970.03568 | 2116205.74836 | 37.7914830990039 | -122.395553795767 | (37.7914830990039, -122.395553795767) | 12 | 2 | 9 | 28855 | 6 | |||
| 134523 | 193361 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 246 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014025.95999 | 2116259.22664 | 37.7916330483898 | -122.395364045136 | (37.7916330483898, -122.395364045136) | 12 | 2 | 9 | 28855 | 6 | |||
| 143213 | 230287 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3798 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6005284.60936 | 2101393.03847 | 37.7503240292535 | -122.424551133823 | (37.7503240292535, -122.424551133823) | 2 | 4 | 5 | 28859 | 19 | |||
| 145435 | 193364 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 260 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013990.63933 | 2116225.45086 | 37.7915383434816 | -122.395483887876 | (37.7915383434816, -122.395483887876) | 12 | 2 | 9 | 28855 | 6 | |||
| 146551 | 193370 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 262 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013935.48002 | 2116174.11264 | 37.7913943125596 | -122.39567114113 | (37.7913943125596, -122.39567114113) | 12 | 2 | 9 | 28855 | 6 | |||
| 147236 | 193369 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 262 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013943.1918 | 2116180.78279 | 37.7914130562087 | -122.395644925876 | (37.7914130562087, -122.395644925876) | 12 | 2 | 9 | 28855 | 6 | |||
| 147619 | 123367 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 780 04th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994765.80276 | 2110367.1849 | 37.7743650618625 | -122.461576171928 | (37.7743650618625, -122.461576171928) | 11 | 6 | 2 | 54 | 11 | |||
| 147690 | 193356 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 60 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014000.33626 | 2116445.25726 | 37.7921424198756 | -122.395465742269 | (37.7921424198756, -122.395465742269) | 12 | 2 | 9 | 28855 | 6 | |||
| 150870 | 193321 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2111 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6011418.14714 | 2105550.13938 | 37.7620829860523 | -122.403633286154 | (37.7620829860523, -122.403633286154) | 10 | 3 | 8 | 28856 | 29 | |||
| 151406 | 143864 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3123 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | 5985786.64325 | 2113178.68848 | 37.7815637153323 | -122.492843444866 | (37.7815637153323, -122.492843444866) | 11 | 6 | 2 | 55 | 26 | |||
| 152301 | 193350 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1752 Quesada Ave | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6014471.5284 | 2095248.21375 | 37.7339661589078 | -122.392352158028 | (37.7339661589078, -122.392352158028) | 10 | 3 | 8 | 58 | 1 | |||
| 154921 | 193359 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 208 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014052.91282 | 2116289.57894 | 37.7917178877279 | -122.395272915033 | (37.7917178877279, -122.395272915033) | 12 | 2 | 9 | 28855 | 6 | |||
| 155652 | 177422 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 0 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001061.39064 | 2091803.12496 | 37.7237529577069 | -122.438468271097 | (37.7237529577069, -122.438468271097) | 9 | 7 | 6 | 28861 | 25 | |||
| 155874 | 193320 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2111 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011400.26798 | 2105549.24377 | 37.7620795281598 | -122.403695060604 | (37.7620795281598, -122.403695060604) | 10 | 3 | 8 | 28856 | 29 | |||
| 162122 | 122152 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 263 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5991173.60125 | 2113665.47649 | 37.7832138425408 | -122.474242864812 | (37.7832138425408, -122.474242864812) | 11 | 6 | 2 | 54 | 26 | |||
| 168316 | 193322 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2111 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011436.66428 | 2105551.33646 | 37.7620873073181 | -122.403569326371 | (37.7620873073181, -122.403569326371) | 10 | 3 | 8 | 28856 | 29 | |||
| 170760 | 193358 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 62 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014021.3474 | 2116423.46881 | 37.7920837625026 | -122.395391515812 | (37.7920837625026, -122.395391515812) | 12 | 2 | 9 | 28855 | 6 | |||
| 171459 | 193328 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 900 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6015574.56777 | 2102562.74505 | 37.7541115402303 | -122.389049112743 | (37.7541115402303, -122.389049112743) | 10 | 3 | 8 | 28856 | 29 |
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) );