Street_Tree_List

Data source: data.sfgov.org

14 rows where qAddress = "109 Spear St" and qSpecies = 23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: DBH

qAddress ✖

  • 109 Spear St · 14 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
29088 29088 192187 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6014922.34565 2116076.94881 37.7911823693173 -122.3922497801 (37.7911823693173, -122.3922497801)
42677 42677 192180 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6014994.3077300005 2116006.28065 37.7909923263706 -122.39199584752599 (37.7909923263706, -122.391995847526)
48570 48570 192178 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6015027.5058699995 2115974.64571 37.7909073071818 -122.391878769291 (37.7909073071818, -122.391878769291)
52953 52953 192181 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6014979.691880001 2116018.41542 37.791024834186004 -122.39204726717199 (37.791024834186, -122.392047267172)
57698 57698 192179 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 4ft   6015008.84996 2115990.5046 37.7909498163315 -122.39194442791201 (37.7909498163315, -122.391944427912)
58397 58397 192183 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6014959.29976 2116038.8631 37.7910798466 -122.392119254319 (37.7910798466, -122.392119254319)
63927 63927 192185 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6014943.40955 2116055.80461 37.7911254818008 -122.392175419669 (37.7911254818008, -122.392175419669)
73412 73412 192184 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6014951.26578 2116048.5878 37.7911061023123 -122.392147732225 (37.7911061023123, -122.392147732225)
75233 75233 192182 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6014968.9428900005 2116029.5611400004 37.7910548409688 -122.392085238363 (37.7910548409688, -122.392085238363)
131044 131044 192186 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 4ft   6014933.05778 2116063.9824200002 37.7911473614027 -122.392211808925 (37.7911473614027, -122.392211808925)
162218 162218 192188 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6014909.81903 2116090.63513 37.7912192532274 -122.392294079819 (37.7912192532274, -122.392294079819)
164125 164125 192176 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6015058.68394 2115944.87304 37.7908272891018 -122.39176881099701 (37.7908272891018, -122.391768810997)
170321 170321 192189 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6014899.53632 2116102.22671 37.7912505100498 -122.392330469077 (37.7912505100498, -122.392330469077)
176005 176005 192177 Undocumented 2 Fraxinus americana :: American Ash 23 109 Spear St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6015044.75368 2115956.99358 37.790859796004206 -122.39181785730499 (37.7908597960042, -122.391817857305)

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