Street_Tree_List

Data source: data.sfgov.org

34 rows where PlotSize = "Width 3ft" and qSpecies = 95

View and edit SQL

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
545 251322 Undocumented 2 Betula spp :: Birch 95 828 Foerster St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1       Width 3ft   5998302.82159 2096489.58159 37.7364635618398 -122.448341458403 (37.7364635618398, -122.448341458403)
24385 221202 Undocumented 2 Betula spp :: Birch 95 612 Douglass St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6001183.09453 2102793.98455 37.75393820848979 -122.438834798788 (37.7539382084898, -122.438834798788)
26457 205617 Undocumented 2 Betula spp :: Birch 95 828 Foerster St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5998289.5702599995 2096474.9505900003 37.7364226309944 -122.448386220344 (37.7364226309944, -122.448386220344)
31290 221216 Undocumented 2 Betula spp :: Birch 95 350 Elizabeth St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6004036.63734 2102173.24246 37.752395729983796 -122.428922322819 (37.7523957299838, -122.428922322819)
38153 221203 Undocumented 2 Betula spp :: Birch 95 822 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001261.98607 2101410.13099 37.7501429669369 -122.43846283201401 (37.7501429669369, -122.438462832014)
39276 188830 Undocumented 2 Betula spp :: Birch 95 301 Kansas St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6011482.20897 2106712.2659299998 37.765277502971394 -122.40349348384301 (37.7652775029714, -122.403493483843)
45598 205616 Undocumented 2 Betula spp :: Birch 95 828 Foerster St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5998292.51855 2096480.5296099999 37.7364381182138 -122.44837642854999 (37.7364381182138, -122.44837642855)
47416 221223 Undocumented 2 Betula spp :: Birch 95 263 Upper Ter 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   5999330.89237 2105950.16873 37.762498758842 -122.445467058755 (37.762498758842, -122.445467058755)
54697 221224 Undocumented 2 Betula spp :: Birch 95 263 Upper Ter 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5999333.94712 2105953.7329599997 37.7625087197167 -122.445456749829 (37.7625087197167, -122.445456749829)
58065 205614 Undocumented 2 Betula spp :: Birch 95 828 Foerster St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5998302.82159 2096489.58159 37.7364635618398 -122.448341458403 (37.7364635618398, -122.448341458403)
58152 221222 Undocumented 2 Betula spp :: Birch 95 263 Upper Ter 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   5999326.533919999 2105947.62074 37.7624915138827 -122.445481949759 (37.7624915138827, -122.445481949759)
59983 221218 Undocumented 2 Betula spp :: Birch 95 350 Elizabeth St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6004007.55767 2102172.95105 37.752393283824894 -122.429022864307 (37.7523932838249, -122.429022864307)
60043 221213 Undocumented 2 Betula spp :: Birch 95 381 Elizabeth St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003933.59101 2102143.29739 37.752307674663 -122.429276538783 (37.752307674663, -122.429276538783)
64419 221221 Undocumented 2 Betula spp :: Birch 95 568 Liberty St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002627.37644 2103877.09879 37.756994245114 -122.433917551359 (37.756994245114, -122.433917551359)
64465 221206 Undocumented 2 Betula spp :: Birch 95 144 Prospect Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006807.09402 2098682.83773 37.7429682934411 -122.419094053065 (37.7429682934411, -122.419094053065)
67115 221225 Undocumented 2 Betula spp :: Birch 95 233 Hermann St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   6004131.6241 2108689.19753 37.7702923637227 -122.42905838393601 (37.7702923637227, -122.429058383936)
68279 221220 Undocumented 2 Betula spp :: Birch 95 270 Cumberland St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6003890.13554 2104532.5709 37.7588655949011 -122.429597200168 (37.7588655949011, -122.429597200168)
70574 188832 Undocumented 2 Betula spp :: Birch 95 301 Kansas St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6011480.8277900005 2106725.4309099996 37.7653135738934 -122.40349918733999 (37.7653135738934, -122.40349918734)
73244 205618 DPW Maintained 3 Betula spp :: Birch 95 400x Marietta Dr 26 Median : Cutout 11 Tree 1 DPW 2     5 Width 3ft   5999201.98821 2097029.00805 37.7379960650707 -122.445271442731 (37.7379960650707, -122.445271442731)
130362 221210 Undocumented 2 Betula spp :: Birch 95 239 Precita Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007933.08994 2100297.9588900004 37.7474664010656 -122.415314968738 (37.7474664010656, -122.415314968738)
131770 205615 Undocumented 2 Betula spp :: Birch 95 828 Foerster St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   5998298.69367 2096485.63858 37.7364524992737 -122.448355446446 (37.7364524992737, -122.448355446446)
131874 221207 Undocumented 2 Betula spp :: Birch 95 144 Prospect Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6006793.72845 2098662.88692 37.7429127603125 -122.41913885277599 (37.7429127603125, -122.419138852776)
133349 221208 Undocumented 2 Betula spp :: Birch 95 53 Mirabel Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007634.82349 2099989.12367 37.746601640864206 -122.41632448648599 (37.7466016408642, -122.416324486486)
151116 221209 Undocumented 2 Betula spp :: Birch 95 740 Eugenia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008349.6086099995 2097665.71648 37.7402622469036 -122.413688516938 (37.7402622469036, -122.413688516938)
153005 188831 Undocumented 2 Betula spp :: Birch 95 301 Kansas St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6011481.94285 2106719.4557 37.765297229595795 -122.40349491016899 (37.7652972295958, -122.403494910169)
155755 221219 Undocumented 2 Betula spp :: Birch 95 274 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002058.8805 2104265.20711 37.7580276192018 -122.4359113915 (37.7580276192018, -122.4359113915)
155941 122921 Undocumented 2 Betula spp :: Birch 95 166 11th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5992451.5223199995 2114364.2053900003 37.7852063091564 -122.469872700188 (37.7852063091564, -122.469872700188)
156083 221217 Undocumented 2 Betula spp :: Birch 95 350 Elizabeth St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6004021.19424 2102172.66993 37.752393283825604 -122.42897568677401 (37.7523932838256, -122.428975686774)
158266 221214 Undocumented 2 Betula spp :: Birch 95 367 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6004009.66703 2102145.13724 37.752317033024894 -122.42901358691601 (37.7523170330249, -122.429013586916)
162664 188829 Undocumented 2 Betula spp :: Birch 95 301 Kansas St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6011482.08375 2106706.1106 37.7652605948275 -122.40349348386002 (37.7652605948275, -122.40349348386)
169827 188833 Undocumented 2 Betula spp :: Birch 95 301 Kansas St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6011480.965530001 2106732.20207 37.7653321736669 -122.40349918735001 (37.7653321736669, -122.40349918735)
180067 175561 Undocumented 2 Betula spp :: Birch 95 280 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003661.86049 2092085.64478 37.7246762727695 -122.42949902477301 (37.7246762727695, -122.429499024773)
183174 221211 Undocumented 2 Betula spp :: Birch 95 522 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6007835.28715 2104887.50229 37.7600627472247 -122.41597812701299 (37.7600627472247, -122.415978127013)
184849 221215 Undocumented 2 Betula spp :: Birch 95 350 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6004049.2112 2102175.65559 37.7524030675729 -122.428879012372 (37.7524030675729, -122.428879012372)

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