Street_Tree_List

Data source: data.sfgov.org

11 rows where DBH = 6, SiteOrder = 2 and qSpecies = 42

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
15903 15903 20055 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
25732 25732 220090 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Ord Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6000882.83826 2105748.10477 37.7620324153945 -122.44008496885401 (37.7620324153945, -122.440084968854)
32463 32463 174965 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1645 Felton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6006090.3331 2092391.29935 37.725652733270294 -122.42112577893101 (37.7256527332703, -122.421125778931)
35471 35471 140101 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 771 Central Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5999584.517999999 2111094.1746 37.7766373769699 -122.44495966716002 (37.7766373769699, -122.44495966716)
65658 65658 183506 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2542 27th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5988021.6131 2097993.9577 37.7400010259161 -122.483997786352 (37.7400010259161, -122.483997786352)
91582 91582 23671 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 317 Virginia Ave 2 Median : Cutout 11 Tree 1 DPW 2     6 12   6006937.941544901 2098264.8464559 37.7418279505329 -122.41861198258002 (37.7418279505329, -122.41861198258)
156503 156503 174960 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 103 De Long St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 10ft   5994409.5991400005 2086788.1181299998 37.709602327657706 -122.461098897396 (37.7096023276577, -122.461098897396)
159913 159913 138338 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2250 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6001931.2408 2114335.4048 37.7856706283151 -122.437073793387 (37.7856706283151, -122.437073793387)
176496 176496 75331 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 De Long St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 6     5994458.53323 2086786.7483599999 37.709601382461294 -122.460929674682 (37.7096013824613, -122.460929674682)
181456 181456 50381 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1330 Greenwich St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/23/2003 12:00:00 AM 6 3x3 Permit Number 47040 6006481.85746 2119759.67415 37.8008219271496 -122.42171535199499 (37.8008219271496, -122.421715351995)
183618 183618 220682 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1624 Florida St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6009643.101369999 2100250.00573 37.7474306916674 -122.40939845218 (37.7474306916674, -122.40939845218)

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 530.324ms · Data source: data.sfgov.org