Street_Tree_List

Data source: data.sfgov.org

14 rows where PlotSize = "Width 0ft", SiteOrder = 2 and qSpecies = 42

✎ 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
24822 24822 250192 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 11 Alta St 2 Back Yard : Yard 13 Tree 1 Private 1     9 Width 0ft   6011786.88966 2119947.0785 37.8016342173021 -122.403370805543 (37.8016342173021, -122.403370805543)
35471 35471 140101 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 771 Central Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5999584.517999999 2111094.1746 37.7766373769699 -122.44495966716002 (37.7766373769699, -122.44495966716)
42577 42577 139655 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 848 BAKER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6000491.15 2111934.8144 37.7789972619427 -122.441883720544 (37.7789972619427, -122.441883720544)
45153 45153 140717 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 556 SCOTT ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6002162.097 2110427.6982 37.774954171002 -122.43599537996201 (37.774954171002, -122.435995379962)
54226 54226 137665 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1901 GOLDEN GATE AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6000382.7272 2111637.7254 37.778175352566 -122.44223746490101 (37.778175352566, -122.442237464901)
65658 65658 183506 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2542 27th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5988021.6131 2097993.9577 37.7400010259161 -122.483997786352 (37.7400010259161, -122.483997786352)
75611 75611 182146 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1690 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5989681.6149 2103872.2722 37.756237834999 -122.478688039412 (37.756237834999, -122.478688039412)
132605 132605 142261 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 575 LINDEN ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6004683.1776 2110693.6136 37.775827208405104 -122.427293365492 (37.7758272084051, -122.427293365492)
154005 154005 248396 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1655 Waller St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5997671.1383 2108143.749 37.768426881635605 -122.45136572862499 (37.7684268816356, -122.451365728625)
156262 156262 140103 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1720 FULTON ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5999438.9967 2110868.4473 37.776009281241 -122.44544683133002 (37.776009281241, -122.44544683133)
157543 157543 139098 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2600 POST ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5999639.9141 2113670.3506 37.7837140544374 -122.44495327295601 (37.7837140544374, -122.444953272956)
159913 159913 138338 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2250 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6001931.2408 2114335.4048 37.7856706283151 -122.437073793387 (37.7856706283151, -122.437073793387)
164961 164961 138533 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2299 SUTTER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6001645.5525 2114240.3384 37.7853933573613 -122.438055378776 (37.7853933573613, -122.438055378776)
173572 173572 245839 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 423 Laguna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6005015.8911 2110507.8578 37.775335978986796 -122.4261291969 (37.7753359789868, -122.4261291969)

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