trees
7 rows where PlotSize = "Width 8ft" and qSpecies_id = 65 sorted by Latitude descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
88463 | 251005 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 342 Point Lobos Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981698.04635 | 2112709.85802 | 37.7800365073085 | -122.506953000187 | (37.7800365073085, -122.506953000187) | 11 | 6 | 2 | 55 | 26 | |||
129007 | 221787 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 124 27th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 8ft | 6005680.59891 | 2100245.58826 | 37.7471957491868 | -122.423100223394 | (37.7471957491868, -122.423100223394) | 2 | 7 | 5 | 28859 | 22 | |||
35544 | 221939 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 21 Harry St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6003408.10773 | 2097774.81236 | 37.740283068906 | -122.430782023672 | (37.740283068906, -122.430782023672) | 2 | 7 | 5 | 63 | 7 | |||
127470 | 189220 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1652 La Salle Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 8ft | 6015291.93207 | 2096384.83865 | 37.737132622377 | -122.389595102843 | (37.737132622377, -122.389595102843) | 10 | 3 | 8 | 58 | 1 | |||
7243 | 203528 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5992568.77798 | 2096730.41145 | 37.7367953253409 | -122.46818381133 | (37.7367953253409, -122.46818381133) | 1 | 8 | 4 | 59 | 40 | |||
77602 | 203529 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5992569.96638 | 2096706.93709 | 37.7367309392805 | -122.468177995418 | (37.7367309392805, -122.468177995418) | 1 | 8 | 4 | 59 | 40 | |||
146627 | 175215 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 857 Barneveld Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 8ft | 6010301.67863 | 2094727.33157 | 37.7323034959049 | -122.406731980322 | (37.7323034959049, -122.406731980322) | 10 | 3 | 7 | 309 | 28 |
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) );