trees
121 rows where qSpecies_id = 82 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | ||||
146342 | 177469 | DPW Maintained 1 | Malus :: Crab Apple 82 | 200 Rome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998624.12491 | 2088874.96347 | 37.7155739618475 | -122.44668287204 | (37.7155739618475, -122.44668287204) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
22243 | 231467 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1100 San Jose Ave | 54 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6004723.8665 | 2096633.35194 | 37.7372233360818 | -122.426151410869 | (37.7372233360818, -122.426151410869) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
47430 | 231469 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1100 San Jose Ave | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6004732.5768 | 2096627.96754 | 37.7372090440461 | -122.426120912148 | (37.7372090440461, -122.426120912148) | 2 | 7 | 5 | 63 | 7 | ||||
30178 | 231494 | DPW Maintained 1 | Malus :: Crab Apple 82 | 339 Addison St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6002235.98479 | 2097691.64052 | 37.7399882198726 | -122.434828804717 | (37.7399882198726, -122.434828804717) | 2 | 7 | 5 | 63 | 7 | |||
31702 | 193449 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2000 18th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011690.74691 | 2105621.1854 | 37.7622932862384 | -122.402695459648 | (37.7622932862384, -122.402695459648) | 8 | 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 | |||
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 | |||
36495 | 193460 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1501 Quint St | 7 | Front Yard : Yard | Tree | Private 2 | 5 | Width 4ft | 6013283.26948 | 2096377.10518 | 37.736999805981 | -122.396539468037 | (37.736999805981, -122.396539468037) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||
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 | ||||
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 | |||
21017 | 111270 | DPW Maintained 1 | Malus :: Crab Apple 82 | 700X BOSWORTH ST | 8 | Front Yard : Yard | Tree | DPW 1 | 10 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
66097 | 231471 | DPW Maintained 1 | Malus :: Crab Apple 82 | 200 Kingston St | 8 | Front Yard : Yard | Tree | Private 2 | 6 | Width 8ft | 6006257.11637 | 2098029.51803 | 37.7411434377107 | -122.42094935264 | (37.7411434377107, -122.42094935264) | 2 | 7 | 7 | 28859 | 2 | |||
79973 | 208886 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100 Joost Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6001302.89972 | 2094970.3961 | 37.7324632946503 | -122.437860163028 | (37.7324632946503, -122.437860163028) | 9 | 7 | 5 | 63 | 40 | |||
127109 | 208887 | DPW Maintained 1 | Malus :: Crab Apple 82 | 747 Detroit St | 9 | Side Yard : Yard | Tree | Private 2 | 5 | 5999422.56432 | 2095411.39604 | 37.7335670730599 | -122.444392586573 | (37.7335670730599, -122.444392586573) | 9 | 7 | 4 | 59 | 40 | ||||
148199 | 231472 | DPW Maintained 1 | Malus :: Crab Apple 82 | 200 Kingston St | 9 | Front Yard : Yard | Tree | Private 2 | 4 | Width 8ft | 6006266.14334 | 2098022.56531 | 37.7411248559331 | -122.420917647057 | (37.7411248559331, -122.420917647057) | 2 | 7 | 7 | 28859 | 2 |
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) );