Street_Tree_List

Data source: data.sfgov.org

18 rows where PlotSize = "Width 2ft" and qSpecies = 136

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
27912 27912 191009 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 1350 Rankin St 4 Side Yard : Yard 17 Tree 1 Private 1     5 Width 2ft   6012766.95212 2096886.7999200001 37.7383705733355 -122.398360372158 (37.7383705733355, -122.398360372158)
36804 36804 176179 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 445 Naples St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6003347.6645 2090993.45154 37.7216595581304 -122.43050726549299 (37.7216595581304, -122.430507265493)
39816 39816 223841 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 1548 Noe St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 2ft   6003280.5948 2099265.14761 37.7443679596294 -122.43132927013 (37.7443679596294, -122.43132927013)
40613 40613 176175 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 89 Ottawa Ave 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 2ft   5998972.727519999 2088619.88467 37.7148934808181 -122.445459617764 (37.7148934808181, -122.445459617764)
48137 48137 223837 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 1201 Douglass St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 2ft   6001376.71765 2100230.2222599997 37.746909744083204 -122.437981578698 (37.7469097440832, -122.437981578698)
48902 48902 202080 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 52 Gould St 1 : 4 Tree 1 Private 1     6 Width 2ft   6012726.46882 2090908.8088599998 37.7219539853837 -122.398081078675 (37.7219539853837, -122.398081078675)
51504 51504 191019 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 1751 Silver Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 2ft   6011288.24464 2095271.1885 37.7338519630013 -122.403359422808 (37.7338519630013, -122.403359422808)
52383 52383 207417 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 850 Quintara St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5990746.38049 2101133.08021 37.7487784984387 -122.47480582713001 (37.7487784984387, -122.47480582713)
65510 65510 126434 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 1425 Jefferson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6002370.67136 2121569.77606 37.8055593011865 -122.436071357532 (37.8055593011865, -122.436071357532)
69096 69096 223833 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 2700 18th St 3 : 4 Tree 1 Private 1     8 Width 2ft   6009765.40934 2105513.7939299997 37.7618907290033 -122.40934692912701 (37.7618907290033, -122.409346929127)
73332 73332 223839 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 1201 Douglass St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 2ft   6001375.46533 2100241.14483 37.7469396636504 -122.437986691344 (37.7469396636504, -122.437986691344)
132694 132694 191008 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 1350 Rankin St 3 Side Yard : Yard 17 Tree 1 Private 1     6 Width 2ft   6012780.96774 2096905.12701 37.7384216764219 -122.398313198195 (37.7384216764219, -122.398313198195)
164115 164115 176173 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 89 Ottawa Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 2ft   5998945.18552 2088649.14892 37.71497226143929 -122.44555691723 (37.7149722614393, -122.44555691723)
167022 167022 176174 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 89 Ottawa Ave 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 2ft   5998957.51819 2088637.0202 37.7149396628061 -122.445513418834 (37.7149396628061, -122.445513418834)
168521 168521 176178 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 445 Naples St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6003345.09348 2090989.4763 37.7216484973556 -122.43051586931999 (37.7216484973556, -122.43051586932)
171316 171316 176172 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 89 Ottawa Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 2ft   5998934.49429 2088660.58419 37.715003049713204 -122.44559469233499 (37.7150030497132, -122.445594692335)
180048 180048 223838 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 1201 Douglass St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 2ft   6001376.54401 2100236.11585 37.7469259166077 -122.43798260121099 (37.7469259166077, -122.437982601211)
181448 181448 223818 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 1760 Dolores St 2 : 4 Tree 1 Private 1     1 Width 2ft   6005274.68264 2098157.0502400002 37.741438185137795 -122.42435532714899 (37.7414381851378, -122.424355327149)

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