Street_Tree_List

Data source: data.sfgov.org

13 rows where PlotSize = "Width 2ft" and qSpecies = 147

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: DBH

PlotSize ✖

  • Width 2ft · 13 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25154 25154 239161 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010627.47447 2101300.53615 37.7503703227358 -122.406068536926 (37.7503703227358, -122.406068536926)
27616 27616 239170 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010748.55016 2100997.3935 37.749544730724296 -122.405628497759 (37.7495447307243, -122.405628497759)
33987 33987 239160 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010602.41193 2101365.81223 37.750548154678604 -122.40615980372601 (37.7505481546786, -122.406159803726)
38314 38314 239164 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6010663.94961 2101209.37133 37.75012204421029 -122.405935981386 (37.7501220442103, -122.405935981386)
43810 43810 239167 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6010693.269230001 2101137.12494 37.749925311216295 -122.405829503442 (37.7499253112163, -122.405829503442)
57531 57531 239159 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6010593.731000001 2101386.95157 37.750605713091105 -122.40619131239201 (37.7506057130911, -122.406191312392)
60926 60926 239169 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010720.159580001 2101068.9953099997 37.749739745990894 -122.40573171655399 (37.7497397459909, -122.405731716554)
61124 61124 239165 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6010673.4453300005 2101181.95766 37.7500473033606 -122.40590121358801 (37.7500473033606, -122.405901213588)
69456 69456 239163 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010654.95431 2101230.51738 37.75017960352871 -122.40596857728701 (37.7501796035287, -122.405968577287)
76455 76455 239162 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6010646.644669999 2101254.46555 37.7502448951922 -122.40599899954799 (37.7502448951922, -122.405998999548)
139273 139273 239168 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010702.848069999 2101113.77684 37.749861738144396 -122.40579473475 (37.7498617381444, -122.40579473475)
178965 178965 239171 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 20 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010775.13287 2100929.58266 37.7493600234457 -122.40553179815399 (37.7493600234457, -122.405531798154)
180815 180815 239166 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1400 Potrero Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010684.29962 2101159.52227 37.749986307743 -122.40586209846799 (37.749986307743, -122.405862098468)

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