trees
17 rows where qSpecies_id = 178
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1200 | 216506 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 900x Bosworth St | 13 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6001233.37936 | 2095653.14321 | 37.7343340068125 | -122.438149402085 | (37.7343340068125, -122.438149402085) | 9 | 7 | 5 | 63 | 40 | |||
4348 | 8013 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 440 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2014 12:00:00 AM | 3 | 3X3 | 6005616.7891 | 2111728.1123 | 37.7787204453524 | -122.424137349487 | (37.7787204453524, -122.424137349487) | 7 | 9 | 11 | 28852 | 41 | ||
7103 | 244384 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 257 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6005748.2149 | 2110309.2015 | 37.7748318806023 | -122.423581789147 | (37.7748318806023, -122.423581789147) | 7 | 9 | 11 | 28852 | 10 | |||
12168 | 16904 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 436 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2019 12:00:00 AM | 0 | 5x5 | 6004894.34322 | 2110238.30688 | 37.7745889872376 | -122.426530461628 | (37.7745889872376, -122.426530461628) | 7 | 9 | 11 | 28852 | 10 | ||
12910 | 216505 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 900x Bosworth St | 12 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6001265.79395 | 2095643.61475 | 37.7343096873325 | -122.438036652279 | (37.7343096873325, -122.438036652279) | 9 | 7 | 5 | 63 | 40 | |||
13338 | 139990 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 420 FULTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 0ft | 6005718.4601 | 2111739.4091 | 37.7787572035843 | -122.423786432963 | (37.7787572035843, -122.423786432963) | 7 | 9 | 11 | 28852 | 41 | |||
14104 | 262548 | Undocumented 4 | Quercus tomentella :: Island oak 178 | 1299 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2020 12:00:00 AM | 3x3 | 6013984 | 2090616 | 37.7212199518701 | -122.3937135928 | (37.7212199518701, -122.3937135928) | 10 | 3 | 8 | 58 | 1 | |||
17425 | 216508 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 900x Bosworth St | 15 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6001172.10399 | 2095668.84575 | 37.7343736372378 | -122.438362375028 | (37.7343736372378, -122.438362375028) | 9 | 7 | 5 | 63 | 40 | |||
18726 | 264651 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 1336 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:44:00 PM | 3x3 | 6015353.59085 | 2090731.74459 | 37.7216137760513 | -122.388987345186 | (37.7216137760513, -122.388987345186) | 10 | 3 | 8 | 58 | 1 | |||
18995 | 264634 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 1240 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2020 12:00:00 AM | 4x6 | 6015097 | 2090604 | 37.7212487882021 | -122.389865399961 | (37.7212487882021, -122.389865399961) | 10 | 3 | 8 | 58 | 1 | ||
49231 | 38821 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 426 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2016 12:00:00 AM | 3 | Permit Number 777484 | 5994995.06923 | 2112615.41295 | 37.7805512921286 | -122.460946081899 | (37.7805512921286, -122.460946081899) | 11 | 6 | 2 | 54 | 11 | |
61328 | 100078 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 266 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | 4x4 | Permit Number 776410 | 5990586.53381 | 2113609.7978 | 37.7830269371305 | -122.476269792865 | (37.7830269371305, -122.476269792865) | 11 | 6 | 2 | 54 | 26 | |
140546 | 182375 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 1538 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | FUF | 0 | Width 0ft | 5985927.969 | 2104741.9588 | 37.7584070950586 | -122.49173327092 | (37.7584070950586, -122.49173327092) | 1 | 8 | 3 | 56 | 35 | ||
142036 | 100076 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 262 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | 4x4 | Permit Number 776532 | 5990584.51145 | 2113652.92092 | 37.783145223942 | -122.476279940242 | (37.783145223942, -122.476279940242) | 11 | 6 | 2 | 54 | 26 | |
147936 | 243340 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 1025 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781847 | 6010255.04881 | 2103221.20012 | 37.7556232025748 | -122.407491812102 | (37.7556232025748, -122.407491812102) | 10 | 4 | 7 | 28859 | 19 | |
159194 | 94033 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 1300X Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/27/2015 12:11:00 PM | 3 | 4x4 | 6015693.111 | 2095268.768 | 37.7340903547738 | -122.388130169005 | (37.7340903547738, -122.388130169005) | 10 | 3 | 8 | 58 | 1 | |
173023 | 94035 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 1300X Lane St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 32 | 5x5 | 6015684.8669 | 2095240.1882 | 37.7340114236329 | -122.388156677838 | (37.7340114236329, -122.388156677838) | 10 | 3 | 8 | 58 | 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) );