Street_Tree_List

Data source: data.sfgov.org

21 rows where qSiteInfo = 7 and qSpecies = 70

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH

qSiteInfo ✖

  • Front Yard : Yard · 21 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
28352 28352 125438 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 250 Euclid Ave 0 Front Yard : Yard 7 Tree 1 Private 1     15     5998091.24108 2114006.2469099998 37.78454782955 -122.45033529224199 (37.78454782955, -122.450335292242)
35263 35263 249989 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 228 Filbert St 5 Front Yard : Yard 7 Tree 1 Private 1     2 Width 0ft   6011581.894069999 2120103.40396 37.802051997370896 -122.404091195777 (37.8020519973709, -122.404091195777)
39363 39363 249821 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 281 Kearny St 2 Front Yard : Yard 7 Tree 1 Private 1     14 Width 0ft   6010901.8759699995 2120623.17353 37.8034411387496 -122.406481040676 (37.8034411387496, -122.406481040676)
41677 41677 249947 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 305 Filbert St 2 Front Yard : Yard 7 Tree 1 Private 1     7 Width 0ft   6011342.9125 2120054.18632 37.8019035022036 -122.40491472295 (37.8019035022036, -122.40491472295)
45739 45739 249986 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 228 Filbert St 2 Front Yard : Yard 7 Tree 1 Private 1     4 Width 0ft   6011589.33259 2120106.08083 37.802059763014 -122.404065643309 (37.802059763014, -122.404065643309)
46865 46865 249820 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 281 Kearny St 1 Front Yard : Yard 7 Tree 1 Private 1     13 Width 0ft   6010902.80513 2120614.31353 37.8034168633488 -122.40647720057301 (37.8034168633488, -122.406477200573)
61458 61458 249988 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 228 Filbert St 4 Front Yard : Yard 7 Tree 1 Private 1     3 Width 0ft   6011583.89861 2120104.21147 37.802054326596206 -122.404084315938 (37.8020543265962, -122.404084315938)
61770 61770 249991 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 228 Filbert St 7 Front Yard : Yard 7 Tree 1 Private 1     2 Width 0ft   6011578.47013 2120102.62532 37.802049668108396 -122.404102989475 (37.8020496681084, -122.404102989475)
63040 63040 249939 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 331 Filbert St 1 Front Yard : Yard 7 Tree 1 Private 1     7 Width 0ft   6011281.55151 2120038.154 37.801856051265204 -122.40512593233 (37.8018560512652, -122.40512593233)
70754 70754 249984 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 226 Filbert St 2 Front Yard : Yard 7 Tree 1 Private 1     10 Width 0ft   6011604.5053 2120111.99388 37.8020768465317 -122.404013554575 (37.8020768465317, -122.404013554575)
74131 74131 249946 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 305 Filbert St 1 Front Yard : Yard 7 Tree 1 Private 1     12 Width 0ft   6011346.83837 2120055.6582400003 37.801907763181205 -122.404901241218 (37.8019077631812, -122.404901241218)
94135 94135 101466 Significant Tree 6 Afrocarpus gracilior :: Fern Pine 70 301 Hazelwood Ave 1 Front Yard : Yard 7 Tree 1 Private 1           5996219.7 2095283.8 37.733033461480495 -122.45545652663701 (37.7330334614805, -122.455456526637)
121106 121106 102478 Significant Tree 6 Afrocarpus gracilior :: Fern Pine 70 760 Victoria St 4 Front Yard : Yard 7 Tree 1 Private 1           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167)
133037 133037 249983 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 226 Filbert St 1 Front Yard : Yard 7 Tree 1 Private 1     13 Width 0ft   6011603.53088 2120119.93244 37.8020985894405 -122.40401748554301 (37.8020985894405, -122.404017485543)
137536 137536 249818 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 285 Kearny St 4 Front Yard : Yard 7 Tree 1 Private 1     24 Width 0ft   6010887.46579 2120660.30432 37.803542284601996 -122.40653352599399 (37.803542284602, -122.406533525994)
148756 148756 249948 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 305 Filbert St 3 Front Yard : Yard 7 Tree 1 Private 1     18 Width 0ft   6011338.9869 2120052.71472 37.8018992421182 -122.40492820376998 (37.8018992421182, -122.40492820377)
154615 154615 249823 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 285 Kearny St 2 Front Yard : Yard 7 Tree 1 Private 1     14 Width 0ft   6010881.14413 2120640.5408 37.8034876651725 -122.406554008974 (37.8034876651725, -122.406554008974)
159610 159610 249987 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 228 Filbert St 3 Front Yard : Yard 7 Tree 1 Private 1     3 Width 0ft   6011587.32256 2120104.99043 37.802056656736 -122.404072522227 (37.802056656736, -122.404072522227)
183705 183705 249985 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 228 Filbert St 1 Front Yard : Yard 7 Tree 1 Private 1     4 Width 0ft   6011591.62105 2120106.88257 37.802062092258 -122.40405778055799 (37.802062092258, -122.404057780558)
183937 183937 249822 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 285 Kearny St 1 Front Yard : Yard 7 Tree 1 Private 1     10 Width 0ft   6010893.58143 2120633.6568400003 37.8034694593133 -122.406510483572 (37.8034694593133, -122.406510483572)
184956 184956 249990 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 228 Filbert St 6 Front Yard : Yard 7 Tree 1 Private 1     2 Width 0ft   6011580.18498 2120103.15607 37.802051221233 -122.404097092619 (37.802051221233, -122.404097092619)

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