trees
11 rows where Supervisor Districts = 10 and qSpecies_id = 96 sorted by qCaretaker_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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17076 | 126371 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 37 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6011427.3089 | 2120158.66 | 37.8021950785935 | -122.404630029046 | (37.8021950785935, -122.404630029046) | 3 | 1 | 10 | 308 | 23 | |||
52277 | 126370 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 31 | Median : Yard | Tree | DPW 1 | 10 | Width 8ft | 6011433.37611 | 2120083.33032 | 37.801988580771 | -122.404603727506 | (37.801988580771, -122.404603727506) | 3 | 1 | 10 | 308 | 23 | |||
192482 | 126369 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 30 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6011435.17205 | 2120070.79941 | 37.8019542743222 | -122.404596630044 | (37.8019542743222, -122.404596630044) | 3 | 1 | 10 | 308 | 23 | |||
10292 | 249831 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 339 Greenwich St | 4 | Front Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011175.54294 | 2120361.59598 | 37.802738216951 | -122.40551556629 | (37.802738216951, -122.40551556629) | 3 | 1 | 10 | 308 | 23 | |||
48088 | 249827 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 339 Greenwich St | 6 | Front Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6011143.97494 | 2120350.69369 | 37.8027065167616 | -122.405624039843 | (37.8027065167616, -122.405624039843) | 3 | 1 | 10 | 308 | 23 | |||
62670 | 126368 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 12 MacOndray Ln | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6008550.57003 | 2119171.07932 | 37.799322230301 | -122.414515043334 | (37.799322230301, -122.414515043334) | 5 | 1 | 10 | 308 | 32 | ||||
93688 | 126367 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 12 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6008558.64868 | 2119172.9159 | 37.7993277269402 | -122.414487218323 | (37.7993277269402, -122.414487218323) | 5 | 1 | 10 | 308 | 32 | ||||
96964 | 126366 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 99 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 56 | 6008010.57204 | 2119080.43937 | 37.7990430042822 | -122.416377206564 | (37.7990430042822, -122.416377206564) | 5 | 1 | 10 | 308 | 32 | ||||
115956 | 249832 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 339 Greenwich St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011163.78015 | 2120353.28367 | 37.802714735662 | -122.405555685946 | (37.802714735662, -122.405555685946) | 3 | 1 | 10 | 308 | 23 | |||
165925 | 108733 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 12X MacOndray Ln | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6008571.72163 | 2119174.99094 | 37.7993341588901 | -122.41444212811 | (37.7993341588901, -122.41444212811) | 5 | 1 | 10 | 308 | 32 | ||||
174251 | 126357 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 53 Priest St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6008293.62277 | 2117215.49565 | 37.79393824372 | -122.41526566339 | (37.79393824372, -122.41526566339) | 5 | 1 | 10 | 28858 | 21 |
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) );