Street_Tree_List

Data source: data.sfgov.org

18 rows where DBH = 8 and qSiteInfo = 23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qSpecies, qAddress, SiteOrder

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
28022 28022 189675 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 24th St 10 : Yard 23 Tree 1 Private 1     8     6017194.50129 2102669.93128 37.754495514781496 -122.383454393407 (37.7544955147815, -122.383454393407)
29380 29380 196093 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 01st St 25 : Yard 23 Tree 1 Private 1     8     6014406.1146599995 2105887.9731 37.763177058994 -122.39332261913601 (37.763177058994, -122.393322619136)
30029 30029 196074 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 7 : Yard 23 Tree 1 Private 1     8     6014974.36324 2102149.68411 37.7529440736099 -122.391095913948 (37.7529440736099, -122.391095913948)
37053 37053 218147 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 33 Ashton Ave 1 : Yard 23 Tree 1 Private 1     8     5994130.90264 2090096.18725 37.7186694580143 -122.462301880921 (37.7186694580143, -122.462301880921)
37605 37605 237004 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 199 Franconia St 15 : Yard 23 Tree 1 Private 1     8 Width 3ft   6010095.49496 2099684.36191 37.7459028946219 -122.40779421904101 (37.7459028946219, -122.407794219041)
38976 38976 199555 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 1 01st St 15 : Yard 23 Tree 1 Private 1     8     6014446.64039 2105914.6589900004 37.763252584054605 -122.393184320496 (37.7632525840546, -122.393184320496)
48818 48818 222665 Undocumented 2 Ceanothus Sps :: California lilac 270 4090 20th St 4 : Yard 23 Tree 1 Private 1     8 Width 3ft   6003145.04093 2104185.04238 37.7578691478694 -122.432149263871 (37.7578691478694, -122.432149263871)
51964 51964 192363 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1310 Indiana St 26 : Yard 23 Tree 1 Private 1     8     6014946.149019999 2102349.52066 37.753491216648705 -122.39120745237899 (37.7534912166487, -122.391207452379)
59106 59106 189293 Undocumented 2 Cordyline australis :: Dracena Palm 141 1 01st St 35 : Yard 23 Tree 1 Private 1     8     6014389.3663800005 2105866.30731 37.7631166389548 -122.39337903001801 (37.7631166389548, -122.393379030018)
65367 65367 222666 Undocumented 2 Ceanothus Sps :: California lilac 270 4090 20th St 5 : Yard 23 Tree 1 Private 1     8 Width 3ft   6003140.83414 2104172.66898 37.7578349349576 -122.432162929082 (37.7578349349576, -122.432162929082)
70245 70245 190636 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 1 01st St 30 : Yard 23 Tree 1 Private 1     8     6014391.99798 2105898.86804 37.763206189822796 -122.393372206868 (37.7632061898228, -122.393372206868)
70325 70325 192365 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1310 Indiana St 21 : Yard 23 Tree 1 Private 1     8     6014917.078430001 2102437.6688900003 37.7537316396243 -122.391314147037 (37.7537316396243, -122.391314147037)
74435 74435 192364 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1310 Indiana St 23 : Yard 23 Tree 1 Private 1     8     6014928.1243 2102399.042 37.7536261914184 -122.391273247671 (37.7536261914184, -122.391273247671)
76142 76142 234859 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 160 Carnelian Way 1 : Yard 23 Tree 1 Private 1     8     6000570.21064 2100519.3738 37.7476577875765 -122.44079113720801 (37.7476577875765, -122.440791137208)
134605 134605 194275 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1 01st St 34 : Yard 23 Tree 1 Private 1     8     6014376.659969999 2105881.88915 37.76315871732 -122.39342406806101 (37.76315871732, -122.393424068061)
148293 148293 192370 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1310 Indiana St 9 : Yard 23 Tree 1 Private 1     8     6015014.73228 2102443.11605 37.7537520155509 -122.390976815833 (37.7537520155509, -122.390976815833)
152443 152443 196094 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 01st St 26 : Yard 23 Tree 1 Private 1     8     6014400.8809 2105882.83985 37.7631626734333 -122.393340361863 (37.7631626734333, -122.393340361863)
165472 165472 199546 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 1 01st St 2 : Yard 23 Tree 1 Private 1     8     6014366.09507 2105920.56167 37.7632643166198 -122.393463315392 (37.7632643166198, -122.393463315392)

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