trees
16 rows where SiteOrder = 3 and qSpecies_id = 201
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3863 | 113716 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 498x 21ST AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989370 | 2112285 | 37.7793187899318 | -122.480381451803 | (37.7793187899318, -122.480381451803) | 11 | 6 | 2 | 55 | 26 | ||||
| 24761 | 101258 | Significant Tree 6 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1049 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992548 | 2106581 | 37.7638413023971 | -122.468972303767 | (37.7638413023971, -122.468972303767) | 1 | 8 | 11 | 56 | 12 | ||||
| 27232 | 109017 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 111x 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.415713764528 | (37.7678993280557, -122.415713764528) | 8 | 4 | 7 | 28853 | 19 | ||||
| 28792 | 12433 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1755 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004422.6934 | 2114848.24389 | 37.7872200575435 | -122.428490648397 | (37.7872200575435, -122.428490648397) | 13 | 9 | 11 | 29490 | 27 | |||
| 32406 | 113978 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1180 STANYAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
| 51435 | 26712 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 340 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 2x2 | 5994414.30523 | 2114928.25799 | 37.7868683042504 | -122.463123069231 | (37.7868683042504, -122.463123069231) | 11 | 6 | 1 | 54 | 11 | |||
| 54397 | 124721 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 701x York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2016 12:00:00 AM | 3x3 | 6009904 | 2104980 | 37.7604328157288 | -122.408829935053 | (37.7604328157288, -122.408829935053) | 2 | 4 | 8 | 28859 | 19 | |||
| 81223 | 108917 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 45 LANGTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 2x3 | 6010039 | 2111121 | 37.7773021497785 | -122.408796288569 | (37.7773021497785, -122.408796288569) | 8 | 2 | 9 | 28853 | 34 | |||
| 98985 | 116168 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
| 103348 | 12437 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1595X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | 13 | 9 | 11 | 29490 | 13 | |||
| 140199 | 122474 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 3201x 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6006946 | 2103163 | 37.7552776242638 | -122.41893143992 | (37.7552776242638, -122.41893143992) | 2 | 4 | 7 | 28859 | 19 | |||
| 168126 | 102450 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2205 Pacific Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/28/2014 12:00:00 AM | Permit Number 772662 | 6003508.7 | 2117188.3 | 37.7935934914571 | -122.431820013768 | (37.7935934914571, -122.431820013768) | 13 | 9 | 1 | 29490 | 27 | |||
| 173983 | 108670 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
| 174023 | 101168 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 401 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 33324 | 5994554 | 2106650 | 37.7641464551633 | -122.462039213312 | (37.7641464551633, -122.462039213312) | 1 | 5 | 11 | 56 | 12 | ||||
| 189932 | 114531 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 31 BAY VIEW ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014415 | 2094670 | 37.7323753626402 | -122.392507164078 | (37.7323753626402, -122.392507164078) | 10 | 3 | 8 | 58 | 1 | ||||
| 191669 | 4260 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 4094X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003303.5082097 | 2100409.5413687 | 37.7475114969278 | -122.431331714787 | (37.7475114969278, -122.431331714787) | 2 | 4 | 5 | 63 | 22 |
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) );