trees
19 rows where qSpecies_id = 361
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15157 | 183409 | DPW Maintained 1 | Betula nigra :: River Birch 361 | 2691 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5989558.0154 | 2097057.5846 | 37.7375193143858 | -122.478617140291 | (37.7375193143858, -122.478617140291) | 1 | 8 | 3 | 29491 | 35 | |||
36051 | 205613 | DPW Maintained 1 | Betula nigra :: River Birch 361 | 159 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 6000360.17729 | 2095197.96612 | 37.733034496339 | -122.441135689963 | (37.733034496339, -122.441135689963) | 9 | 7 | 5 | 63 | 40 | |||
42885 | 92052 | DPW Maintained 1 | Betula nigra :: River Birch 361 | 2323 Cesar Chavez St | Sidewalk: Property side : Cutout | Tree | DPW 1 | 05/16/2009 12:00:00 AM | 6012395.863444 | 2100936.77011 | 37.7494702500338 | -122.399927744224 | (37.7494702500338, -122.399927744224) | 10 | 3 | 8 | 58 | 1 | |||||
55537 | 110897 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
63756 | 93549 | Permitted Site 7 | Betula nigra :: River Birch 361 | 729 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53245 | 6000222 | 2096067 | 37.7354127885514 | -122.441675748683 | (37.7354127885514, -122.441675748683) | 9 | 7 | 4 | 63 | 40 | |
66714 | 221198 | DPW Maintained 1 | Betula nigra :: River Birch 361 | 330 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004282.34184 | 2096354.91745 | 37.7364338527251 | -122.427658132321 | (37.7364338527251, -122.427658132321) | 2 | 7 | 5 | 63 | 7 | |||
67561 | 221200 | DPW Maintained 1 | Betula nigra :: River Birch 361 | 28 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6003315.93021 | 2097734.28858 | 37.7401665770127 | -122.431097844904 | (37.7401665770127, -122.431097844904) | 2 | 7 | 5 | 63 | 7 | ||||
73430 | 110898 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
75547 | 221199 | DPW Maintained 1 | Betula nigra :: River Birch 361 | 26 Harry St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6003372.48488 | 2097772.59148 | 37.7402749525375 | -122.430905034737 | (37.7402749525375, -122.430905034737) | 2 | 7 | 5 | 63 | 7 | ||||
86343 | 110894 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
100433 | 110891 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
118023 | 110885 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
124789 | 110899 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
152062 | 110895 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
166438 | 83525 | DPW Maintained 1 | Betula nigra :: River Birch 361 | 311 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 4 | 4x4 | Permit Number 52316 | 6004274.09861 | 2091447.36143 | 37.7229583329352 | -122.427337146289 | (37.7229583329352, -122.427337146289) | 9 | 7 | 6 | 28861 | 5 |
167463 | 83553 | DPW Maintained 1 | Betula nigra :: River Birch 361 | 311 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 4 | 4x4 | Permit Number 52316 | 6004268.10614 | 2091439.9255 | 37.7229375765963 | -122.427357331582 | (37.7229375765963, -122.427357331582) | 9 | 7 | 6 | 28861 | 5 |
175598 | 110893 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
182272 | 110896 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
183616 | 110892 | Undocumented 4 | Betula nigra :: River Birch 361 | 800 INDIANA ST | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 |
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) );