trees
121 rows where qSpecies_id = 82 sorted by Supervisor 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78883 | 202162 | DPW Maintained 1 | Malus :: Crab Apple 82 | 10 Kalmanovitz St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6013172.6175 | 2093312.6442 | 37.7285792692962 | -122.396707277937 | (37.7285792692962, -122.396707277937) | 10 | 3 | 8 | 58 | 1 | |||
| 80759 | 193451 | DPW Maintained 1 | Malus :: Crab Apple 82 | 760 De Haro St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 9ft | 6012093.60455 | 2104911.13829 | 37.7603661389049 | -122.401252219518 | (37.7603661389049, -122.401252219518) | 10 | 3 | 8 | 28856 | 29 | |||
| 88897 | 193452 | DPW Maintained 1 | Malus :: Crab Apple 82 | 760 San Bruno Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6010967.34674 | 2104724.5547 | 37.7597909235418 | -122.405134303232 | (37.7597909235418, -122.405134303232) | 10 | 3 | 8 | 28856 | 29 | ||||
| 90212 | 193450 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2000 18th St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011681.52321 | 2105621.1617 | 37.7622927061762 | -122.40272735948 | (37.7622927061762, -122.40272735948) | 8 | 3 | 8 | 28856 | 29 | ||||
| 90573 | 108273 | Undocumented 4 | Malus :: Crab Apple 82 | 1800x ALAMEDA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | ||||
| 90684 | 177478 | DPW Maintained 1 | Malus :: Crab Apple 82 | 87 Cora St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6009587.04075 | 2087300.588 | 37.7118711966627 | -122.408678919018 | (37.7118711966627, -122.408678919018) | 9 | 7 | 8 | 309 | 39 | |||
| 104038 | 193458 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1501 Quint St | 5 | Front Yard : Yard | Tree | Private 2 | 3 | Width 4ft | 6013271.57889 | 2096363.22177 | 37.7369610344099 | -122.396578915001 | (37.7369610344099, -122.396578915001) | 10 | 3 | 8 | 58 | 1 | |||
| 114857 | 193457 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1501 Quint St | 4 | Front Yard : Yard | Tree | Private 2 | 4 | Width 4ft | 6013271.29091 | 2096357.05994 | 37.7369440992788 | -122.396579478874 | (37.7369440992788, -122.396579478874) | 10 | 3 | 8 | 58 | 1 | |||
| 122356 | 193445 | DPW Maintained 1 | Malus :: Crab Apple 82 | 545 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6012707.67421 | 2104954.65178 | 37.7605198573339 | -122.399131478736 | (37.7605198573339, -122.399131478736) | 10 | 3 | 8 | 28856 | 29 | |||
| 126435 | 108271 | Undocumented 4 | Malus :: Crab Apple 82 | 1800x ALAMEDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | |||
| 145597 | 193447 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2 Coral Rd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6012664.55802 | 2102543.04273 | 37.7538957038432 | -122.399111318627 | (37.7538957038432, -122.399111318627) | 10 | 3 | 8 | 28856 | 29 | ||||
| 145908 | 193453 | DPW Maintained 1 | Malus :: Crab Apple 82 | 760 San Bruno Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6010968.44294 | 2104719.45404 | 37.7597769795522 | -122.405130152829 | (37.7597769795522, -122.405130152829) | 10 | 3 | 8 | 28856 | 29 | ||||
| 148705 | 193448 | DPW Maintained 1 | Malus :: Crab Apple 82 | 763 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6012158.68635 | 2104851.39826 | 37.7602057367258 | -122.40102293287 | (37.7602057367258, -122.40102293287) | 10 | 3 | 8 | 28856 | 29 | |||
| 152545 | 193459 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1501 Quint St | 6 | Front Yard : Yard | Tree | Private 2 | 3 | Width 4ft | 6013276.74454 | 2096368.79771 | 37.7369766322662 | -122.396561445667 | (37.7369766322662, -122.396561445667) | 10 | 3 | 8 | 58 | 1 | |||
| 154600 | 177475 | DPW Maintained 1 | Malus :: Crab Apple 82 | 631 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009520.83405 | 2088792.43347 | 37.7159637900627 | -122.409012944318 | (37.7159637900627, -122.409012944318) | 9 | 7 | 8 | 309 | 39 | |||
| 156246 | 193455 | DPW Maintained 1 | Malus :: Crab Apple 82 | 801 Arkansas St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6013064.65639 | 2103684.54152 | 37.7570522999402 | -122.397807739653 | (37.7570522999402, -122.397807739653) | 10 | 3 | 8 | 28856 | 29 | ||||
| 158247 | 177477 | DPW Maintained 1 | Malus :: Crab Apple 82 | 87 Cora St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6009582.84307 | 2087291.35745 | 37.7118456163483 | -122.408692776665 | (37.7118456163483, -122.408692776665) | 9 | 7 | 8 | 309 | 39 | |||
| 163573 | 193444 | DPW Maintained 1 | Malus :: Crab Apple 82 | 800 19th St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6014945.20165 | 2105329.27451 | 37.7616729293835 | -122.391419022363 | (37.7616729293835, -122.391419022363) | 10 | 3 | 8 | 28856 | 29 | |||
| 175413 | 96996 | Significant Tree 6 | Malus :: Crab Apple 82 | 2451X Griffith St | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.387194089236 | (37.7197277910807, -122.387194089236) | 10 | 3 | 8 | 58 | 1 | |||||
| 187344 | 177476 | DPW Maintained 1 | Malus :: Crab Apple 82 | 87 Cora St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6009578.57754 | 2087278.80094 | 37.7118108998241 | -122.408706634324 | (37.7118108998241, -122.408706634324) | 9 | 7 | 8 | 309 | 39 | |||
| 192547 | 108274 | Undocumented 4 | Malus :: Crab Apple 82 | 1800x ALAMEDA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 |
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) );