Street_Tree_List

Data source: data.sfgov.org

33 rows where qLegalStatus = 2 and qSpecies = 90

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus ✖

  • Undocumented · 14 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
129588 129588 193407 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 541 Missouri St 1 : 4 Tree 1 Private 1     3 Width 2ft   6013570.69062 2104547.33874 37.7594495210946 -122.396118132954 (37.7594495210946, -122.396118132954)
132375 132375 230378 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 11 Haight St 3 : 4 Tree 1 Private 1     5 Width 4ft   6006027.69558 2109650.1201 37.7730379732539 -122.422568162015 (37.7730379732539, -122.422568162015)
134507 134507 230384 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 601 Dolores St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6005003.814780001 2104818.83763 37.7597146115626 -122.42576595245501 (37.7597146115626, -122.425765952455)
136828 136828 230393 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 3420 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6005567.360669999 2103163.57677 37.7552014816894 -122.423699232135 (37.7552014816894, -122.423699232135)
152400 152400 230382 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 655 Dolores St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 6ft   6005021.64655 2104500.02665 37.7588402394163 -122.42568158976002 (37.7588402394163, -122.42568158976)
156278 156278 230376 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 126 Dolores St 1 : 4 Tree 1 Private 1     4 Width 3ft   6004756.55794 2107626.00234 37.7674084411732 -122.426821010098 (37.7674084411732, -122.426821010098)
164713 164713 230387 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 51 13th St 2 : 4 Tree 1 Private 1     7 Width 4ft   6008108.07186 2108284.2511400003 37.7694047643365 -122.415275151222 (37.7694047643365, -122.415275151222)
172742 172742 177452 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 404 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6003440.2849 2091219.73942 37.7222861409715 -122.430203237092 (37.7222861409715, -122.430203237092)
173263 173263 230390 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 3431 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6005492.40988 2103117.15388 37.7550697840629 -122.423955133335 (37.7550697840629, -122.423955133335)
178042 178042 230375 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 70 Pearl St 1 : 4 Tree 1 Private 1     9 Width 4ft   6005616.00843 2108643.7620099997 37.770251521926 -122.423920665902 (37.770251521926, -122.423920665902)
178549 178549 230385 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 581 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 9ft   6004995.95318 2104998.86424 37.760208477866 -122.42580595608601 (37.760208477866, -122.425805956086)
179739 179739 193406 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 746 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6011525.03424 2104899.87784 37.7603034831294 -122.40321785872601 (37.7603034831294, -122.403217858726)
180875 180875 230388 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 51 13th St 3 : 4 Tree 1 Private 1     8 Width 4ft   6008125.5999300005 2108283.70929 37.7694042616334 -122.41521448386001 (37.7694042616334, -122.41521448386)
182507 182507 230379 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 636 Potrero Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6010352.94216 2105328.73163 37.7614154903439 -122.407301828531 (37.7614154903439, -122.407301828531)

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