trees
9 rows where SiteOrder = 3, qCareAssistant = "FUF" and qSpecies_id = 65 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193468 | 114082 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 20 Cook St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 5997500.7704 | 2113521.7588 | 37.7831837426404 | -122.452343137457 | (37.7831837426404, -122.452343137457) | 15 | 6 | 1 | 54 | 31 | |||
64277 | 37529 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007263.39142 | 2115650.05703 | 37.7895819825607 | -122.418719304647 | (37.7895819825607, -122.418719304647) | 13 | 9 | 10 | 28858 | 21 | |
121537 | 256166 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
15441 | 70583 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1801 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5989858.46515 | 2113331.71432 | 37.7822211492768 | -122.478768239422 | (37.7822211492768, -122.478768239422) | 11 | 6 | 2 | 55 | 26 | |||
52586 | 109284 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1530 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773632 | 5986383.9 | 2095952.1 | 37.7342991443311 | -122.489510139546 | (37.7342991443311, -122.489510139546) | 1 | 8 | 3 | 64 | 35 |
117767 | 158241 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003145.71012 | 2096365.89505 | 37.7363996353363 | -122.431588728148 | (37.7363996353363, -122.431588728148) | 2 | 7 | 5 | 63 | 7 |
16687 | 74647 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004365.04367 | 2091463.54141 | 37.7230079026666 | -122.42702391962 | (37.7230079026666, -122.42702391962) | 9 | 7 | 6 | 28861 | 5 | |||
108513 | 254649 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 929 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781532 | 6000895.17385 | 2091578.90462 | 37.7231278434042 | -122.439026791536 | (37.7231278434042, -122.439026791536) | 9 | 7 | 6 | 28861 | 25 |
67823 | 103022 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 40X Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/15/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770067 | 6006901 | 2099544.2 | 37.7453386886112 | -122.418830426928 | (37.7453386886112, -122.418830426928) | 2 | 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) );