trees
13 rows where Zip Codes = 57 and qLegalStatus_id = 2 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4259 | 33111 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 4x4 | Permit Number 769981 | 6000363.34088 | 2118561.77591 | 37.7971858916671 | -122.442801853125 | (37.7971858916671, -122.442801853125) | 13 | 9 | 1 | 57 | 17 | |
| 15497 | 33110 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2626 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2020 12:00:00 AM | 3 | Permit Number 769981 | 6000381.41365 | 2118563.70291 | 37.7971922129921 | -122.442739455458 | (37.7971922129921, -122.442739455458) | 13 | 9 | 1 | 57 | 17 | |
| 17726 | 65839 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2328 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2018 12:00:00 AM | 3 | 6x6 | Permit Number 772721 | 5999589.88517 | 2120533.82376 | 37.802556482867 | -122.445620078411 | (37.802556482867, -122.445620078411) | 13 | 9 | 1 | 57 | 17 | |
| 70470 | 146088 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2828 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777329 | 6003000.78966 | 2118372.69184 | 37.7968167208658 | -122.433662110612 | (37.7968167208658, -122.433662110612) | 13 | 9 | 1 | 57 | 17 | |
| 81974 | 256777 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2828 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777329 | 6003004.23187 | 2118313.15271 | 37.7966534371422 | -122.433645942426 | (37.7966534371422, -122.433645942426) | 13 | 9 | 1 | 57 | 17 | |
| 86670 | 146397 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3318 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 780850 | 6000857.39871 | 2119780.85133 | 37.8005613036105 | -122.441179804419 | (37.8005613036105, -122.441179804419) | 13 | 9 | 1 | 57 | 17 | |
| 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 | |||
| 119169 | 117250 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 2474 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773044 | 6001780.62325 | 2117368.05955 | 37.7939889537763 | -122.437812170719 | (37.7939889537763, -122.437812170719) | 13 | 9 | 1 | 57 | 27 | |
| 127597 | 103379 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 2712 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770136 | 6000520 | 2117210 | 37.7934832007909 | -122.44216269001 | (37.7934832007909, -122.44216269001) | 13 | 9 | 1 | 57 | 27 | |
| 145251 | 108356 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002158.91155 | 2118972.60439 | 37.7984161192732 | -122.436618162405 | (37.7984161192732, -122.436618162405) | 13 | 9 | 1 | 57 | 17 | |
| 148677 | 121464 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 2353 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001140 | 2119261 | 37.7991500226194 | -122.440164592168 | (37.7991500226194, -122.440164592168) | 13 | 9 | 1 | 57 | 17 | ||||
| 148701 | 115559 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2539 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6001373.79142 | 2117611.09107 | 37.7946331129763 | -122.439237274207 | (37.7946331129763, -122.439237274207) | 13 | 9 | 1 | 57 | 27 | |||
| 175587 | 68987 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 767 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 775182 | 5999291.63198947 | 2121477.34728573 | 37.8051301110493 | -122.44672010757 | (37.8051301110493, -122.44672010757) | 13 | 9 | 1 | 57 | 17 |
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) );