trees
21 rows where Police Districts = 4 and qSpecies_id = 12
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
123127 | 34776 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 1148 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | 4x4 | Permit Number 38417 | 6008035.00461404 | 2101235.83901924 | 37.7500473368591 | -122.415028926905 | (37.7500473368591, -122.415028926905) | 2 | 4 | 7 | 28859 | 19 | ||
140446 | 104738 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 200X Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree on the 23rd St side of property | 6005413 | 2102541 | 37.753483315938 | -122.424188782445 | (37.753483315938, -122.424188782445) | 2 | 4 | 5 | 28859 | 19 | ||||
144433 | 241165 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1358 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009520.35544 | 2101278.61377 | 37.7502481435534 | -122.409895500301 | (37.7502481435534, -122.409895500301) | 2 | 4 | 7 | 28859 | 19 | |||
150053 | 96055 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 1358 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767683 | 6009525 | 2101259 | 37.7501945487931 | -122.409878054668 | (37.7501945487931, -122.409878054668) | 2 | 4 | 7 | 28859 | 19 | |
160999 | 91211 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 2901 Mission St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52044 | 6007111 | 2101465 | 37.7506245935345 | -122.41824043827 | (37.7506245935345, -122.41824043827) | 2 | 4 | 7 | 28859 | 19 | |||
184080 | 84157 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 607 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52665 | 6007912.35762405 | 2104388.06639727 | 37.7586957437969 | -122.415676213523 | (37.7586957437969, -122.415676213523) | 2 | 4 | 7 | 28859 | 19 | ||
193268 | 52304 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 180DANVERS Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2005 12:00:00 AM | Permit Number 48464 | 6000126.86103947 | 2104901.42011078 | 37.7596645617882 | -122.442638797859 | (37.7596645617882, -122.442638797859) | 2 | 4 | 5 | 28862 | 3 |
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) );