trees
7 rows where Police Districts = 7 and qSpecies_id = 39 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27446 | 95701 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 101 Arbor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767450 | 6001805 | 2096722 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | 2 | 7 | 5 | 63 | 7 | |
43730 | 55657 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 349 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52575 | 6006153.21523754 | 2098012.87204699 | 37.7410918742968 | -122.421307424196 | (37.7410918742968, -122.421307424196) | 2 | 7 | 7 | 28859 | 2 | ||
57528 | 95700 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 101 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767450 | 6001805 | 2096722 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | 2 | 7 | 5 | 63 | 7 | |
66647 | 87768 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 200 Beacon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50472 | 6003134 | 2097619 | 37.7398397101769 | -122.431718656253 | (37.7398397101769, -122.431718656253) | 2 | 7 | 5 | 63 | 7 | |||
112264 | 87767 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 200 Beacon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50472 | 6003134 | 2097619 | 37.7398397101769 | -122.431718656253 | (37.7398397101769, -122.431718656253) | 2 | 7 | 5 | 63 | 7 | |||
140596 | 239188 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 1300 San Jose Ave | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6003390.53226 | 2095588.92552 | 37.7342801275185 | -122.430686848418 | (37.7342801275185, -122.430686848418) | 2 | 7 | 5 | 63 | 7 | ||||
176674 | 43127 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 8 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52578 | 6007298.20406204 | 2099606.09068899 | 37.7455309835883 | -122.417461342572 | (37.7455309835883, -122.417461342572) | 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) );