Street_Tree_List

Data source: data.sfgov.org

22 rows where PlotSize = "Width 2ft", SiteOrder = 1 and qSpecies = 45

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qSiteInfo, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24847 24847 214027 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 130 Baden St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6000768.47308 2094513.82924 37.7311792633149 -122.439675077667 (37.7311792633149, -122.439675077667)
25257 25257 240410 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 235 Surrey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6001912.29637 2096185.45895 37.735834211766 -122.43584024433599 (37.735834211766, -122.435840244336)
28437 28437 240376 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1367 Natoma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6007185.77161 2107529.7326700003 37.76728115653079 -122.41841184713499 (37.7672811565308, -122.418411847135)
31386 31386 214044 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 119 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5999274.87025 2093768.2240099998 37.729046879900295 -122.444785134325 (37.7290468799003, -122.444785134325)
31525 31525 214031 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 119 Gennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5997420.89454 2093944.4368 37.7294247417474 -122.45120714359501 (37.7294247417474, -122.451207143595)
33363 33363 240383 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 65 Hermann St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6004954.4402 2108809.15318 37.770668274943205 -122.426220805247 (37.7706682749432, -122.426220805247)
33748 33748 214024 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 118 Baden St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6000768.15588 2094464.1173900003 37.7310427480136 -122.43967261170201 (37.7310427480136, -122.439672611702)
50859 50859 240415 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 751 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6003800.46059 2107711.4253 37.7675888874331 -122.43013411340901 (37.7675888874331, -122.430134113409)
73938 73938 240417 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 150 Conrad St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6001765.76464 2096530.8335799999 37.736774205667295 -122.436371571893 (37.7367742056673, -122.436371571893)
74383 74383 240409 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1 Arbor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6002196.797259999 2096967.0919299999 37.7379965524899 -122.434912495609 (37.7379965524899, -122.434912495609)
76501 76501 240390 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 48 Santa Marina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6005917.96775 2097681.76661 37.740169467433894 -122.42209730935801 (37.7401694674339, -122.422097309358)
129970 129970 214013 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1483 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5992099.86454 2105356.08672 37.760452112299795 -122.47043304005899 (37.7604521122998, -122.470433040059)
134645 134645 214022 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 659 Hearst Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5997050.53703 2094389.3323099997 37.7306251064676 -122.45251959171101 (37.7306251064676, -122.452519591711)
134723 134723 214040 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 111 Flood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5999932.25708 2094051.5429 37.729862301496 -122.442532837136 (37.729862301496, -122.442532837136)
137888 137888 214039 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 57 Nordhoff St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 2ft   6000414.26094 2095519.5651200002 37.7339206127394 -122.440971772322 (37.7339206127394, -122.440971772322)
142203 142203 197348 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 776 Tehama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6009001.8467 2110254.60923 37.7748650979682 -122.412322898178 (37.7748650979682, -122.412322898178)
157900 157900 240389 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 457 Nevada St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6008913.61949 2096192.37009 37.7362484143157 -122.41163431247601 (37.7362484143157, -122.411634312476)
159513 159513 214043 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 212 Edna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   5998768.52981 2093586.90837 37.7285201208974 -122.446522546303 (37.7285201208974, -122.446522546303)
162778 162778 179375 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 778 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6001912.74857 2089301.2462099998 37.7169317492882 -122.435346396016 (37.7169317492882, -122.435346396016)
166318 166318 136303 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1110 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6008623.1195 2116351.39928 37.7915841594399 -122.414064409258 (37.7915841594399, -122.414064409258)
171501 171501 214019 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 112 Dorado Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5994645.417119999 2093146.00663 37.7270731423102 -122.460744326189 (37.7270731423102, -122.460744326189)
185216 185216 214045 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 115 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5999297.76132 2093768.33781 37.7290484986852 -122.444706006572 (37.7290484986852, -122.444706006572)

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