trees
9 rows where Supervisor Districts = 1 and qSpecies_id = 50 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33426 | 81978 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2318 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50641 | 6007584.72207 | 2120320.19239 | 37.8024230981 | -122.417938725504 | (37.8024230981, -122.417938725504) | 5 | 1 | 1 | 308 | 32 | |
52963 | 110460 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 250 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | 3x20 | Permit Number 775118 | 5987173.7 | 2114281.7 | 37.7846732836557 | -122.488126031288 | (37.7846732836557, -122.488126031288) | 11 | 6 | 1 | 55 | 33 | |
91260 | 107160 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1324 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6004955.04875 | 2120587.09696 | 37.8030076016857 | -122.427057718834 | (37.8030076016857, -122.427057718834) | 13 | 9 | 1 | 57 | 17 | ||||
91308 | 107509 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 240 PIXLEY ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002182.3 | 2118985.3 | 37.7984523071777 | -122.436538140501 | (37.7984523071777, -122.436538140501) | 13 | 9 | 1 | 57 | 17 | ||||||
95093 | 99510 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1949 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2012 12:00:00 AM | 3 | Permit Number 768796 | 6003707.79876 | 2118284.70068 | 37.7966152106739 | -122.431209412082 | (37.7966152106739, -122.431209412082) | 13 | 9 | 1 | 57 | 17 | ||
101745 | 129099 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 240 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002192.18689 | 2118975.47765 | 37.7984258993922 | -122.436503225465 | (37.7984258993922, -122.436503225465) | 13 | 9 | 1 | 57 | 17 | |||
120714 | 110461 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 250 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | 3x20 | Permit Number 775118 | 5987173.7 | 2114281.7 | 37.7846732836557 | -122.488126031288 | (37.7846732836557, -122.488126031288) | 11 | 6 | 1 | 55 | 33 | |
159081 | 100089 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2034 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003188.20593 | 2118955.0281 | 37.7984262977915 | -122.433055234626 | (37.7984262977915, -122.433055234626) | 13 | 9 | 1 | 57 | 17 | |||
179824 | 100088 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2034 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6003201.40964 | 2118956.65929 | 37.7984315255609 | -122.433009662373 | (37.7984315255609, -122.433009662373) | 13 | 9 | 1 | 57 | 17 |
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) );