trees
7 rows where qSpecies_id = 436
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34661 | 47190 | Permitted Site 7 | Leptospermum petersonii :: Lemon Scented Tea Tree 436 | 141 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | Permit Number 45150 | 5987383.36668301 | 2115028.94081093 | 37.7867372223708 | -122.48745557315 | (37.7867372223708, -122.48745557315) | 11 | 6 | 1 | 55 | 33 | ||
46929 | 42964 | Permitted Site 7 | Leptospermum petersonii :: Lemon Scented Tea Tree 436 | 63 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42853 | 6009571.37724716 | 2099895.71895032 | 37.7464538792999 | -122.409621468456 | (37.7464538792999, -122.409621468456) | 2 | 7 | 7 | 28859 | 2 | |||
71316 | 108530 | Permitted Site 7 | Leptospermum petersonii :: Lemon Scented Tea Tree 436 | 1490-1498X 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773681 | 5990843.89113 | 2105531.38959 | 37.7608607468587 | -122.474789624033 | (37.7608607468587, -122.474789624033) | 1 | 8 | 4 | 56 | 12 |
121256 | 254289 | Undocumented 4 | Leptospermum petersonii :: Lemon Scented Tea Tree 436 | 110 Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5991396 | 2095383 | 37.7330278715114 | -122.472140394325 | (37.7330278715114, -122.472140394325) | 1 | 8 | 4 | 64 | 40 | ||||
124655 | 47205 | DPW Maintained 1 | Leptospermum petersonii :: Lemon Scented Tea Tree 436 | 410 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | 6 | Permit Number 45159 | 5986260.82994 | 2113102.66044 | 37.7813826818753 | -122.491197411453 | (37.7813826818753, -122.491197411453) | 11 | 6 | 2 | 55 | 26 | |
156770 | 47206 | DPW Maintained 1 | Leptospermum petersonii :: Lemon Scented Tea Tree 436 | 410 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | 6 | Permit Number 45159 | 5986260.05703 | 2113119.06647 | 37.7814276829703 | -122.491201293085 | (37.7814276829703, -122.491201293085) | 11 | 6 | 2 | 55 | 26 | |
192610 | 108529 | Permitted Site 7 | Leptospermum petersonii :: Lemon Scented Tea Tree 436 | 1490-1498X 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773681 | 5990843.89113 | 2105531.38959 | 37.7608607468587 | -122.474789624033 | (37.7608607468587, -122.474789624033) | 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) );