trees
14 rows where Fire Prevention Districts = 5 and qSpecies_id = 96
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20410 | 126359 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6007620.5753 | 2119577.58313 | 37.8003860977102 | -122.417761987128 | (37.8003860977102, -122.417761987128) | 5 | 1 | 1 | 28858 | 32 | |||
28938 | 126364 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6007584.0296 | 2119571.97409 | 37.8003686400458 | -122.417888052307 | (37.8003686400458, -122.417888052307) | 5 | 1 | 1 | 28858 | 32 | |||
35470 | 126362 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6007597.96218 | 2119573.74544 | 37.8003742878151 | -122.417839965548 | (37.8003742878151, -122.417839965548) | 5 | 1 | 1 | 28858 | 32 | |||
48886 | 126363 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6007594.76747 | 2119573.62389 | 37.8003737742816 | -122.417851011923 | (37.8003737742816, -122.417851011923) | 5 | 1 | 1 | 28858 | 32 | |||
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 | ||||
70399 | 121205 | Significant Tree 6 | Cotoneaster SPP :: Cotoneaster 96 | 930 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x3 | 6007386.5238 | 2120591.43483 | 37.8031567047665 | -122.418643837145 | (37.8031567047665, -122.418643837145) | 5 | 1 | 1 | 28858 | 32 | |||
71395 | 126365 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1151 Lombard St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6006751.38188 | 2120096.64647 | 37.8017623625961 | -122.42080661943 | (37.8017623625961, -122.42080661943) | 5 | 1 | 1 | 28858 | 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 | ||||
114113 | 126361 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6007604.93039 | 2119574.72474 | 37.8003773688712 | -122.417815922163 | (37.8003773688712, -122.417815922163) | 5 | 1 | 1 | 28858 | 32 | |||
151568 | 126358 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 2700 Larkin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6006530.21172 | 2120848.51447 | 37.803814332215 | -122.421625403593 | (37.803814332215, -122.421625403593) | 5 | 9 | 1 | 28858 | 32 | |||
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 | |||
191212 | 126360 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6007607.19826 | 2119575.42635 | 37.8003794229421 | -122.41780812417 | (37.8003794229421, -122.41780812417) | 5 | 1 | 1 | 28858 | 32 |
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) );