Street_Tree_List

Data source: data.sfgov.org

20 rows where PlotSize = "Width 0ft" and qSpecies = 66

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

PlotSize ✖

  • Width 0ft · 20 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
3387 3387 161273 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 566 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   0 Width 0ft   6002889.180369999 2090346.5289900003 37.719857269085104 -122.432045948864 (37.7198572690851, -122.432045948864)
25343 25343 183040 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2562 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5989885.4338 2097934.2198 37.739945333152 -122.477549168466 (37.739945333152, -122.477549168466)
29530 29530 218122 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 45 Lopez Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5994032.10421 2100668.86964 37.7476937487685 -122.463410213512 (37.7476937487685, -122.463410213512)
36442 36442 200076 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1500 Van Dyke Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6014887.9102 2093187.7857 37.728331752097795 -122.390768643797 (37.7283317520978, -122.390768643797)
42406 42406 182596 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 945 Rivera St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   5990197.9307 2100380.5725 37.746680511997496 -122.47664737488998 (37.7466805119975, -122.47664737489)
42780 42780 200073 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1500 Van Dyke Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6014933.989 2093151.8218 37.7282355589188 -122.390606833955 (37.7282355589188, -122.390606833955)
44510 44510 218322 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 420 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5993190.15092 2099959.3697 37.745697098249394 -122.466270063011 (37.7456970982494, -122.466270063011)
47365 47365 141302 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 208 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5998449.1975 2112684.3341 37.780938681749895 -122.449001631605 (37.7809386817499, -122.449001631605)
55179 55179 184366 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2295 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5987606.9921 2099709.6419 37.7446876937291 -122.485557233352 (37.7446876937291, -122.485557233352)
57958 57958 183317 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1209 41st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5983329.0993 2106834.4338 37.7640002060456 -122.50087591440399 (37.7640002060456, -122.500875914404)
116485 116485 200075 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1500 Van Dyke Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6014900.2728 2093175.985 37.7283000356482 -122.390725081061 (37.7283000356482, -122.390725081061)
130438 130438 244873 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 49 Lyon St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6000342.3248 2109115.5777 37.7712478709156 -122.442196132801 (37.7712478709156, -122.442196132801)
136007 136007 143086 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 459 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6010641.4481 2120294.7479 37.8025247902186 -122.407359099343 (37.8025247902186, -122.407359099343)
137011 137011 137657 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2167 TURK BLVD 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5999659.4785 2111881.8514 37.778804413574704 -122.444756988886 (37.7788044135747, -122.444756988886)
137065 137065 182595 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 955 Rivera St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   5990177.9035 2100379.6188 37.746676731738894 -122.4767165565 (37.7466767317389, -122.4767165565)
151744 151744 218121 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 45 Lopez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5994024.91011 2100655.57636 37.7476568343048 -122.463434125583 (37.7476568343048, -122.463434125583)
161050 161050 199671 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1905 Keith St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6015210.0019 2093419.3228 37.728985371993396 -122.389671313679 (37.7289853719934, -122.389671313679)
170640 170640 137632 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2175 TURK BLVD 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5999619.2063 2111878.8056 37.7787937523144 -122.44489608677401 (37.7787937523144, -122.444896086774)
173302 173302 183679 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 3627 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5984438.7811 2106305.4338 37.7626128114068 -122.49699886391899 (37.7626128114068, -122.496998863919)
175342 175342 200074 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1500 Van Dyke Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6014921.0644 2093162.4986 37.728264158228896 -122.39065226097 (37.7282641582289, -122.39065226097)

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