trees
20 rows where qSpecies_id = 239
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2623 | 126453 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 1580 Beach St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6002632.74953 | 2121315.04955 | 37.8048747750075 | -122.435146170078 | (37.8048747750075, -122.435146170078) | 13 | 9 | 1 | 57 | 17 | |||
9129 | 223878 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 31 Bronte St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 2ft | 6009376.27143 | 2097261.13323 | 37.7392089483382 | -122.410110157661 | (37.7392089483382, -122.410110157661) | 10 | 7 | 7 | 28859 | 2 | |||
24177 | 34474 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 1725 Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1997 12:00:00 AM | 7 | Permit Number 38203 | 6008694.96274 | 2118939.78665 | 37.7986952688153 | -122.413999021351 | (37.7986952688153, -122.413999021351) | 5 | 1 | 10 | 308 | 21 | ||
37792 | 126454 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 1601 Beach St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6002480.79937 | 2121231.31796 | 37.8046362406351 | -122.435666015098 | (37.8046362406351, -122.435666015098) | 13 | 9 | 1 | 57 | 17 | |||
37899 | 34469 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 1725 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1997 12:00:00 AM | 11 | Permit Number 38203 | 6008690.83144 | 2118964.07906 | 37.7987617377166 | -122.41401503646 | (37.7987617377166, -122.41401503646) | 5 | 1 | 10 | 308 | 21 | ||
45961 | 223879 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 729 Duncan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6001799.82386 | 2099685.87839 | 37.7454391564963 | -122.436479564303 | (37.7454391564963, -122.436479564303) | 2 | 7 | 5 | 63 | 22 | |||
48653 | 126455 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 1725 Taylor St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6008696.32426 | 2118925.01888 | 37.7986547966497 | -122.413993264774 | (37.7986547966497, -122.413993264774) | 5 | 1 | 10 | 308 | 21 | |||
59963 | 126452 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 1580 Beach St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6002659.55482 | 2121318.7204 | 37.8048863762746 | -122.435053670306 | (37.8048863762746, -122.435053670306) | 13 | 9 | 1 | 57 | 17 | |||
64975 | 117707 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 4001 Clement St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 7ft | 5983042.01259 | 2113079.3554 | 37.7811300949846 | -122.502331044828 | (37.7811300949846, -122.502331044828) | 11 | 6 | 2 | 55 | 26 | |||
89048 | 126460 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 1077 Front St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6012603.51753 | 2119981.99214 | 37.8017756581763 | -122.400547336316 | (37.8017756581763, -122.400547336316) | 3 | 1 | 10 | 28860 | 6 | ||||
94391 | 117709 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 4001 Clement St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 5983023.36584 | 2113077.55597 | 37.7811240586583 | -122.502395419014 | (37.7811240586583, -122.502395419014) | 11 | 6 | 2 | 55 | 26 | |||
94803 | 126457 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 1077 Front St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6012574.12076 | 2120110.81516 | 37.8021277355747 | -122.400658118379 | (37.8021277355747, -122.400658118379) | 3 | 1 | 10 | 28860 | 6 | ||||
99907 | 126456 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 407 Vallejo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6011480.28729 | 2119030.06568 | 37.7990991939222 | -122.404367213001 | (37.7990991939222, -122.404367213001) | 3 | 1 | 10 | 308 | 23 | ||||
103054 | 117705 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 4001 Clement St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 5983063.64448 | 2113080.62009 | 37.7811348384244 | -122.502256304119 | (37.7811348384244, -122.502256304119) | 11 | 6 | 2 | 55 | 26 | |||
122802 | 126451 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 2399 North Point St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 5999388.94464 | 2120451.55181 | 37.8023191122032 | -122.446309508593 | (37.8023191122032, -122.446309508593) | 13 | 9 | 1 | 57 | 17 | |||
147802 | 191032 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 601 Wisconsin St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6012727.08762 | 2104619.55574 | 37.7596008392272 | -122.399040815378 | (37.7596008392272, -122.399040815378) | 10 | 3 | 8 | 28856 | 29 | |||
171954 | 126459 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 1077 Front St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6012590.31572 | 2120009.18075 | 37.8018495752678 | -122.400594932009 | (37.8018495752678, -122.400594932009) | 3 | 1 | 10 | 28860 | 6 | ||||
179994 | 126458 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 1077 Front St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6012574.01246 | 2120093.81487 | 37.8020810508486 | -122.400657298194 | (37.8020810508486, -122.400657298194) | 3 | 1 | 10 | 28860 | 6 | ||||
186621 | 34471 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 1725 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1997 12:00:00 AM | 8 | Permit Number 38203 | 6008692.88551 | 2118954.47998 | 37.7987354963894 | -122.41400724926 | (37.7987354963894, -122.41400724926) | 5 | 1 | 10 | 308 | 21 | ||
189518 | 117706 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 4001 Clement St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 5983046.11762 | 2113079.58173 | 37.7811309576133 | -122.502316860458 | (37.7811309576133, -122.502316860458) | 11 | 6 | 2 | 55 | 26 |
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) );