Street_Tree_List

Data source: data.sfgov.org

8 rows where PlotSize = "Width 8ft", qCaretaker = 1 and qSpecies = 58

View and edit SQL

Suggested facets: qAddress, qSiteInfo, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2939 203654 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 42 Mangels Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 8ft   6001070.39767 2095226.13763 37.7331522778487 -122.438682294452 (37.7331522778487, -122.438682294452)
3005 208852 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 42 Mangels Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1   08/14/2017 12:00:00 AM 3 Width 8ft   6001113.97001 2095223.0116299998 37.733146173254205 -122.43853142959101 (37.7331461732542, -122.438531429591)
44937 222679 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 749 Dolores St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 8ft   6005046.9751 2104064.76222 37.7576465368663 -122.425563014118 (37.7576465368663, -122.425563014118)
61378 204745 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 370 Monterey Blvd 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   5999685.08818 2094723.93815 37.731694449820296 -122.44343560538799 (37.7316944498203, -122.443435605388)
63474 175799 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1500 San Jose Ave 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   6001536.44317 2094235.33238 37.7304582561421 -122.43700014314 (37.7304582561421, -122.43700014314)
69867 222678 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 749 Dolores St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   6005045.75661 2104048.66592 37.7576022713581 -122.425566082603 (37.7576022713581, -122.425566082603)
136961 205922 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 370 Monterey Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   5999640.50046 2094726.6696 37.7316994068856 -122.443589949734 (37.7316994068856, -122.443589949734)
159639 188416 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1790 McKinnon Ave 1 : 4 Tree 1 Private 1     20 Width 8ft   6014390.68688 2096696.7168 37.7379389617097 -122.392732952571 (37.7379389617097, -122.392732952571)

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