trees
9 rows where PlotSize = "Width 0ft" and qSpecies_id = 68 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164522 | 199890 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1200x Quesada Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6017354.2822 | 2093058.6837 | 37.7281137963921 | -122.382233221943 | (37.7281137963921, -122.382233221943) | 10 | 3 | 8 | 58 | 1 | |||
| 121576 | 142162 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 490X Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000657 | 2110488 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | 15 | 5 | 11 | 29492 | 16 | |||
| 129805 | 142312 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1691 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5999733.1826 | 2110513.1611 | 37.7750505456338 | -122.444403629404 | (37.7750505456338, -122.444403629404) | 15 | 5 | 11 | 29492 | 16 | |||
| 178755 | 141006 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 269 COLLINS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998171.184 | 2112777.5693 | 37.7811787774786 | -122.449970134459 | (37.7811787774786, -122.449970134459) | 15 | 6 | 2 | 54 | 16 | |||
| 25405 | 185047 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 2767 34th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985832.2143 | 2096586.5348 | 37.7360089113847 | -122.491464150215 | (37.7360089113847, -122.491464150215) | 1 | 8 | 3 | 29491 | 35 | |||
| 55073 | 213701 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 700 Junipero Serra Blvd | 130 | : | Tree | Private 2 | 8 | Width 0ft | 5991210.94255 | 2091714.66662 | 37.7229448341183 | -122.472512833822 | (37.7229448341183, -122.472512833822) | 9 | 8 | 4 | 64 | 40 | |||
| 159933 | 183196 | Undocumented 4 | Prunus spp :: Cherry 68 | 2479 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983931.1246 | 2098292.1691 | 37.740580843976 | -122.498162805629 | (37.740580843976, -122.498162805629) | 1 | 8 | 3 | 29491 | 35 | |||
| 163327 | 181930 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 2431 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5986090.3717 | 2098682.4704 | 37.7417788753673 | -122.49072577603 | (37.7417788753673, -122.49072577603) | 1 | 8 | 3 | 29491 | 35 | |||
| 185049 | 185048 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 2767 34th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985831.6836 | 2096605.638 | 37.7360613326903 | -122.491467390698 | (37.7360613326903, -122.491467390698) | 1 | 8 | 3 | 29491 | 35 |
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) );