trees

13 rows where Supervisor Districts = 1 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)
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
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
75124 126356 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 101 Marina Blvd 3 Front Yard : Yard Tree Private 2     8     6002934.90654 2121377.37848 37.8050630669581 -122.434104982679 (37.8050630669581, -122.434104982679) 13 9 1 57 17
81196 250505 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 55 27th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     21     5987243.87038 2115583.56444 37.7882519230241 -122.487978957983 (37.7882519230241, -122.487978957983) 11 6 1 55 33
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
132532 249676 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2400 Baker St 8 Front Yard : Yard Tree Private 2     15     5999736.34659 2117174.55896 37.7933411972934 -122.444871632924 (37.7933411972934, -122.444871632924) 13 9 1 57 27
143058 122924 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2 11th Ave 5 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   5992431.96311 2114886.35785 37.7866388652474 -122.469978400459 (37.7866388652474, -122.469978400459) 11 6 1 54 11
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
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

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