trees
10 rows where Neighborhoods (old) = 9 and qSpecies_id = 181
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5390 | 244700 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 722 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 08:50:00 AM | 3 | Width 3ft | Permit Number 32809 | 6002026.57128 | 2108798.52358 | 37.7704731625436 | -122.43634756898 | (37.7704731625436, -122.43634756898) | 15 | 5 | 11 | 29492 | 9 | |
6122 | 221395 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 704 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 08:44:00 AM | 3 | Width 3ft | 6002236.87075 | 2108821.32754 | 37.7705477235228 | -122.435621774727 | (37.7705477235228, -122.435621774727) | 15 | 5 | 11 | 29492 | 9 | ||
7091 | 88264 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1911 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51250 | 5997436 | 2108804 | 37.7702262944805 | -122.452226693379 | (37.7702262944805, -122.452226693379) | 15 | 5 | 11 | 29492 | 9 | |
11252 | 221394 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 704 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 08:48:00 AM | 3 | Width 3ft | 6002285.30812 | 2108832.29494 | 37.7705805883473 | -122.435455014354 | (37.7705805883473, -122.435455014354) | 15 | 5 | 11 | 29492 | 9 | ||
17274 | 240325 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 704 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 08:41:00 AM | 3 | Width 3ft | 6002296.51471 | 2108833.13942 | 37.7705835435377 | -122.435416311116 | (37.7705835435377, -122.435416311116) | 15 | 5 | 11 | 29492 | 9 | ||
48916 | 45137 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1234 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53510 | 6000650.05093889 | 2109301.35578788 | 37.7717755038706 | -122.441145029184 | (37.7717755038706, -122.441145029184) | 15 | 5 | 11 | 29492 | 9 | ||
55226 | 88252 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1025 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51238 | 5999131 | 2106547 | 37.7641260948648 | -122.446201344399 | (37.7641260948648, -122.446201344399) | 15 | 5 | 11 | 29492 | 9 | |||
61970 | 88249 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 4758 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51235 | 5998426 | 2105687 | 37.7617244639768 | -122.448577782387 | (37.7617244639768, -122.448577782387) | 15 | 5 | 11 | 29492 | 9 | |||
67156 | 88254 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 107 Belvedere St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51239 | 5998213 | 2108192 | 37.768590378969 | -122.449494963351 | (37.768590378969, -122.449494963351) | 15 | 5 | 11 | 29492 | 9 | |||
148693 | 64873 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 710 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | Permit Number 772699 | 6002299.12581357 | 2108836.45328021 | 37.77059279087 | -122.435407516384 | (37.77059279087, -122.435407516384) | 15 | 5 | 11 | 29492 | 9 |
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) );