Street_Tree_List

Data source: data.sfgov.org

20 rows where DBH = 7, SiteOrder = 2 and qSpecies = 82

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
26220 26220 136266 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 220 Joice St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010225.4664 2116932.79358 37.793270394575295 -122.40856131286101 (37.7932703945753, -122.408561312861)
35715 35715 139272 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 765 FULTON ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6004185.2644 2111476.3212 37.7779481591061 -122.429071593475 (37.7779481591061, -122.429071593475)
38038 38038 136216 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 3330 Clay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5998869.71206 2115631.48922 37.7890548395604 -122.447759099698 (37.7890548395604, -122.447759099698)
44172 44172 247564 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 316 Alemany Blvd 2 : 4 Tree 1 Private 1     7 Width 4ft   6008777.64172 2095456.26862 37.7342196103425 -122.412052440585 (37.7342196103425, -122.412052440585)
46583 46583 246509 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 241 Duncan St 2 : 4 Tree 1 Private 1     7 Width 6ft   6004948.2324 2099866.59265 37.7461137586439 -122.425605722044 (37.7461137586439, -122.425605722044)
50287 50287 136198 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 2101 Beach St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6000083.32441 2120905.42804 37.803604967353394 -122.443939252695 (37.8036049673534, -122.443939252695)
64389 64389 197077 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1101 23rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6014934.55258 2102947.77391 37.7551332492083 -122.391289372524 (37.7551332492083, -122.391289372524)
74587 74587 182789 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1785 26th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5988112.4655 2103151.9819 37.7541688787672 -122.484061810783 (37.7541688787672, -122.484061810783)
81776 81776 114391 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 82 23x PINTO AVE 2 Front Yard : Yard 7 Tree 1 Private 1     7     5988521.0 2090808.0 37.720299292258794 -122.481744923362 (37.7202992922588, -122.481744923362)
126901 126901 239312 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 476 Fair Oaks St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6005497.718090001 2100914.6151 37.7490224215445 -122.423780174714 (37.7490224215445, -122.423780174714)
130355 130355 136251 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 2711 Hyde St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006870.92139 2121576.32062 37.8058319081714 -122.420498048543 (37.8058319081714, -122.420498048543)
132492 132492 138547 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1640 SCOTT ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6001637.8568 2114160.6327 37.785174068245894 -122.438076291996 (37.7851740682459, -122.438076291996)
149008 149008 120775 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 57 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5989253.50277 2114844.1258799997 37.7863386601165 -122.48097188408 (37.7863386601165, -122.48097188408)
150726 150726 239269 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 27 Woodward St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6006491.50571 2108328.68595 37.7694357855487 -122.420869947001 (37.7694357855487, -122.420869947001)
157966 157966 136202 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1337 Francisco St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6004913.0684 2120534.02336 37.8028595013299 -122.427199210075 (37.8028595013299, -122.427199210075)
171035 171035 179335 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1119 Athens St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6001959.57443 2087726.76645 37.7126112352992 -122.435071996701 (37.7126112352992, -122.435071996701)
173762 173762 124412 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 3900 Clay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5996120.28006 2115251.26489 37.787853319856794 -122.45724420279 (37.7878533198568, -122.45724420279)
173991 173991 179297 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 326 Peru Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6004358.252069999 2093034.47753 37.7273209621682 -122.427159238819 (37.7273209621682, -122.427159238819)
182525 182525 179291 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 65 Badger St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6002393.53271 2094418.30005 37.731009322903 -122.434050139316 (37.731009322903, -122.434050139316)
185144 185144 239317 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1100 Hampshire St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 6ft   6010240.72628 2102744.15996 37.7543125548829 -122.407507713025 (37.7543125548829, -122.407507713025)

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