About this Dataset

Shoreline Street Ends

Shoreline street ends are designated by ordinance as a land portion of a street segment that provides physical or visual access to a body of water and its shoreline. This layer allows SDOT to track these sites separately from other parts of the right of way. The data includes shoreline street ends located within the Seattle City Limits. The information includes the nearest cross street, common place name, right-of-way width, status of the street end (Vacated, Public Access, In Water Use, Industrial)

Refresh Cycle: Daily

Feature Class: SDOT.V_STREETENDS
Organization: City of Seattle
Last updated: 2025-02-28T23:29:41.516113
Tags: common-data-layers, sdot, seattle-gis-open-data, shoreline-street-ends, transportation

Tables

Table 1

@usgov.city_of_seattle_shoreline_street_ends.table_1

158.8 KB
196688 rows
49 columns


CREATE TABLE table_1 (
  "objectid" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "compkey" VARCHAR,
  "comptype" VARCHAR,
  "intkey" VARCHAR,
  "unitid" VARCHAR,
  "unittype" VARCHAR,
  "unitdesc" VARCHAR,
  "intersectionid" VARCHAR,
  "intersection" VARCHAR,
  "current_status" VARCHAR,
  "current_status_date" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "ownership" VARCHAR,
  "ownership_date" VARCHAR,
  "addby" VARCHAR,
  "adddttm" VARCHAR,
  "modby" VARCHAR,
  "moddttm" VARCHAR,
  "install_date" VARCHAR,
  "asblt" VARCHAR,
  "category" VARCHAR,
  "material" VARCHAR,
  "style" VARCHAR,
  "shoreline_image" VARCHAR,
  "shoreline_map" VARCHAR,
  "asset_width" VARCHAR,
  "maintained_by" VARCHAR,
  "improved_by" VARCHAR,
  "installation_and_maintenance_responsibility_agreement" VARCHAR,
  "comments" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "overridecomment" VARCHAR,
  "attachment_1" VARCHAR,
  "attachment_2" VARCHAR,
  "attachment_3" VARCHAR,
  "attachment_4" DOUBLE,
  "attachment_5" DOUBLE,
  "attachment_6" DOUBLE,
  "attachment_7" VARCHAR,
  "attachment_8" VARCHAR,
  "attachment_9" VARCHAR,
  "num_attachments" DOUBLE,
  "orig_fid" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);