Street_Tree_List

Data source: data.sfgov.org

22 rows where DBH = 2 and qSpecies = 147

✎ View and edit SQL

This data as json, CSV (advanced)

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

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
15294 15294 94619 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1799X Armstrong Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   10/13/2010 12:00:00 AM 2   Permit Number 53777 6013459.79784 2093130.5142700002 37.7280951570487 -122.39570171627199 (37.7280951570487, -122.395701716272)
16217 16217 22383 Private 5 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 1799X Armstrong Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/13/1997 12:00:00 AM 2 4x15   6013476.602999999 2093118.78047 37.7280638732384 -122.39564279807301 (37.7280638732384, -122.395642798073)
30621 30621 249356 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 625 Leavenworth St 2 : 4 Tree 1 Private 1     2 Width 3ft   6008325.07213 2114654.93665 37.7869093422284 -122.414975526796 (37.7869093422284, -122.414975526796)
33973 33973 239178 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 370 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006302.56864 2107899.15692 37.7682457495759 -122.421492964039 (37.7682457495759, -122.421492964039)
35375 35375 239209 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 14 Back Yard : Yard 13 Tree 1 Private 1     2     6005896.875990001 2108918.25042 37.7710210537973 -122.42296865708299 (37.7710210537973, -122.422968657083)
38350 38350 239199 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 27 Back Yard : Yard 13 Tree 1 Private 1     2     6005974.4493 2108807.19348 37.770720494984495 -122.422692434815 (37.7707204949845, -122.422692434815)
46968 46968 239180 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 370 14th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006264.72566 2107896.23328 37.7682355881421 -122.42162365172301 (37.7682355881421, -122.421623651723)
52540 52540 239181 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 380 14th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006215.6761300005 2107893.9456599997 37.7682265409602 -122.42179314696001 (37.7682265409602, -122.42179314696)
52804 52804 239179 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 370 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006290.70185 2107898.44552 37.768243127135705 -122.42153395963601 (37.7682431271357, -122.421533959636)
54547 54547 239225 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 3041 26th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6009370.46908 2100985.69041 37.7494354397039 -122.410393138328 (37.7494354397039, -122.410393138328)
76599 76599 114205 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 310 Carolina St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6012283.24048 2106396.5985 37.7644554605731 -122.40070071026399 (37.7644554605731, -122.400700710264)
101758 101758 116523 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 2486 FULTON ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   5995798.0 2110374.0 37.7744431335528 -122.458006125331 (37.7744431335528, -122.458006125331)
130200 130200 239200 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 26 Back Yard : Yard 13 Tree 1 Private 1     2     6005967.71166 2108818.2564 37.7707504909794 -122.422716526767 (37.7707504909794, -122.422716526767)
130504 130504 114204 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 310 Carolina St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6012281.598730001 2106430.0070700003 37.764547101481 -122.40070873583599 (37.764547101481, -122.400708735836)
131357 131357 239215 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 5 Back Yard : Yard 13 Tree 1 Private 1     2     6005849.76837 2108994.2700400003 37.77122712717 -122.423137008381 (37.77122712717, -122.423137008381)
131578 131578 114201 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 310 Carolina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6012278.4302 2106502.4698 37.7647458912325 -122.40072478603001 (37.7647458912325, -122.40072478603)
157838 157838 197037 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 176 Maddux Ave 1 : 4 Tree 1 Private 1     2 Width 3ft   6012326.10159 2094826.6531599998 37.732689273593294 -122.399740013104 (37.7326892735933, -122.399740013104)
158664 158664 239205 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 20 Back Yard : Yard 13 Tree 1 Private 1     2     6005934.94283 2108857.8407799997 37.7708573313359 -122.422832688574 (37.7708573313359, -122.422832688574)
160537 160537 95602 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 345 08th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/27/2012 12:00:00 AM 2 3x3 Permit Number 769429 5993373.11205 2113255.69639 37.782215873424605 -122.46660370840799 (37.7822158734246, -122.466603708408)
174547 174547 239220 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 2730 Bryant St 6 Front Yard : Yard 7 Tree 1 Private 1     2 Width 7ft   6009770.4944400005 2101313.01983 37.750356630576796 -122.409032927236 (37.7503566305768, -122.409032927236)
180826 180826 239202 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 24 Back Yard : Yard 13 Tree 1 Private 1     2     6005953.73874 2108834.81297 37.7707951629947 -122.422766036225 (37.7707951629947, -122.422766036225)
186175 186175 239207 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 18 Back Yard : Yard 13 Tree 1 Private 1     2     6005923.40296 2108870.98166 37.7708927619194 -122.422873539387 (37.7708927619194, -122.422873539387)

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