trees
8 rows where PlotSize = "" and qSpecies_id = 117 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9827 | 43302 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 674 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 11 | Permit Number 43070 | 6011226.86834 | 2105221.06288 | 37.7611687289854 | -122.404271687012 | (37.7611687289854, -122.404271687012) | 10 | 3 | 8 | 28856 | 29 | |
| 43849 | 92831 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 1045 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2009 12:00:00 AM | 1 | Permit Number 53048 | 5989582.377 | 2099676.246 | 37.7447108930031 | -122.478724371045 | (37.7447108930031, -122.478724371045) | 1 | 8 | 3 | 29491 | 35 | ||
| 88051 | 43775 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 142 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 7 | Permit Number 43405 | 5989625.78116 | 2114417.51873 | 37.785188950147 | -122.479652684743 | (37.785188950147, -122.479652684743) | 11 | 6 | 2 | 55 | 26 | |
| 98490 | 43785 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 350 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 11 | Permit Number 43415 | 5989366.32057 | 2112984.24628 | 37.7812385110344 | -122.480445377901 | (37.7812385110344, -122.480445377901) | 11 | 6 | 2 | 55 | 26 | |
| 108343 | 30610 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 130 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 9 | Permit Number 34573 | 6009109.45338 | 2109560.9678 | 37.7729665590046 | -122.411901635954 | (37.7729665590046, -122.411901635954) | 8 | 2 | 9 | 28853 | 34 | |
| 138214 | 107663 | Undocumented 4 | Melaleuca spp :: Melaleuca spp 117 | 900 CAROLINA ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6012372.4 | 2103715.1 | 37.7570976312818 | -122.400203986953 | (37.7570976312818, -122.400203986953) | 10 | 3 | 8 | 28856 | 29 | |||||
| 156556 | 107664 | Undocumented 4 | Melaleuca spp :: Melaleuca spp 117 | 900 CAROLINA ST | 2 | Front Yard : Yard | Tree | Private 2 | 6012372.4 | 2103715.1 | 37.7570976312818 | -122.400203986953 | (37.7570976312818, -122.400203986953) | 10 | 3 | 8 | 28856 | 29 | |||||
| 178853 | 94891 | Permitted Site 7 | Melaleuca spp :: Melaleuca spp 117 | 491 Frederick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2010 12:00:00 AM | Permit Number 53958 | 5997284 | 2107398 | 37.7663570704681 | -122.452650969879 | (37.7663570704681, -122.452650969879) | 15 | 5 | 11 | 29492 | 9 |
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) );