Street_Tree_List

Data source: data.sfgov.org

23 rows where PlotSize = "Width 6ft" and qSpecies = 31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

PlotSize ✖

  • Width 6ft · 23 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
28350 28350 215435 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 271 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   5999640.40097 2095213.2119999998 37.7330353327146 -122.443625232838 (37.7330353327146, -122.443625232838)
35762 35762 241219 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4130 Cesar Chavez St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   6003095.93223 2100399.3712299997 37.7474718059861 -122.432048772745 (37.7474718059861, -122.432048772745)
40655 40655 197995 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6014417.48937 2089293.51791 37.717612756412 -122.392122692435 (37.717612756412, -122.392122692435)
42049 42049 197980 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6012727.8948800005 2104659.33214 37.759710101458204 -122.399040815374 (37.7597101014582, -122.399040815374)
44751 44751 197981 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   6012726.35291 2104657.30852 37.759704459115795 -122.39904600628 (37.7597044591158, -122.39904600628)
49851 49851 197983 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1809 19th St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6012297.3164 2105130.82765 37.760980720296295 -122.400563103211 (37.7609807202963, -122.400563103211)
50962 50962 179971 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 160 Baltimore Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6002384.15556 2086207.4195700001 37.708463540423104 -122.43349600315001 (37.7084635404231, -122.43349600315)
59883 59883 179956 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 78 Sala Ter 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 6ft   5998852.5351599995 2088480.84158 37.7145048379104 -122.44586505733999 (37.7145048379104, -122.44586505734)
64095 64095 179955 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 78 Sala Ter 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 6ft   5998862.1125 2088471.1679599998 37.7144788232093 -122.445831259031 (37.7144788232093, -122.445831259031)
64723 64723 215414 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 423 Flood Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   5997954.5929 2094069.3346400002 37.7297982247933 -122.449371101191 (37.7297982247933, -122.449371101191)
66969 66969 241217 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4130 Cesar Chavez St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6003092.5802 2100398.11558 37.7474681682247 -122.432060274186 (37.7474681682247, -122.432060274186)
129978 129978 136740 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1920 Beach St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6000976.885419999 2121020.42839 37.8039716578185 -122.44085530385 (37.8039716578185, -122.44085530385)
135983 135983 241218 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4130 Cesar Chavez St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6003089.92025 2100398.1705 37.7474681682179 -122.43206947603399 (37.7474681682179, -122.432069476034)
151710 151710 197982 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6012729.113 2104654.63686 37.759697277132204 -122.39903627291001 (37.7596972771322, -122.39903627291)
158174 158174 241187 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 45 Hoff St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6006570.58835 2106391.73918 37.7641218444722 -122.420458896575 (37.7641218444722, -122.420458896575)
166118 166118 215413 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 423 Flood Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   5997941.5079 2094069.28168 37.7297973308762 -122.44941633348999 (37.7297973308762, -122.44941633349)
170469 170469 197997 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6014474.56871 2089262.00767 37.717529404523795 -122.391923191299 (37.7175294045238, -122.391923191299)
173562 173562 241186 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 45 Hoff St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6006573.70754 2106363.42565 37.764044277946205 -122.42044609832399 (37.7640442779462, -122.420446098324)
178127 178127 197992 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6014311.92 2089359.19845 37.717787240171795 -122.392492192366 (37.7177872401718, -122.392492192366)
178543 178543 197994 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6014370.9162 2089321.9827 37.717688329142604 -122.392285665748 (37.7176883291426, -122.392285665748)
182005 182005 197998 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6014511.88744 2089238.1825599999 37.717466057201705 -122.391792531525 (37.7174660572017, -122.391792531525)
182308 182308 197996 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6014434.42252 2089286.69966 37.7175949749992 -122.392063685205 (37.7175949749992, -122.392063685205)
184240 184240 197993 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 881 Jamestown Ave 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6014330.76175 2089346.27019 37.7177527880479 -122.392426160549 (37.7177527880479, -122.392426160549)

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