trees
8 rows where Zip Codes = 28853 and qSpecies_id = 252
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36406 | 188808 | DPW Maintained 1 | Bambusa spp :: Bamboo Species 252 | 2200 Alameda St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010390.30388 | 2107888.20316 | 37.7684453082249 | -122.407353050314 | (37.7684453082249, -122.407353050314) | 8 | 4 | 8 | 28853 | 19 | |||
70984 | 188803 | DPW Maintained 1 | Bambusa spp :: Bamboo Species 252 | 370 De Haro St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6011986.97083 | 2106581.47042 | 37.7649465488559 | -122.401738427204 | (37.7649465488559, -122.401738427204) | 8 | 3 | 8 | 28853 | 20 | |||
74763 | 188801 | DPW Maintained 1 | Bambusa spp :: Bamboo Species 252 | 370 De Haro St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6011992.23861 | 2106628.45782 | 37.7650758596913 | -122.401723510132 | (37.7650758596913, -122.401723510132) | 8 | 3 | 8 | 28853 | 20 | |||
109321 | 188799 | DPW Maintained 1 | Bambusa spp :: Bamboo Species 252 | 370 De Haro St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6011991.8145 | 2106659.37833 | 37.7651607368141 | -122.401727150587 | (37.7651607368141, -122.401727150587) | 8 | 3 | 8 | 28853 | 20 | |||
127536 | 221191 | DPW Maintained 1 | Bambusa spp :: Bamboo Species 252 | 84 Elgin Park | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6005819.26634 | 2108627.07323 | 37.7702171714132 | -122.423216410424 | (37.7702171714132, -122.423216410424) | 8 | 2 | 5 | 28853 | 19 | |||
127973 | 188802 | DPW Maintained 1 | Bambusa spp :: Bamboo Species 252 | 370 De Haro St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6011993.79056 | 2106593.57945 | 37.7649801781082 | -122.401715690531 | (37.7649801781082, -122.401715690531) | 8 | 3 | 8 | 28853 | 20 | |||
129631 | 35002 | DPW Maintained 1 | Bambusa spp :: Bamboo Species 252 | 370 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/1999 12:00:00 AM | 3 | Permit Number 41321 | 6011984.13813 | 2106670.27599 | 37.7651902309691 | -122.401754467513 | (37.7651902309691, -122.401754467513) | 8 | 3 | 8 | 28853 | 20 | ||
155558 | 188800 | DPW Maintained 1 | Bambusa spp :: Bamboo Species 252 | 370 De Haro St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6011992.46212 | 2106639.45564 | 37.7651060697129 | -122.401723510151 | (37.7651060697129, -122.401723510151) | 8 | 3 | 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) );