Street_Tree_List

Data source: data.sfgov.org

12 rows where DBH = 2 and qSpecies = 72

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
36891 36891 135862 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 8 Kimball Pl 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6008000.712730001 2116486.83875 37.791921065252204 -122.416227532369 (37.7919210652522, -122.416227532369)
42697 42697 214340 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 10 Granada Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5995647.3178900005 2089997.48145 37.7184856365862 -122.457053144299 (37.7184856365862, -122.457053144299)
57629 57629 214334 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 470 Hearst Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 10ft   5998312.15542 2094413.4318799998 37.7307634815435 -122.448159739578 (37.7307634815435, -122.448159739578)
64453 64453 214316 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1898 08th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5993790.06824 2102612.96107 37.7530177802481 -122.464388282898 (37.7530177802481, -122.464388282898)
69505 69505 196330 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 582 Rhode Island St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6011759.958869999 2105639.7656 37.7623481673595 -122.40245738661801 (37.7623481673595, -122.402457386618)
147556 147556 214315 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1643 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5993376.02878 2104293.90166 37.7576093337224 -122.465942230469 (37.7576093337224, -122.465942230469)
154507 154507 237885 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 730 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5997985.449030001 2107861.4098900002 37.767669642974894 -122.450258206855 (37.7676696429749, -122.450258206855)
155852 155852 237881 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 400 Prospect Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6006228.09651 2097633.90585 37.7400555395259 -122.42102161048 (37.7400555395259, -122.42102161048)
164953 164953 196331 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 801 Arkansas St 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6013062.01072 2103694.01523 37.757078165347096 -122.397817553962 (37.7570781653471, -122.397817553962)
169509 169509 196332 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 801 Arkansas St 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6013061.70024 2103702.02862 37.7571001510787 -122.39781918981001 (37.7571001510787, -122.39781918981)
171405 171405 183467 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2534 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5988330.845 2098043.4689 37.740154968776395 -122.482932230746 (37.7401549687764, -122.482932230746)
174532 174532 214331 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 13 Median : Yard 3 Tree 1 DPW 2     2 Width 9ft   5995540.56521 2099364.9270200003 37.7442002405496 -122.458099716827 (37.7442002405496, -122.458099716827)

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