trees
10 rows where Zip Codes = 28861 and qSpecies_id = 91
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17752 | 70594 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 342 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6004127.79616 | 2091299.57805 | 37.7225442769693 | -122.427832358882 | (37.7225442769693, -122.427832358882) | 9 | 7 | 6 | 28861 | 5 | |||
33981 | 59467 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 225 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1980 12:00:00 AM | Permit Number 18832 | 6003936.96875248 | 2095250.30733216 | 37.7333813011767 | -122.428773510363 | (37.7333813011767, -122.428773510363) | 9 | 7 | 5 | 28861 | 25 | |||
77871 | 214162 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 56 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995350.86908 | 2090273.63849 | 37.7192268694992 | -122.458097813856 | (37.7192268694992, -122.458097813856) | 9 | 8 | 6 | 28861 | 24 | |||
86523 | 179423 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 103 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6004767.82112 | 2092745.17359 | 37.7265497503523 | -122.425722776001 | (37.7265497503523, -122.425722776001) | 9 | 7 | 6 | 28861 | 5 | ||||
99414 | 214166 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 25 Hazelwood Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5996590.09341 | 2093838.6494 | 37.729086671304 | -122.454071648891 | (37.729086671304, -122.454071648891) | 9 | 7 | 4 | 28861 | 40 | |||
115611 | 214163 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 274 Tara St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997748.47431 | 2090294.62139 | 37.7194219549502 | -122.449811751014 | (37.7194219549502, -122.449811751014) | 9 | 8 | 6 | 28861 | 24 | |||
122194 | 239589 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 225 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003864.64018 | 2095248.99329 | 37.7333735991966 | -122.429023476774 | (37.7333735991966, -122.429023476774) | 9 | 7 | 5 | 28861 | 25 | |||
158697 | 214158 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 675 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 1ft | 5996963.77337 | 2094391.63977 | 37.7306264707198 | -122.452819711683 | (37.7306264707198, -122.452819711683) | 9 | 7 | 4 | 28861 | 40 | |||
185878 | 32430 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 36 Tingley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/1996 12:00:00 AM | 16 | Permit Number 36957 | 6002798.58811 | 2093563.75666 | 37.7286859198974 | -122.432588778773 | (37.7286859198974, -122.432588778773) | 9 | 7 | 6 | 28861 | 25 | ||
190814 | 214161 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 112 Marston Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998700.79375 | 2093221.28064 | 37.7275123235144 | -122.446730415591 | (37.7275123235144, -122.446730415591) | 9 | 7 | 4 | 28861 | 40 |
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) );