trees
8 rows where PlotSize = "3X3" and qSpecies_id = 66
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16936 | 24292 | DPW Maintained 1 | Shrub :: Shrub 66 | 403 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/1992 12:00:00 AM | 3 | 3X3 | ||||||||||||
| 28264 | 4893 | DPW Maintained 1 | Shrub :: Shrub 66 | 745X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009751.8988059 | 2090059.5024837 | 37.7194558413593 | -122.408303589874 | (37.7194558413593, -122.408303589874) | 9 | 3 | 8 | 309 | 18 | |||
| 28607 | 19363 | DPW Maintained 1 | Shrub :: Shrub 66 | 738 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5992103.0127542 | 2089880.5617979 | 37.7179604248963 | -122.469295726054 | (37.7179604248963, -122.469295726054) | 9 | 8 | 6 | 64 | 24 | |||
| 78365 | 12755 | DPW Maintained 1 | Shrub :: Shrub 66 | 1733 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 3 | 3X3 | 5990033.85435 | 2114674.56985 | 37.7859184370017 | -122.478259694764 | (37.7859184370017, -122.478259694764) | 11 | 6 | 2 | 55 | 26 | ||
| 80964 | 15877 | DPW Maintained 1 | Shrub :: Shrub 66 | 5508 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/1997 12:00:00 AM | 3 | 3X3 | 5999048.25069 | 2087729.15393 | 37.7124520473945 | -122.445134579389 | (37.7124520473945, -122.445134579389) | 9 | 7 | 6 | 28861 | 25 | ||
| 92606 | 15888 | DPW Maintained 1 | Shrub :: Shrub 66 | 5625 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5998561.46984 | 2087228.13524 | 37.7110485671916 | -122.446781008521 | (37.7110485671916, -122.446781008521) | 9 | 7 | 6 | 28861 | 5 | |||
| 94409 | 9382 | DPW Maintained 1 | Shrub :: Shrub 66 | 337 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 3X3 | 6001129.4629101 | 2097791.8544146 | 37.7402004981777 | -122.438661870607 | (37.7402004981777, -122.438661870607) | 2 | 7 | 5 | 63 | 7 | |||
| 161681 | 4313 | DPW Maintained 1 | Shrub :: Shrub 66 | 727 Chenery St | 1 | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | 08/17/2013 12:00:00 AM | 3X3 | 6002321.25178 | 2095689.19659 | 37.7344948117373 | -122.434390856497 | (37.7344948117373, -122.434390856497) | 2 | 7 | 5 | 63 | 7 |
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) );