trees
6 rows where Neighborhoods (old) = 2 and qSpecies_id = 54
This data as json, CSV (advanced)
These facets timed out: Neighborhoods (old)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23530 | 245383 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3720 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6005268.7499 | 2096538.92 | 37.7369948294896 | -122.424260783275 | (37.7369948294896, -122.424260783275) | 2 | 7 | 5 | 28859 | 2 | |||
48097 | 15626 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005569.6902 | 2097797.6263 | 37.7404679423018 | -122.423309747569 | (37.7404679423018, -122.423309747569) | 2 | 7 | 7 | 28859 | 2 | |||
116079 | 15627 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005560.95 | 2097781.3943 | 37.7404228796109 | -122.423338814191 | (37.7404228796109, -122.423338814191) | 2 | 7 | 7 | 28859 | 2 | |||
130276 | 245378 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005581.5521 | 2097815.7311 | 37.7405183234498 | -122.423270020371 | (37.7405183234498, -122.423270020371) | 2 | 7 | 7 | 28859 | 2 | |||
142974 | 245382 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3720 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005277.267 | 2096556.8057 | 37.7370444205252 | -122.424232607489 | (37.7370444205252, -122.424232607489) | 2 | 7 | 5 | 28859 | 2 | |||
146796 | 15628 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005530.9833 | 2097730.2012 | 37.7402806235852 | -122.423438788897 | (37.7402806235852, -122.423438788897) | 2 | 7 | 7 | 28859 | 2 |
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) );