trees
6 rows where Neighborhoods (old) = 29, SiteOrder = 1 and qSpecies_id = 65
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4010 | 32946 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 265 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2018 12:00:00 AM | 3 | Permit Number 782101 | 6012936.74876 | 2105822.26722 | 37.7629149012172 | -122.398400087987 | (37.7629149012172, -122.398400087987) | 14 | 3 | 8 | 28856 | 29 | |
103811 | 189214 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1498 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6014376.75149 | 2102028.72002 | 37.7525787510095 | -122.393154121288 | (37.7525787510095, -122.393154121288) | 10 | 3 | 8 | 28856 | 29 | |||
158774 | 83067 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 624 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 10 | 3x6 | Permit Number 52379 | 6012068.69574 | 2105475.40084 | 37.7619140888872 | -122.401378022999 | (37.7619140888872, -122.401378022999) | 10 | 3 | 8 | 28856 | 29 | |
186443 | 83009 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 622 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52378 | 6012068.99141 | 2105489.95153 | 37.7619540583423 | -122.401378022995 | (37.7619540583423, -122.401378022995) | 10 | 3 | 8 | 28856 | 29 | |
188936 | 113546 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2017 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011705.09048 | 2105100.13383 | 37.7608633956443 | -122.402609207467 | (37.7608633956443, -122.402609207467) | 10 | 3 | 8 | 28856 | 29 | ||
190011 | 66065 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 15 | Permit Number 29105 | 6013588.8129 | 2104207.15934 | 37.7585164708659 | -122.396031617282 | (37.7585164708659, -122.396031617282) | 10 | 3 | 8 | 28856 | 29 |
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) );