trees

14 rows where DBH = 8 and qSpecies_id = 133

✎ View and edit SQL

This data as json, CSV (advanced)

DBH ✖

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)
19680 206561 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 355 Yerba Buena Ave 3 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5995302.34368 2095238.16689 37.732855482695 -122.458624745542 (37.732855482695, -122.458624745542) 9 7 4 59 40
35026 206591 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 101 Montalvo Ave 3 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5993709.62503 2099698.37793 37.7450104397813 -122.464454865994 (37.7450104397813, -122.464454865994) 1 8 4 29491 40
39852 206617 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 198 Garcia Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5994686.63181 2099351.09779 37.7441131663853 -122.461051409618 (37.7441131663853, -122.461051409618) 1 8 4 59 40
45462 206618 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 198 Garcia Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft Permit Number 779324 5994673.79551 2099409.87557 37.7442738167873 -122.461100053935 (37.7442738167873, -122.461100053935) 1 8 4 59 40
54562 206595 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 135 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5995084.10326 2100870.93077 37.7483091116899 -122.459787117476 (37.7483091116899, -122.459787117476) 1 8 4 29491 40
78570 206653 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 150 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5994496.6283 2101014.48441 37.748669471824 -122.46182898323 (37.748669471824, -122.46182898323) 1 8 4 29491 40
86127 32398 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 244 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 8   Permit Number 36939 6005971.23324 2096091.59209 37.7358062077876 -122.421800215602 (37.7358062077876, -122.421800215602) 2 7 7 28859 2
86236 190926 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1303 Rhode Island St 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 7ft   6012003.88758 2102215.75937 37.7529602155494 -122.401373086604 (37.7529602155494, -122.401373086604) 10 3 8 28856 29
106812 206577 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 215 Dorantes Ave 3 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5993636.26419 2099712.16168 37.7450440573323 -122.464709533316 (37.7450440573323, -122.464709533316) 1 8 4 29491 40
123636 182596 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 945 Rivera St 3 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5990197.9307 2100380.5725 37.7466805119975 -122.47664737489 (37.7466805119975, -122.47664737489) 1 8 3 29491 35
133928 206594 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 135 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5995087.43611 2100841.34046 37.7482280558 -122.459773449604 (37.7482280558, -122.459773449604) 1 8 4 29491 40
140979 206548 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 160 Dorantes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5993741.10567 2099827.07051 37.7453656117262 -122.464355354239 (37.7453656117262, -122.464355354239) 1 8 4 29491 40
171037 182595 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 955 Rivera St 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5990177.9035 2100379.6188 37.7466767317389 -122.4767165565 (37.7466767317389, -122.4767165565) 1 8 3 29491 35
186941 206575 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 120 Montalvo Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5993692.18131 2099632.63233 37.744828913423 -122.464510409921 (37.744828913423, -122.464510409921) 1 8 4 29491 40

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