Street_Tree_List

Data source: data.sfgov.org

10 rows where DBH = 2 and qSpecies = 84

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
50088 50088 1497 DPW Maintained 3 Prunus spp :: Cherry 84 325 Arguello Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3x3   5995534.5488977 2114067.6155393003 37.7845696798314 -122.45918496626999 (37.7845696798314, -122.45918496627)
63837 63837 234919 Undocumented 2 Prunus spp :: Cherry 84 200 Saint Marys Ave 5 Side Yard : Yard 17 Tree 1 Private 1     2 Width 4ft   6003932.02563 2095971.19882 37.735360426449105 -122.428841975603 (37.7353604264491, -122.428841975603)
82823 82823 104765 Undocumented 2 Prunus spp :: Cherry 84 47 VICKSBURG ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 4x4   6004132.1 2102787.4 37.754087465401604 -122.428635972714 (37.7540874654016, -122.428635972714)
116443 116443 213700 Undocumented 2 Prunus spp :: Cherry 84 1316 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5993037.4807 2106453.44522 37.76351933917171 -122.46727007765499 (37.7635193391717, -122.467270077655)
137994 137994 196067 Undocumented 2 Prunus spp :: Cherry 84 2338 Lane St 2 Front Yard : Yard 7 Tree 1 Private 1     2 Width 5ft   6013920.54146 2092873.2671400001 37.727414427818395 -122.394090896496 (37.7274144278184, -122.394090896496)
140754 140754 53304 Permitted Site 1 Prunus spp :: Cherry 84 47 Vicksburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/21/1969 12:00:00 AM 2 4x4 Permit Number 6194 6004117.25840717 2102785.08371789 37.7540802654829 -122.42868713344 (37.7540802654829, -122.42868713344)
147685 147685 196064 Undocumented 2 Prunus spp :: Cherry 84 1800 Illinois St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   6016257.27394 2100629.7145700003 37.7488416623195 -122.386553348372 (37.7488416623195, -122.386553348372)
162408 162408 213702 Undocumented 2 Prunus spp :: Cherry 84 714 Detroit St 6 Side Yard : Yard 17 Tree 1 Private 1     2     5999450.30082 2095402.17977 37.7335433498509 -122.444296031758 (37.7335433498509, -122.444296031758)
181165 181165 185048 Undocumented 2 Prunus spp :: Cherry 84 2767 34th Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985831.6836 2096605.638 37.7360613326903 -122.49146739069799 (37.7360613326903, -122.491467390698)
183108 183108 213705 Undocumented 2 Prunus spp :: Cherry 84 175 Staples Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     5998918.04752 2093764.63915 37.7290166671659 -122.4460184358 (37.7290166671659, -122.4460184358)

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