trees
19 rows where Supervisor Districts = 3 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5063 | 260534 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1506 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5981886.54013 | 2104825.39883 | 37.7583991678414 | -122.50571626969 | (37.7583991678414, -122.50571626969) | 1 | 8 | 3 | 56 | 35 | ||
| 5570 | 261215 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1770 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2019 12:00:00 AM | 3 | 4x6 | 5984144 | 2103125 | 37.7538629512363 | -122.497783538537 | (37.7538629512363, -122.497783538537) | 1 | 8 | 3 | 56 | 35 | |
| 6390 | 183851 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2235 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2020 12:00:00 AM | 3 | 5x5 | 5986665.607 | 2100041.6444 | 37.7455443899531 | -122.4888367163 | (37.7455443899531, -122.4888367163) | 1 | 8 | 3 | 29491 | 35 | ||
| 8206 | 38101 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1273 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781573 | 5987681.6278 | 2106613.2126 | 37.7636473828601 | -122.485805759721 | (37.7636473828601, -122.485805759721) | 1 | 8 | 3 | 56 | 35 | |
| 9110 | 261218 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1506 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 4x6 | 5983437 | 2104877 | 37.7586319808213 | -122.500357993039 | (37.7586319808213, -122.500357993039) | 1 | 8 | 3 | 56 | 35 | |
| 12440 | 256745 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1562 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 5985620.2456 | 2104586.16151 | 37.7579613290823 | -122.492786024726 | (37.7579613290823, -122.492786024726) | 1 | 8 | 3 | 56 | 35 | ||
| 12991 | 261216 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2786 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 4x6 | 5984380 | 2096227 | 37.7349367548256 | -122.496458440233 | (37.7349367548256, -122.496458440233) | 1 | 8 | 3 | 29491 | 35 | |
| 13513 | 183546 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2585 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2020 12:00:00 AM | 3 | Width 0ft | 5988604.9156 | 2097737.5116 | 37.7393308334388 | -122.481962210024 | (37.7393308334388, -122.481962210024) | 1 | 8 | 3 | 29491 | 35 | ||
| 14230 | 261818 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1601 Quintara St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5988457 | 2100975 | 37.7482115203177 | -122.482710816875 | (37.7482115203177, -122.482710816875) | 1 | 8 | 3 | 29491 | 35 | ||
| 14907 | 258013 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2319 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5983275.88991 | 2099350.91924 | 37.7434494414187 | -122.500506582091 | (37.7434494414187, -122.500506582091) | 1 | 8 | 3 | 29491 | 35 | |||
| 15040 | 260527 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2610 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5981833.19804 | 2097322.67554 | 37.7377956491303 | -122.505344662268 | (37.7377956491303, -122.505344662268) | 1 | 8 | 3 | 29491 | 35 | ||
| 15099 | 95445 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2201 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2020 12:00:00 AM | 3 | 4x6 | Permit Number 767307 | 5985726.3556 | 2100198.6842 | 37.7459207192562 | -122.492096016775 | (37.7459207192562, -122.492096016775) | 1 | 8 | 3 | 29491 | 35 |
| 15845 | 258506 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1826 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784310 | 5981340.96511 | 2102634.36273 | 37.7523510806953 | -122.507440512367 | (37.7523510806953, -122.507440512367) | 1 | 8 | 3 | 56 | 35 | |
| 19168 | 260518 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 3832 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 5983000.66744 | 2104942.49722 | 37.7587861961844 | -122.50187185062 | (37.7587861961844, -122.50187185062) | 1 | 8 | 3 | 56 | 35 | ||
| 72954 | 95530 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 3325 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767321 | 5982880 | 2100129 | 37.7455625889452 | -122.501933006964 | (37.7455625889452, -122.501933006964) | 1 | 8 | 3 | 29491 | 35 | |
| 88439 | 254690 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1666 28th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781577 | 5987504.11579 | 2103945.47752 | 37.7563121659062 | -122.486223855163 | (37.7563121659062, -122.486223855163) | 1 | 8 | 3 | 56 | 35 | |
| 98716 | 115179 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2018 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775293 | 5981721.2 | 2101325.9 | 37.7487808007055 | -122.506028615883 | (37.7487808007055, -122.506028615883) | 1 | 8 | 3 | 29491 | 35 | |||
| 133805 | 254759 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1185 Vicente St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781601 | 5989303.86415 | 2097634.53427 | 37.7390887094016 | -122.479538051252 | (37.7390887094016, -122.479538051252) | 1 | 8 | 3 | 29491 | 35 | |
| 172127 | 254562 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2743 38th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779392 | 5984613.41462 | 2096519.76609 | 37.7357542837064 | -122.495673043599 | (37.7357542837064, -122.495673043599) | 1 | 8 | 3 | 29491 | 35 |
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) );