trees
121 rows where qSpecies_id = 82 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 107357 | 208890 | DPW Maintained 1 | Malus :: Crab Apple 82 | 843 Detroit St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 5999418.03526 | 2095622.98585 | 37.734147790474 | -122.444423445903 | (37.734147790474, -122.444423445903) | 9 | 7 | 4 | 59 | 40 | |||
| 108991 | 231481 | DPW Maintained 1 | Malus :: Crab Apple 82 | 60 Murray St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6004906.20838 | 2095274.16541 | 37.7335016194909 | -122.425424273006 | (37.7335016194909, -122.425424273006) | 2 | 7 | 7 | 28861 | 2 | |||
| 116776 | 231468 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1100 San Jose Ave | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6004726.49867 | 2096628.95996 | 37.7372114254688 | -122.426141997667 | (37.7372114254688, -122.426141997667) | 2 | 7 | 5 | 63 | 7 | ||||
| 119727 | 231493 | DPW Maintained 1 | Malus :: Crab Apple 82 | 339 Addison St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6002237.63018 | 2097698.28157 | 37.7400065480711 | -122.434823590441 | (37.7400065480711, -122.434823590441) | 2 | 7 | 5 | 63 | 7 | |||
| 119762 | 208892 | DPW Maintained 1 | Malus :: Crab Apple 82 | 501 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5998746.62253 | 2094953.78578 | 37.7322719935398 | -122.446696588498 | (37.7322719935398, -122.446696588498) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 124887 | 177482 | DPW Maintained 1 | Malus :: Crab Apple 82 | 498 Capistrano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000792.34501 | 2092048.92501 | 37.7244125609655 | -122.439415925402 | (37.7244125609655, -122.439415925402) | 9 | 7 | 6 | 28861 | 25 | |||
| 129380 | 231473 | DPW Maintained 1 | Malus :: Crab Apple 82 | 400 Prospect Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6006235.9692 | 2097629.5715 | 37.7400440821557 | -122.420994082235 | (37.7400440821557, -122.420994082235) | 2 | 7 | 7 | 28859 | 2 | ||||
| 131051 | 208881 | DPW Maintained 1 | Malus :: Crab Apple 82 | 298 Staples Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998181.94254 | 2093824.01975 | 37.7291376502845 | -122.448567470638 | (37.7291376502845, -122.448567470638) | 9 | 7 | 4 | 28861 | 40 | ||||
| 135468 | 208894 | DPW Maintained 1 | Malus :: Crab Apple 82 | 279 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998236.07882 | 2093773.59941 | 37.7290023032069 | -122.448376688427 | (37.7290023032069, -122.448376688427) | 9 | 7 | 4 | 28861 | 40 | ||||
| 141816 | 231495 | DPW Maintained 1 | Malus :: Crab Apple 82 | 339 Addison St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6002243.19948 | 2097700.16893 | 37.7400120465212 | -122.434804469057 | (37.7400120465212, -122.434804469057) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 154390 | 208873 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1915 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5992820.79743 | 2102456.25278 | 37.7525315806908 | -122.46772878318 | (37.7525315806908, -122.46772878318) | 1 | 8 | 4 | 29491 | 12 | |||
| 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 | ||||
| 161676 | 231488 | DPW Maintained 1 | Malus :: Crab Apple 82 | 215 Grand View Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6000742.39523 | 2103201.26061 | 37.7550314072854 | -122.44038804397 | (37.7550314072854, -122.44038804397) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 166119 | 177481 | DPW Maintained 1 | Malus :: Crab Apple 82 | 498 Capistrano Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000793.16636 | 2092058.90584 | 37.7244400127919 | -122.439413801227 | (37.7244400127919, -122.439413801227) | 9 | 7 | 6 | 28861 | 25 | |||
| 187628 | 177483 | DPW Maintained 1 | Malus :: Crab Apple 82 | 37 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6005099.05752 | 2093268.21852 | 37.7280046286024 | -122.424614893969 | (37.7280046286024, -122.424614893969) | 9 | 7 | 6 | 28861 | 5 |
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) );