Street_Tree_List

Data source: data.sfgov.org

30 rows where qSiteInfo = 13 and qSpecies = 147

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Back Yard : Yard · 16 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
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)
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)
133557 133557 239195 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 7 Back Yard : Yard 13 Tree 1 Private 1     3     6005938.2626 2109031.33623 37.77133389557179 -122.422833537536 (37.7713338955718, -122.422833537536)
133851 133851 239201 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 25 Back Yard : Yard 13 Tree 1 Private 1     3     6005958.49088 2108828.3343599997 37.7707776424043 -122.422749137971 (37.7707776424043, -122.422749137971)
149080 149080 239213 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 8 Back Yard : Yard 13 Tree 1 Private 1     5     6005865.35862 2108965.54677 37.771149139741 -122.423081039068 (37.771149139741, -122.423081039068)
152126 152126 239212 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 9 Back Yard : Yard 13 Tree 1 Private 1     6     6005873.5433 2108954.58543 37.7711195043932 -122.42305194869301 (37.7711195043932, -122.423051948693)
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)
160902 160902 239191 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 3 Back Yard : Yard 13 Tree 1 Private 1     6     6005967.76325 2108980.83852 37.7711969054453 -122.422727904078 (37.7711969054453, -122.422727904078)
163838 163838 239218 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 1 Back Yard : Yard 13 Tree 1 Private 1     3 Width 10ft   6005833.18575 2109028.0269 37.771318879598105 -122.423196768328 (37.7713188795981, -122.423196768328)
166869 166869 239197 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 9 Back Yard : Yard 13 Tree 1 Private 1     4     6005924.85036 2109052.04357 37.7713899961886 -122.42288140308001 (37.7713899961886, -122.42288140308)
168811 168811 239193 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 5 Back Yard : Yard 13 Tree 1 Private 1     5     6005953.87409 2109001.5556400004 37.771253006051296 -122.42277741983801 (37.7712530060513, -122.422777419838)
170487 170487 239210 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 13 Back Yard : Yard 13 Tree 1 Private 1     3     6005891.00584 2108925.69957 37.771041176138795 -122.422989491673 (37.7710411761388, -122.422989491673)
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)
183663 183663 239206 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 19 Back Yard : Yard 13 Tree 1 Private 1     3     6005929.117819999 2108865.00797 37.7708766820544 -122.42285334689899 (37.7708766820544, -122.422853346899)
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)
187735 187735 239190 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 101 Hwy 101 Northbound 2 Back Yard : Yard 13 Tree 1 Private 1     4     6005977.0875 2108970.19311 37.7711682017725 -122.422694894458 (37.7711682017725, -122.422694894458)

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