trees
7 rows where qSpecies_id = 493
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
63713 | 50410 | Permitted Site 7 | Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 493 | 178 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47065 | 6000234.8125186 | 2094385.17995161 | 37.7307956329874 | -122.441510803123 | (37.7307956329874, -122.441510803123) | 9 | 7 | 4 | 63 | 40 | ||
82284 | 196262 | DPW Maintained 1 | Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 493 | 3536 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782064 | 6013087.51397 | 2089531.09093 | 37.7181911508873 | -122.396736491513 | (37.7181911508873, -122.396736491513) | 10 | 3 | 8 | 58 | 1 | |
86735 | 235090 | DPW Maintained 1 | Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 493 | 100 Putnam St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779715 | 6009124.9466 | 2096834.17608 | 37.7380225267172 | -122.410948981415 | (37.7380225267172, -122.410948981415) | 10 | 7 | 7 | 28859 | 2 | |
119714 | 91115 | DPW Maintained 1 | Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 493 | 776 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779255 | 5984798.48875 | 2110573.10753 | 37.7743517064443 | -122.496069648958 | (37.7743517064443, -122.496069648958) | 11 | 6 | 2 | 55 | 26 | |
145898 | 32763 | DPW Maintained 1 | Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 493 | 1750 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781655 | 6009286 | 2099240 | 37.7446374239496 | -122.410561978637 | (37.7446374239496, -122.410561978637) | 2 | 7 | 7 | 28859 | 2 | |
174013 | 257892 | Planning Code 138.1 required 2 | Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 493 | 91 Canyon Dr | 1 | Front Yard : Yard | Tree | Private 2 | 01/11/2019 12:00:00 AM | 3 | 3x3 | 6002890 | 2086311 | 37.7087766368694 | -122.43175513536 | (37.7087766368694, -122.43175513536) | 9 | 7 | 6 | 28861 | 5 | ||
176641 | 235091 | DPW Maintained 1 | Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 493 | 100 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779715 | 6009129.80831 | 2096850.9527 | 37.7380688642945 | -122.410933356597 | (37.7380688642945, -122.410933356597) | 10 | 7 | 7 | 28859 | 2 |
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) );