Street_Tree_List

Data source: data.sfgov.org

12 rows where DBH = 12 and qSpecies = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize, XCoord, YCoord, Latitude, Longitude, Location

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
73920 73920 207210 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 146 Staples Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     5999095.98576 2093806.86087 37.7291427575169 -122.445406326639 (37.7291427575169, -122.445406326639)
88236 88236 4991 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 8 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
94015 94015 4992 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 9 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
95563 95563 4998 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 15 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
97805 97805 4994 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 11 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
99734 99734 4993 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 10 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
110729 110729 4995 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 12 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
143370 143370 5001 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 18 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
173676 173676 207279 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 186 Merced Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5994221.53046 2099188.36085 37.743639556416504 -122.462647812372 (37.7436395564165, -122.462647812372)
178613 178613 176988 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 184 Mount Vernon Ave 4 Side Yard : Yard 17 Tree 1 Private 1     12     5998975.21291 2089361.52774 37.7169300054919 -122.445504324886 (37.7169300054919, -122.445504324886)
181320 181320 129489 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2120 Jefferson St 1 Front Yard : Yard 7 Tree 1 Private 1     12     5999042.28702 2121160.24008 37.80424517403429 -122.44756015169901 (37.8042451740343, -122.447560151699)
182650 182650 207192 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 212 Hearst Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     5999965.474330001 2094393.0504400001 37.730801895176896 -122.442442510114 (37.7308018951769, -122.442442510114)

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