Street_Tree_List

Data source: data.sfgov.org

14 rows where DBH = 8 and qSpecies = 66

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
565 565 206617 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 198 Garcia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5994686.63181 2099351.09779 37.7441131663853 -122.461051409618 (37.7441131663853, -122.461051409618)
571 571 206618 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 198 Garcia Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft Permit Number 779324 5994673.79551 2099409.87557 37.7442738167873 -122.461100053935 (37.7442738167873, -122.461100053935)
30345 30345 206561 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 355 Yerba Buena Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5995302.34368 2095238.1668900002 37.732855482695 -122.458624745542 (37.732855482695, -122.458624745542)
42406 42406 182596 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 945 Rivera St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   5990197.9307 2100380.5725 37.746680511997496 -122.47664737488998 (37.7466805119975, -122.47664737489)
51395 51395 206653 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 150 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5994496.6283 2101014.48441 37.748669471824 -122.46182898323 (37.748669471824, -122.46182898323)
57368 57368 206595 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 135 Magellan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5995084.10326 2100870.93077 37.7483091116899 -122.45978711747601 (37.7483091116899, -122.459787117476)
72889 72889 206577 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 215 Dorantes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993636.2641900005 2099712.16168 37.745044057332294 -122.464709533316 (37.7450440573323, -122.464709533316)
75402 75402 206548 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 160 Dorantes Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   5993741.1056699995 2099827.07051 37.7453656117262 -122.464355354239 (37.7453656117262, -122.464355354239)
122539 122539 190926 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1303 Rhode Island St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6012003.88758 2102215.75937 37.7529602155494 -122.40137308660401 (37.7529602155494, -122.401373086604)
137065 137065 182595 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 955 Rivera St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   5990177.9035 2100379.6188 37.746676731738894 -122.4767165565 (37.7466767317389, -122.4767165565)
153258 153258 206575 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 120 Montalvo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993692.18131 2099632.63233 37.744828913423 -122.464510409921 (37.744828913423, -122.464510409921)
155632 155632 206594 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 135 Magellan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5995087.43611 2100841.3404599996 37.7482280558 -122.459773449604 (37.7482280558, -122.459773449604)
165477 165477 206591 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 101 Montalvo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993709.625030001 2099698.37793 37.745010439781296 -122.464454865994 (37.7450104397813, -122.464454865994)
168083 168083 32398 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 244 Richland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/03/1996 12:00:00 AM 8   Permit Number 36939 6005971.23324 2096091.5920900002 37.7358062077876 -122.42180021560199 (37.7358062077876, -122.421800215602)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 387.699ms · Data source: data.sfgov.org