Street_Tree_List

Data source: data.sfgov.org

12 rows where qSiteInfo = 2 and qSpecies = 58

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 12 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
44937 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)
52605 52605 204713 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1484 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   5991184.777919999 2105315.94504 37.7602889411076 -122.473594943052 (37.7602889411076, -122.473594943052)
56499 56499 222681 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 2318 22nd St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6011232.98207 2103716.09635 37.7570367677534 -122.404144621787 (37.7570367677534, -122.404144621787)
63474 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 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)
115834 115834 246707 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1 Bonview St 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6007720.78655 2099148.69396 37.744298842209 -122.415967729029 (37.744298842209, -122.415967729029)
128258 128258 204719 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 110 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993903.71897 2099982.29966 37.7458012037543 -122.46380433331001 (37.7458012037543, -122.46380433331)
129702 129702 204734 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 80 Merced Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994953.56479 2099867.13318 37.7455454275919 -122.460165799529 (37.7455454275919, -122.460165799529)
130324 130324 123045 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 568 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991929.81513 2111594.03006 37.777569997766705 -122.47147570428301 (37.7775699977667, -122.471475704283)
171726 171726 204714 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1484 16th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   5991182.79274 2105342.1880099997 37.7603608823676 -122.473603723127 (37.7603608823676, -122.473603723127)
178842 178842 204733 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 80 Merced Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994927.12974 2099849.55804 37.745495650106605 -122.460255934077 (37.7454956501066, -122.460255934077)
179565 179565 222694 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 427 Valley St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6003122.71421 2099186.4838799997 37.7441430185014 -122.431869572034 (37.7441430185014, -122.431869572034)

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