Street_Tree_List

Data source: data.sfgov.org

24 rows where PlotSize = "Width 8ft" and qSiteInfo = 4

✎ 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
23483 23483 234406 Undocumented 2 Phoenix dactylifera :: Date Palm 65 147 Valencia St 1 : 4 Tree 1 Private 1     20 Width 8ft   6006058.10348 2108951.831 37.7711223543454 -122.422413351811 (37.7711223543454, -122.422413351811)
30416 30416 200396 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1002 Harrison St 2 : 4 Tree 1 Private 1     2 Width 8ft   6011347.2117 2110977.9345299997 37.776982513081606 -122.404260664891 (37.7769825130816, -122.404260664891)
31686 31686 189484 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 10 Garlington Ct 1 : 4 Tree 1 Private 1     17 Width 8ft   6016756.63544 2094656.7103 37.732468633912795 -122.38441058228399 (37.7324686339128, -122.384410582284)
36355 36355 191048 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 508 Missouri St 4 : 4 Tree 1 Private 1     2 Width 8ft   6013509.22069 2104630.04045 37.759673181581796 -122.396336524335 (37.7596731815818, -122.396336524335)
42040 42040 189611 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1002 Harrison St 1 : 4 Tree 1 Private 1     26 Width 8ft   6011365.32335 2110994.5569 37.7770291662965 -122.40419918094 (37.7770291662965, -122.40419918094)
45422 45422 187710 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 1 : 4 Tree 1 Private 1     2 Width 8ft   6013683.2298 2086994.4586200002 37.7112591963142 -122.39449981823 (37.7112591963142, -122.39449981823)
50949 50949 229269 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 38 Dolores St 12 : 4 Tree 1 Private 1     7 Width 8ft   6004746.92065 2107892.75948 37.768140347222705 -122.426873344349 (37.7681403472227, -122.426873344349)
61325 61325 200397 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1002 Harrison St 3 : 4 Tree 1 Private 1     2 Width 8ft   6011329.81075 2110961.2977 37.7769358598445 -122.404319689205 (37.7769358598445, -122.404319689205)
62024 62024 126626 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 350 Washington St 1 : 4 Tree 1 Private 1     16 Width 8ft   6013909.986409999 2118052.46146 37.796550399249796 -122.39589102894399 (37.7965503992498, -122.395891028944)
64217 64217 234405 Undocumented 2 Phoenix dactylifera :: Date Palm 65 177 Valencia St 3 : 4 Tree 1 Private 1     22 Width 8ft   6006077.65974 2108680.63405 37.770378815562296 -122.422326434118 (37.7703788155623, -122.422326434118)
75970 75970 195765 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 700 King St 1 : 4 Tree 1 Private 1     8 Width 8ft   6014123.60367 2110545.34082 37.7759494573415 -122.39462589597 (37.7759494573415, -122.39462589597)
76315 76315 231913 Undocumented 2 Maytenus boaria :: Mayten 22 3977 22nd St 5 : 4 Tree 1 Private 1     1 Width 8ft   6001945.98692 2102924.95269 37.754341189313 -122.436205913185 (37.754341189313, -122.436205913185)
131298 131298 233253 Undocumented 2 Melaleuca quinquenervia :: Cajeput 50 3975 22nd St 5 : 4 Tree 1 Private 1     4 Width 8ft   6002008.6874400005 2102930.09723 37.7543588771711 -122.435989447265 (37.7543588771711, -122.435989447265)
133482 133482 232403 Undocumented 2 Myoporum laetum :: Myoporum 1 3977 22nd St 6 : 4 Tree 1 Private 1     6 Width 8ft   6001960.85303 2102925.1671599997 37.754342622815706 -122.43615451782301 (37.7543426228157, -122.436154517823)
149834 149834 246978 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 201 Noe St 4 : 4 Tree 1 Private 1     21 Width 8ft   6002919.18964 2107068.61942 37.765773946726604 -122.433136379546 (37.7657739467266, -122.433136379546)
151068 151068 246982 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 38 Clipper St 1 : 4 Tree 1 Private 1     18 Width 8ft   6004902.47134 2101076.4890799997 37.74943326963471 -122.425850064247 (37.7494332696347, -122.425850064247)
156272 156272 188733 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 1 : 4 Tree 1 Private 1     8 Width 8ft   6014289.08954 2086985.67825 37.7112687498269 -122.392405184751 (37.7112687498269, -122.392405184751)
159639 159639 188416 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1790 McKinnon Ave 1 : 4 Tree 1 Private 1     20 Width 8ft   6014390.68688 2096696.7168 37.7379389617097 -122.392732952571 (37.7379389617097, -122.392732952571)
161688 161688 191047 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 508 Missouri St 3 : 4 Tree 1 Private 1     5 Width 8ft   6013509.00195 2104632.60387 37.7596802080014 -122.396337460525 (37.7596802080014, -122.396337460525)
164439 164439 234404 Undocumented 2 Phoenix dactylifera :: Date Palm 65 100 Valencia St 3 : 4 Tree 1 Private 1     20 Width 8ft   6006014.35416 2108978.5943299998 37.771193371997796 -122.422566584574 (37.7711933719978, -122.422566584574)
166135 166135 233252 Undocumented 2 Melaleuca quinquenervia :: Cajeput 50 3975 22nd St 6 : 4 Tree 1 Private 1     6 Width 8ft   6002009.58481 2102922.7662 37.7543387988987 -122.43598581939501 (37.7543387988987, -122.435985819395)
168851 168851 194325 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 88 King St 1 : 4 Tree 1 Private 1     31 Width 8ft   6015700.5691599995 2111985.57661 37.779991570003205 -122.38927130734601 (37.7799915700032, -122.389271307346)
183564 183564 245599 Undocumented 2 Cordyline australis :: Dracena Palm 141 193 Saint Germain Ave 1 : 4 Tree 1 Private 1     16 Width 8ft   5997474.2586 2104104.13255 37.7573238430432 -122.451755267793 (37.7573238430432, -122.451755267793)
184825 184825 246977 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 201 Noe St 3 : 4 Tree 1 Private 1     27 Width 8ft   6002905.92105 2107067.14879 37.765769156055704 -122.433182167637 (37.7657691560557, -122.433182167637)

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