trees
12 rows where DBH = 2 and qLegalStatus_id = 2 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5835 | 118375 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x6 | 6014712.48727 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | 6 | 2 | 9 | 28855 | 6 | |||
37358 | 247943 | Planning Code 138.1 required 2 | Maytenus boaria :: Mayten 58 | 29 Joy St | 6 | Unaccepted Street : Yard | Tree | DPW 1 | 2 | Permit Number 775404 | 6010304.2598 | 2098903.51059 | 37.7437705318851 | -122.407017307297 | (37.7437705318851, -122.407017307297) | 2 | 7 | 7 | 28859 | 2 | |||
57149 | 115098 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010148.06204 | 2111925.42664 | 37.7795170247346 | -122.408475763058 | (37.7795170247346, -122.408475763058) | 14 | 2 | 9 | 28853 | 34 | |
93218 | 113240 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 329 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 2 | 3x4 | Permit Number 770912 | 6014728.70394 | 2112464.72966 | 37.7812532891345 | -122.392666980121 | (37.7812532891345, -122.392666980121) | 6 | 2 | 9 | 28856 | 6 | |
96451 | 225775 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 577 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | Permit Number 782239 | 6002401.77617 | 2104846.28665 | 37.75964259654 | -122.43476706624 | (37.75964259654, -122.43476706624) | 2 | 4 | 5 | 28862 | 3 | ||
98758 | 101942 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010108.29372 | 2111885.47528 | 37.7794051005107 | -122.408610520167 | (37.7794051005107, -122.408610520167) | 14 | 2 | 9 | 28853 | 34 | |
118314 | 120115 | Planning Code 138.1 required 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 2225 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6000127.23839 | 2120216.52423 | 37.8017159270068 | -122.443737765003 | (37.8017159270068, -122.443737765003) | 13 | 9 | 1 | 57 | 17 | |||
122740 | 115096 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010119.08101 | 2111896.4319 | 37.7794357889593 | -122.408573975335 | (37.7794357889593, -122.408573975335) | 14 | 2 | 9 | 28853 | 34 | |
141915 | 225774 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 577 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | Permit Number 782239 | 6002400.68275 | 2104833.82508 | 37.7596083179996 | -122.434769956692 | (37.7596083179996, -122.434769956692) | 2 | 4 | 5 | 28862 | 3 | ||
159283 | 192594 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/1995 12:00:00 AM | 2 | Width 4ft | Permit Number 770747 | 6008274.3646 | 2110675.08431 | 37.7759787734355 | -122.414869184668 | (37.7759787734355, -122.414869184668) | 8 | 2 | 9 | 28853 | 34 | |
180615 | 122686 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3474 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6005720 | 2106109 | 37.7632975389877 | -122.423380737252 | (37.7632975389877, -122.423380737252) | 8 | 4 | 5 | 28859 | 19 | |||
183224 | 115097 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010133.89472 | 2111910.59383 | 37.779475503918 | -122.408523727481 | (37.779475503918, -122.408523727481) | 14 | 2 | 9 | 28853 | 34 |
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) );