trees
11 rows where SiteOrder = 13 and qSpecies_id = 31
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7295 | 100582 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
24002 | 198501 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900x Carolina St | 13 | Median : Yard | Tree | DPW 1 | 15 | 6012463.03254 | 2103576.30053 | 37.7567215715659 | -122.399880796574 | (37.7567215715659, -122.399880796574) | 10 | 3 | 8 | 28856 | 29 | ||||
59632 | 17589 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 13 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003683.23846 | 2090394.91559 | 37.720035114503 | -122.42930461652 | (37.720035114503, -122.42930461652) | 9 | 7 | 6 | 28861 | 5 | |||
103199 | 100626 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
104850 | 198445 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015364.88661 | 2106281.79771 | 37.7643116365027 | -122.390034032247 | (37.7643116365027, -122.390034032247) | 14 | 3 | 9 | 310 | 29 | |||
106040 | 16430 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | |||
111607 | 198659 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013968.57822 | 2107369.74118 | 37.7672213498189 | -122.39493970902 | (37.7672213498189, -122.39493970902) | 14 | 3 | 9 | 310 | 20 | |||
116363 | 198639 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015936.81017 | 2108752.54325 | 37.7711274696967 | -122.38822833839 | (37.7711274696967, -122.38822833839) | 14 | 3 | 9 | 310 | 20 | ||||
146659 | 97233 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300X Newcomb Ave | 13 | Median : Cutout | Tree | DPW 1 | 6 | 15x200 | 6016357.8982 | 2094854.1147 | 37.7329886101989 | -122.385802878589 | (37.7329886101989, -122.385802878589) | 10 | 3 | 8 | 58 | 1 | |||
172519 | 97844 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
193067 | 198624 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015725.44924 | 2108619.45871 | 37.7707503353808 | -122.388950156737 | (37.7707503353808, -122.388950156737) | 14 | 3 | 9 | 310 | 20 |
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) );