trees
12 rows where Zip Codes = 29491 and qSpecies_id = 202
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8257 | 261815 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1601 Quintara St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5988457 | 2100975 | 37.7482115203177 | -122.482710816875 | (37.7482115203177, -122.482710816875) | 1 | 8 | 3 | 29491 | 35 | ||||
9220 | 261816 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1601 Quintara St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5988457 | 2100975 | 37.7482115203177 | -122.482710816875 | (37.7482115203177, -122.482710816875) | 1 | 8 | 3 | 29491 | 35 | ||||
12158 | 261817 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1601 Quintara St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5988457 | 2100975 | 37.7482115203177 | -122.482710816875 | (37.7482115203177, -122.482710816875) | 1 | 8 | 3 | 29491 | 35 | ||||
18595 | 203611 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 146 Quintara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992953.88881 | 2101207.94105 | 37.7491117215315 | -122.467177780245 | (37.7491117215315, -122.467177780245) | 1 | 8 | 4 | 29491 | 12 | |||
20819 | 203614 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2555 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991713.86449 | 2098047.40615 | 37.7403620464585 | -122.47123551863 | (37.7403620464585, -122.47123551863) | 1 | 8 | 4 | 29491 | 40 | |||
39893 | 203608 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2007 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5991583.6607 | 2101714.46197 | 37.7504233054064 | -122.471952911395 | (37.7504233054064, -122.471952911395) | 1 | 8 | 4 | 29491 | 12 | |||
71411 | 203618 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 185 Castenada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994486.24709 | 2100807.40007 | 37.7481002729224 | -122.461849867291 | (37.7481002729224, -122.461849867291) | 1 | 8 | 4 | 29491 | 40 | |||
76777 | 203616 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 185 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994461.21943 | 2100782.80797 | 37.7480313083953 | -122.461934628392 | (37.7480313083953, -122.461934628392) | 1 | 8 | 4 | 29491 | 40 | |||
99215 | 203610 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 146 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992962.70532 | 2101209.82571 | 37.7491174052506 | -122.467147429924 | (37.7491174052506, -122.467147429924) | 1 | 8 | 4 | 29491 | 12 | |||
159601 | 203607 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2007 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5991582.5756 | 2101730.87003 | 37.7504682948863 | -122.471957859468 | (37.7504682948863, -122.471957859468) | 1 | 8 | 4 | 29491 | 12 | |||
171239 | 203609 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 120 Quintara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993075.95674 | 2101213.42516 | 37.7491338250612 | -122.466756070139 | (37.7491338250612, -122.466756070139) | 1 | 8 | 4 | 29491 | 12 | |||
184066 | 203617 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 185 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994473.17466 | 2100793.87749 | 37.7480623907666 | -122.461894090539 | (37.7480623907666, -122.461894090539) | 1 | 8 | 4 | 29491 | 40 |
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) );