Street_Tree_List

Data source: data.sfgov.org

32 rows where DBH = 4 and qSpecies = 147 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

DBH ✖

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
154686 154686 239219 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 2730 Bryant St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6009767.82555 2101370.89854 37.7505154031821 -122.409046239907 (37.7505154031821, -122.409046239907)
158471 158471 197028 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 2 Waterloo St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6010376.04785 2097256.74048 37.739252873912704 -122.40665305401801 (37.7392528739127, -122.406653054018)
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)
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)
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)
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)
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)
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)
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)
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)
158469 158469 197035 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1751 Armstrong Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6013551.1098 2093063.74117 37.7279168907351 -122.39538136964799 (37.7279168907351, -122.395381369648)
165840 165840 83748 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 235 Thornton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2008 12:00:00 AM 4 3x3 Permit Number 51439 6013723.72454 2094177.53037 37.730984728264204 -122.39486260383 (37.7309847282642, -122.39486260383)
132976 132976 197029 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1601 Kirkwood Ave 1 : 4 Tree 1 Private 1     4 Width 4ft   6015115.28126 2096786.0121099998 37.738224366070106 -122.390233889493 (37.7382243660701, -122.390233889493)
157689 157689 197030 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1601 Kirkwood Ave 2 : 4 Tree 1 Private 1     4 Width 4ft   6015124.98776 2096779.4659400003 37.7382069300149 -122.39019987173401 (37.7382069300149, -122.390199871734)

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