trees
11 rows where Zip Codes = 309 and qSpecies_id = 186
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8802 | 176563 | DPW Maintained 1 | Heteromeles arbutifolia :: Toyon 186 | 145 Tioga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010260.41532 | 2089074.47273 | 37.7167796145598 | -122.406476454124 | (37.7167796145598, -122.406476454124) | 9 | 7 | 8 | 309 | 39 | |||
| 45133 | 176561 | DPW Maintained 1 | Heteromeles arbutifolia :: Toyon 186 | 130 Tucker Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010209.02707 | 2088857.9685 | 37.7161822632845 | -122.406638830318 | (37.7161822632845, -122.406638830318) | 9 | 7 | 8 | 309 | 39 | |||
| 53311 | 176560 | DPW Maintained 1 | Heteromeles arbutifolia :: Toyon 186 | 130 Tucker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010230.7823 | 2088849.41401 | 37.7161599915583 | -122.406563030976 | (37.7161599915583, -122.406563030976) | 9 | 7 | 8 | 309 | 39 | |||
| 66287 | 176559 | DPW Maintained 1 | Heteromeles arbutifolia :: Toyon 186 | 130 Tucker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010251.33586 | 2088843.37979 | 37.7161445727026 | -122.406491562734 | (37.7161445727026, -122.406491562734) | 9 | 7 | 8 | 309 | 39 | |||
| 74560 | 176566 | DPW Maintained 1 | Heteromeles arbutifolia :: Toyon 186 | 145 Tioga Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6010219.37892 | 2089089.59788 | 37.716818849299 | -122.406619362691 | (37.716818849299, -122.406619362691) | 9 | 7 | 8 | 309 | 39 | |||
| 79959 | 176567 | DPW Maintained 1 | Heteromeles arbutifolia :: Toyon 186 | 145 Tioga Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6010201.353 | 2089095.69821 | 37.7168345910218 | -122.406682099409 | (37.7168345910218, -122.406682099409) | 9 | 7 | 8 | 309 | 39 | |||
| 114072 | 176565 | DPW Maintained 1 | Heteromeles arbutifolia :: Toyon 186 | 145 Tioga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010235.34544 | 2089083.11111 | 37.7168019312417 | -122.406563717151 | (37.7168019312417, -122.406563717151) | 9 | 7 | 8 | 309 | 39 | |||
| 145387 | 176562 | DPW Maintained 1 | Heteromeles arbutifolia :: Toyon 186 | 130 Tucker Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010187.91081 | 2088867.13359 | 37.7162062472954 | -122.406712464114 | (37.7162062472954, -122.406712464114) | 9 | 7 | 8 | 309 | 39 | |||
| 165091 | 176564 | DPW Maintained 1 | Heteromeles arbutifolia :: Toyon 186 | 145 Tioga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6010251.14123 | 2089077.27273 | 37.7167867839527 | -122.406508707432 | (37.7167867839527, -122.406508707432) | 9 | 7 | 8 | 309 | 39 | |||
| 184206 | 176558 | DPW Maintained 1 | Heteromeles arbutifolia :: Toyon 186 | 300x Mansell St | 19 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6010777.60358 | 2090452.8911 | 37.7205933893479 | -122.404785768266 | (37.7205933893479, -122.404785768266) | 10 | 3 | 7 | 309 | 28 | |||
| 192663 | 54794 | DPW Maintained 1 | Heteromeles arbutifolia :: Toyon 186 | 340 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | 1 | Permit Number 10644 | 6012527.25356 | 2086869.29429 | 37.7108511883114 | -122.398486411239 | (37.7108511883114, -122.398486411239) | 10 | 3 | 8 | 309 | 1 |
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) );