trees
7 rows where Supervisor Districts = 7 and qSpecies_id = 98 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15812 | 243781 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 530 Crescent Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6007733.67911 | 2095675.76674 | 37.7347636749953 | -122.415677298363 | (37.7347636749953, -122.415677298363) | 2 | 7 | 7 | 28859 | 2 | |||
130102 | 242809 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007180.51421 | 2105199.12934 | 37.760881568258 | -122.418264772906 | (37.760881568258, -122.418264772906) | 2 | 4 | 7 | 28859 | 19 | |||
85221 | 242807 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007180.55989 | 2105223.19925 | 37.760947661217 | -122.418266321527 | (37.760947661217, -122.418266321527) | 2 | 4 | 7 | 28859 | 19 | |||
17230 | 242808 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007180.24018 | 2105207.60423 | 37.7609048229145 | -122.418266321545 | (37.7609048229145, -122.418266321545) | 2 | 4 | 7 | 28859 | 19 | |||
150786 | 242806 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007179.92075 | 2105235.69355 | 37.7609819316884 | -122.418269417912 | (37.7609819316884, -122.418269417912) | 2 | 4 | 7 | 28859 | 19 | |||
96231 | 242805 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 350 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007179.22681 | 2105245.51436 | 37.7610088582918 | -122.418272514273 | (37.7610088582918, -122.418272514273) | 2 | 4 | 7 | 28859 | 19 | |||
59560 | 180594 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 222 Pioche St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 2ft | 6006226.36725 | 2093441.03912 | 37.7285427577377 | -122.420730007995 | (37.7285427577377, -122.420730007995) | 9 | 7 | 7 | 309 | 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) );