trees

11 rows where Supervisor Districts = 10 and qSpecies_id = 96

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
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
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
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
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
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);