trees
9 rows where Neighborhoods (old) = 12 and qSpecies_id = 151
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19917 | 209292 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1466 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993385.70012 | 2105501.91756 | 37.7609267888564 | -122.465996561219 | (37.7609267888564, -122.465996561219) | 1 | 8 | 11 | 56 | 12 | |||
| 43632 | 48013 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1991 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45735 | 5991253.49588687 | 2101875.72214117 | 37.7508469733877 | -122.473106392758 | (37.7508469733877, -122.473106392758) | 1 | 8 | 4 | 29491 | 12 | ||
| 45942 | 67106 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1422 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30521 | 5994302.05947846 | 2105826.4023092 | 37.7618705618217 | -122.462850841683 | (37.7618705618217, -122.462850841683) | 1 | 5 | 11 | 56 | 12 | ||
| 47147 | 68648 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1935 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32553 | 5990620.64023794 | 2102219.83857431 | 37.7517551651121 | -122.475319963854 | (37.7517551651121, -122.475319963854) | 1 | 8 | 4 | 29491 | 12 | ||
| 48209 | 209293 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1416 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993991.03354 | 2105859.32276 | 37.7619430335757 | -122.463928938879 | (37.7619430335757, -122.463928938879) | 1 | 5 | 11 | 56 | 12 | |||
| 98615 | 46679 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1310 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | Permit Number 44809 | 5990528.41168502 | 2106454.94562806 | 37.76337829801 | -122.475948167358 | (37.76337829801, -122.475948167358) | 1 | 8 | 3 | 56 | 12 | ||
| 99779 | 61031 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 341 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1992 12:00:00 AM | Permit Number 30462 | 5994728.25954816 | 2107000.31116511 | 37.7651183497385 | -122.461461902415 | (37.7651183497385, -122.461461902415) | 15 | 5 | 11 | 56 | 12 | ||
| 115516 | 69060 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1254 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33068 | 5992404.85704232 | 2106915.96776858 | 37.7647527637413 | -122.4694917724 | (37.7647527637413, -122.4694917724) | 11 | 8 | 11 | 56 | 12 | ||
| 171045 | 68055 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1635 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31792 | 5993371.17911644 | 2104355.17278609 | 37.7577772885613 | -122.4659634545 | (37.7577772885613, -122.4659634545) | 1 | 8 | 4 | 56 | 12 |
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) );