Street_Tree_List

Data source: data.sfgov.org

15 rows where qSiteInfo = 2 and qSpecies = 31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 15 ✖

qCaretaker ✖

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)
33234 33234 215420 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2085 09th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5993528.81827 2101394.66819 37.7496575974161 -122.46520324492799 (37.7496575974161, -122.465203244928)
37345 37345 197979 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 21 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6012714.266419999 2104668.82572 37.759735409279706 -122.39908861614599 (37.7597354092797, -122.399088616146)
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)
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)
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)
56645 56645 247209 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 800 Duboce Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6001860.515269999 2108286.6653 37.7690582897368 -122.436885307832 (37.7690582897368, -122.436885307832)
65216 65216 136751 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1142 Filbert St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   6007453.51921 2119553.70533 37.8003111329029 -122.41833837521999 (37.8003111329029, -122.41833837522)
70744 70744 179963 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 85 South Hill Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6002963.44574 2087110.53022 37.7109761365014 -122.431558338255 (37.7109761365014, -122.431558338255)
72724 72724 247212 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 800 Duboce Ave 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6001824.5154099995 2108284.91798 37.7690514458872 -122.437009703838 (37.7690514458872, -122.437009703838)
148653 148653 215421 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2085 09th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5993516.19097 2101401.9668400004 37.74967690946279 -122.46524744032101 (37.7496769094628, -122.465247440321)
153492 153492 136750 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1124 Filbert St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 5ft   6007528.1043 2119564.5184299997 37.8003450211571 -122.41808104771299 (37.8003450211571, -122.418081047713)
160717 160717 197991 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 3419 Jennings St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6013294.96544 2089742.68292 37.7187836844998 -122.396034235213 (37.7187836844998, -122.396034235213)
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)
187402 187402 179964 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 85 South Hill Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6002952.82685 2087126.8782400002 37.7110204227269 -122.431596206017 (37.7110204227269, -122.431596206017)

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