Street_Tree_List

Data source: data.sfgov.org

21 rows where PlotSize = "Width 6ft" and qSpecies = 68

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH

PlotSize ✖

  • Width 6ft · 21 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
31199 31199 176506 Undocumented 2 Geijera parviflora :: Australian Willow 68 178 Brookdale Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6005608.52394 2087094.5334400001 37.7110817807597 -122.42241517113001 (37.7110817807597, -122.42241517113)
43000 43000 176515 Undocumented 2 Geijera parviflora :: Australian Willow 68 154 Brookdale Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   6006304.71292 2087396.6514 37.7119505816242 -122.420030394781 (37.7119505816242, -122.420030394781)
43767 43767 176500 Undocumented 2 Geijera parviflora :: Australian Willow 68 162 Brookdale Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6005731.33862 2087429.69303 37.712008985404 -122.422014487205 (37.712008985404, -122.422014487205)
43922 43922 176514 Undocumented 2 Geijera parviflora :: Australian Willow 68 154 Brookdale Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   6006291.2518 2087400.97553 37.7119616963423 -122.420077226985 (37.7119616963423, -122.420077226985)
58127 58127 176510 Undocumented 2 Geijera parviflora :: Australian Willow 68 2 Brookdale Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6006143.81597 2087479.5619400002 37.7121691699409 -122.420592382928 (37.7121691699409, -122.420592382928)
59507 59507 176502 Undocumented 2 Geijera parviflora :: Australian Willow 68 170 Brookdale Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6005669.88649 2087297.20509 37.7116417355373 -122.42221747678002 (37.7116417355373, -122.42221747678)
69064 69064 176509 Undocumented 2 Geijera parviflora :: Australian Willow 68 127 Brookdale Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6006088.90588 2087444.93251 37.7120709900614 -122.420779711712 (37.7120709900614, -122.420779711712)
72097 72097 176499 Undocumented 2 Geijera parviflora :: Australian Willow 68 162 Brookdale Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   6005745.58119 2087451.7768599999 37.7120704261874 -122.421966828522 (37.7120704261874, -122.421966828522)
73386 73386 176503 Undocumented 2 Geijera parviflora :: Australian Willow 68 170 Brookdale Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6005661.68615 2087270.92863 37.711569123398796 -122.422243953714 (37.7115691233988, -122.422243953714)
131668 131668 176513 Undocumented 2 Geijera parviflora :: Australian Willow 68 154 Brookdale Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6006276.40846 2087403.9786200002 37.7119691058641 -122.42012874286199 (37.7119691058641, -122.420128742862)
151401 151401 176516 Undocumented 2 Geijera parviflora :: Australian Willow 68 49 Brookdale Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6006459.4617 2087377.28485 37.7119061227438 -122.419494165041 (37.7119061227438, -122.419494165041)
152426 152426 176517 Undocumented 2 Geijera parviflora :: Australian Willow 68 49 Brookdale Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6006489.3282699995 2087380.0454 37.7119153848503 -122.419391133293 (37.7119153848503, -122.419391133293)
152999 152999 176497 Undocumented 2 Geijera parviflora :: Australian Willow 68 2 Brookdale Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 6ft   6005989.52225 2087517.96508 37.7122659199214 -122.421128393261 (37.7122659199214, -122.421128393261)
158771 158771 176498 Undocumented 2 Geijera parviflora :: Australian Willow 68 144 Brookdale Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 6ft   6005795.48549 2087494.48765 37.7121905153633 -122.42179737647498 (37.7121905153633, -122.421797376475)
161897 161897 176501 Undocumented 2 Geijera parviflora :: Australian Willow 68 170 Brookdale Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6005674.86736 2087315.91925 37.7116934016018 -122.42220159024599 (37.7116934016018, -122.422201590246)
169474 169474 176504 Undocumented 2 Geijera parviflora :: Australian Willow 68 178 Brookdale Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 6ft   6005618.83947 2087124.32667 37.711164168567 -122.422381633625 (37.711164168567, -122.422381633625)
177304 177304 176507 Undocumented 2 Geijera parviflora :: Australian Willow 68 150 Brookdale Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     45 Width 6ft   6005719.71054 2087314.8851 37.7116930913392 -122.422046526423 (37.7116930913392, -122.422046526423)
179065 179065 176512 Undocumented 2 Geijera parviflora :: Australian Willow 68 154 Brookdale Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6006244.01324 2087410.04073 37.711983925792 -122.42024114011801 (37.711983925792, -122.420241140118)
181038 181038 176508 Undocumented 2 Geijera parviflora :: Australian Willow 68 150 Brookdale Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     50 Width 6ft   6005731.293880001 2087351.0784200002 37.71179312382829 -122.422009060692 (37.7117931238283, -122.422009060692)
186907 186907 176505 Undocumented 2 Geijera parviflora :: Australian Willow 68 178 Brookdale Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6005616.04698 2087112.6870400002 37.7111320510829 -122.42239045867599 (37.7111320510829, -122.422390458676)
187028 187028 176511 Undocumented 2 Geijera parviflora :: Australian Willow 68 127 Brookdale Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6006104.31545 2087436.5206900002 37.712048761508605 -122.42072585491199 (37.7120487615086, -122.420725854912)

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