trees
48 rows where Fire Prevention Districts = 7 and qSpecies_id = 5 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18217 | 222886 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 139 Webster St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6004216.91806 | 2109283.17336 | 37.7719281046318 | -122.428805703247 | (37.7719281046318, -122.428805703247) | 7 | 9 | 11 | 29492 | 10 | |||
| 26541 | 62275 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 141 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22411 | 6004215.98521889 | 2109270.59348358 | 37.771893510559 | -122.428808033039 | (37.771893510559, -122.428808033039) | 7 | 9 | 11 | 29492 | 10 | ||
| 49432 | 222887 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 123 Webster St | 1 | : | Tree | Private 2 | 13 | Width 5ft | 6004226.51196 | 2109212.81898 | 37.77173547164 | -122.428767500918 | (37.77173547164, -122.428767500918) | 7 | 9 | 11 | 29492 | 10 | |||
| 56519 | 44334 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 57 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/06/2001 12:00:00 AM | Permit Number 43719 | 6004283.91720992 | 2108781.91004669 | 37.770555549309 | -122.428538212023 | (37.770555549309, -122.428538212023) | 7 | 9 | 11 | 29492 | 10 | ||
| 71727 | 65411 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 81 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1989 12:00:00 AM | Permit Number 28262 | 6004263.16526256 | 2108931.19399052 | 37.7709642723528 | -122.428620636268 | (37.7709642723528, -122.428620636268) | 7 | 9 | 11 | 29492 | 10 | |||
| 102569 | 62273 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 123 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22409 | 6004226.44756002 | 2109195.3304156 | 37.7716874486567 | -122.428766476737 | (37.7716874486567, -122.428766476737) | 7 | 9 | 11 | 29492 | 10 | ||
| 104673 | 222889 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 81 Webster St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6004268.74767 | 2108942.84192 | 37.7709965706599 | -122.428602156987 | (37.7709965706599, -122.428602156987) | 7 | 9 | 11 | 29492 | 10 | |||
| 131347 | 62272 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 113 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22406 | 6004233.40404883 | 2109145.28748516 | 37.7715504366717 | -122.428738845772 | (37.7715504366717, -122.428738845772) | 7 | 9 | 11 | 29492 | 10 | ||
| 147007 | 222888 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 109 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004218 | 2109157 | 37.7715817245566 | -122.428792964354 | (37.7715817245566, -122.428792964354) | 7 | 9 | 11 | 29492 | 10 |
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) );