Street_Tree_List

Data source: data.sfgov.org

15 rows where PlotSize = "Width 0ft" and qSpecies = 31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH

PlotSize ✖

  • Width 0ft · 15 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
28815 28815 182351 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1501 35th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5985257.4301 2104935.3862 37.758898980602005 -122.49406651392 (37.758898980602, -122.49406651392)
41866 41866 181367 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4019 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5982046.1498 2105540.3564 37.76037163028771 -122.505217265817 (37.7603716302877, -122.505217265817)
42196 42196 183595 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2639 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5989548.2713 2097387.6993 37.7384251583472 -122.478674965089 (37.7384251583472, -122.478674965089)
42264 42264 246217 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 725 Buena Vista Ave West 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5999828.0384 2107849.3991 37.7677419398126 -122.443884078726 (37.7677419398126, -122.443884078726)
46627 46627 182665 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2618 Ortega St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 0ft   5985884.1902 2102331.3321 37.7517856167847 -122.491707219971 (37.7517856167847, -122.491707219971)
48830 48830 215419 DPW Maintained 3 Trachycarpus fortunei :: Windmill Palm 31 1x Minerva St 36 Median : Cutout 11 Tree 1 DPW 2     10 Width 0ft   5996348.606369999 2088999.95907 37.7157869222005 -122.454557070559 (37.7157869222005, -122.454557070559)
55615 55615 182655 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2618 Ortega St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5985877.3992 2102330.3619999997 37.7517825562574 -122.49173063243201 (37.7517825562574, -122.491730632432)
57252 57252 199656 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1395 Donner Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6015030.8215 2090912.727 37.7220928214053 -122.39011571883199 (37.7220928214053, -122.390115718832)
130541 130541 199802 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1350 Donner Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6015069.8022 2090954.144 37.7222087062567 -122.389983862743 (37.7222087062567, -122.389983862743)
136649 136649 141332 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1324 HAYES ST 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 0ft   6001489.2623 2110460.5875 37.7750062304087 -122.43832521117099 (37.7750062304087, -122.438325211171)
158454 158454 250756 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2900 Lake St 1 : 4 Tree 1 Private 1     6 Width 0ft   5986048.1037 2114785.2005 37.7859900201618 -122.492057248563 (37.7859900201618, -122.492057248563)
162786 162786 143059 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 440 GREENWICH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6010738.656 2120349.8129 37.8026814253217 -122.40702659346701 (37.8026814253217, -122.407026593467)
178635 178635 182656 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2618 Ortega St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 0ft   5985872.0635 2102330.847 37.7517835760889 -122.491749119446 (37.7517835760889, -122.491749119446)
186537 186537 182441 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1529 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5985572.6922 2104787.172 37.7585104674539 -122.492965288536 (37.7585104674539, -122.492965288536)
188528 188528 246216 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 725 Buena Vista Ave West 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5999835.3063 2107870.2944 37.7677997276311 -122.443860441452 (37.7677997276311, -122.443860441452)

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