home / trees

Street_Tree_List

Data source: data.sfgov.org

12 rows where qSpecies = 88

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
524 100578 Significant Tree 4 Cedrus atlantica Glauca :: Blue Atlas Cedar 88 35 Lloyd St 1 Front Yard : Yard 4 Tree 1 Private 2         Permit Number 56924 6002279.7 2108550.0 37.769805157627204 -122.435454215606 (37.7698051576272, -122.435454215606) 15 5 5 29492 9
12671 114404 Significant Tree 4 Cedrus atlantica Glauca :: Blue Atlas Cedar 88 500X ARBALLO DR 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     24 3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
12672 114405 Significant Tree 4 Cedrus atlantica Glauca :: Blue Atlas Cedar 88 500X ARBALLO DR 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
12673 114406 Significant Tree 4 Cedrus atlantica Glauca :: Blue Atlas Cedar 88 500X ARBALLO DR 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
12675 114408 Significant Tree 4 Cedrus atlantica Glauca :: Blue Atlas Cedar 88 500X ARBALLO DR 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
68567 19665 DPW Maintained 1 Cedrus atlantica Glauca :: Blue Atlas Cedar 88 100 STAIRWAY5 64 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 60ST                      
68600 19668 DPW Maintained 1 Cedrus atlantica Glauca :: Blue Atlas Cedar 88 100 STAIRWAY5 67 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 60ST                      
76208 20478 DPW Maintained 1 Cedrus atlantica Glauca :: Blue Atlas Cedar 88 1203X Sunset Blvd 12 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3     24 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.49588333961701 (37.7652050441375, -122.495883339617) 11 6 2 55 8
123716 253384 Significant Tree 4 Cedrus atlantica Glauca :: Blue Atlas Cedar 88 55 Cerritos Ave 1 Front Yard : Yard 4 Tree 1 Private 2       10x10   5992588.0 2092941.0 37.7263916542788 -122.46784182223999 (37.7263916542788, -122.46784182224) 9 8 4 59 40
124429 254401 Significant Tree 4 Cedrus atlantica Glauca :: Blue Atlas Cedar 88 755 Ocean Ave 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x3 Permit Number 779678 5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
124747 254934 Significant Tree 4 Cedrus atlantica Glauca :: Blue Atlas Cedar 88 755 Ocean Ave 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x6   5998003.33154 2091542.89024 37.7228639895457 -122.449020681299 (37.7228639895457, -122.449020681299) 9 7 4 28861 24
124748 254935 Significant Tree 4 Cedrus atlantica Glauca :: Blue Atlas Cedar 88 755 Ocean Ave 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x6 Permit Number 779678 5998003.33154 2091542.89024 37.7228639895457 -122.449020681299 (37.7228639895457, -122.449020681299) 9 7 4 28861 24

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" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 14.856ms · Data source: data.sfgov.org