trees
6 rows where Zip Codes = 57 and qSpecies_id = 6
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29195 | 34680 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1904 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52535 | 6003705.30059 | 2119372.14104 | 37.7996008996227 | -122.431295719127 | (37.7996008996227, -122.431295719127) | 13 | 9 | 1 | 57 | 17 | |
| 52224 | 129373 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2133 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000002.55629 | 2120892.7221 | 37.8035654727314 | -122.444217840184 | (37.8035654727314, -122.444217840184) | 13 | 9 | 1 | 57 | 17 | |||
| 57139 | 83205 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3437 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52337 | 6002190.72031 | 2120034.66861 | 37.8013340766633 | -122.436584154541 | (37.8013340766633, -122.436584154541) | 13 | 9 | 1 | 57 | 17 | |
| 142719 | 124805 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2798 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781937 | 5999607.72686 | 2118800.07594 | 37.7977970943207 | -122.445433600384 | (37.7977970943207, -122.445433600384) | 13 | 9 | 1 | 57 | 17 | |
| 163097 | 129372 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2133 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999985.51807 | 2120890.75849 | 37.8035591091338 | -122.444276660352 | (37.8035591091338, -122.444276660352) | 13 | 9 | 1 | 57 | 17 | |||
| 169832 | 65853 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3415 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51130 | 6000770.44597 | 2120073.90569 | 37.8013609996628 | -122.441501736515 | (37.8013609996628, -122.441501736515) | 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) );