trees
11 rows where Fire Prevention Districts = 6 and qSpecies_id = 8
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17486 | 191662 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013078.45063 | 2110885.87068 | 37.776826313422 | -122.398265274217 | (37.776826313422, -122.398265274217) | 6 | 2 | 9 | 28856 | 34 | |||
18922 | 74929 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014021.82023 | 2112985.48182 | 37.7826438712502 | -122.395148955186 | (37.7826438712502, -122.395148955186) | 6 | 2 | 9 | 28856 | 6 | |||
33288 | 191666 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6013244.57038 | 2111045.61556 | 37.7772741883968 | -122.397701819284 | (37.7772741883968, -122.397701819284) | 6 | 2 | 9 | 28856 | 34 | |||
36375 | 191665 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6013224.69067 | 2111029.20074 | 37.7772280099979 | -122.397769438408 | (37.7772280099979, -122.397769438408) | 6 | 2 | 9 | 28856 | 34 | |||
59674 | 191663 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6013137.81115 | 2110946.71833 | 37.7769966935644 | -122.398064196625 | (37.7769966935644, -122.398064196625) | 6 | 2 | 9 | 28856 | 34 | |||
62574 | 191667 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013269.51559 | 2111071.49251 | 37.7773466296777 | -122.397617340561 | (37.7773466296777, -122.397617340561) | 6 | 2 | 9 | 28856 | 34 | |||
69618 | 191057 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 351 Saint Francis Pl | 2 | : | Tree | Private 2 | 4 | Width 1ft | 6013212.85575 | 2113183.51616 | 37.78314260738 | -122.397961541709 | (37.78314260738, -122.397961541709) | 6 | 2 | 9 | 28856 | 6 | |||
146918 | 191664 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013199.96962 | 2111004.76664 | 37.7771595428277 | -122.397853242637 | (37.7771595428277, -122.397853242637) | 6 | 2 | 9 | 28856 | 34 | |||
148796 | 191661 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013060.06963 | 2110865.5961 | 37.7767696201591 | -122.398327437183 | (37.7767696201591, -122.398327437183) | 6 | 2 | 9 | 28856 | 34 | |||
173736 | 191660 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013043.398 | 2110850.10481 | 37.7767261559098 | -122.3983840225 | (37.7767261559098, -122.3983840225) | 6 | 2 | 9 | 28856 | 34 | |||
180320 | 191668 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013300.95519 | 2111099.53181 | 37.7774253698298 | -122.397510546978 | (37.7774253698298, -122.397510546978) | 6 | 2 | 9 | 28856 | 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) );