trees

107 rows where qCaretaker_id = 3 sorted by DBH descending

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

PlotSize ✖

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)
161563 116580 Significant Tree 6 Shrub :: Shrub 66 3000x 19TH AVE 3 Sidewalk: Property side : Cutout Landscaping MTA 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
162950 122415 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 499x Ocean Ave 12 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
166166 120598 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 6 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
167673 116622 Undocumented 4 Olea europaea :: Olive Tree 9 5732X GEARY BLVD 3 Front Yard : Cutout Tree MTA 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
173056 122420 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2200 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998886 2091075 37.7216297132481 -122.445935857536 (37.7216297132481, -122.445935857536) 9 7 6 28861 25
174243 116623 Undocumented 4 Olea europaea :: Olive Tree 9 5732X GEARY BLVD 4 Front Yard : Cutout Tree MTA 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
178661 121201 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 423 18th Ave 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5990242 2112483 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216) 11 6 2 55 26

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