Blockface by US Government | Transportation and Logistics

About this Dataset

Blockface

Displays blockfaces for all segments of the street network. Identifies the elements of the block, such as peak hour restrictions, length of the block, parking categories, and restricted parking zones.

Update Cycle: Nightly

Feature Class: V_BLOCKFACE
Organization: City of Seattle
Last updated: 2025-02-28T23:45:29.549326
Tags: block, blockface, id, parking, rpz, sdot, seattle, seattle-gis-open-data, streets, transportation

Tables

Table 1

@usgov.city_of_seattle_blockface_d8691.table_1

2.93 MB
47878 rows
74 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "elmntkey" BIGINT,
  "segkey" BIGINT,
  "distance" BIGINT,
  "blockface_length" BIGINT,
  "end_distance" BIGINT,
  "width" BIGINT,
  "unitid" BIGINT,
  "unitid2" BIGINT,
  "unitdesc" VARCHAR,
  "side" VARCHAR,
  "block_id" VARCHAR,
  "block_nbr" BIGINT,
  "csm" VARCHAR,
  "parking_category" VARCHAR,
  "total_spaces" BIGINT,
  "paid_spaces" BIGINT,
  "carpool_spaces" BIGINT,
  "rpz_spaces" BIGINT,
  "tl_spaces" BIGINT,
  "bus" BIGINT,
  "nopark" BIGINT,
  "nostop" BIGINT,
  "total_nopark" BIGINT,
  "load" VARCHAR,
  "zone" BIGINT,
  "total_zones" BIGINT,
  "parking_spaces" BIGINT,
  "unrestricted" BIGINT,
  "tier" BIGINT,
  "wkd_rate1" DOUBLE,
  "wkd_start1" BIGINT,
  "wkd_end1" BIGINT,
  "wkd_rate2" DOUBLE,
  "wkd_start2" BIGINT,
  "wkd_end2" BIGINT,
  "wkd_rate3" DOUBLE,
  "wkd_start3" DOUBLE,
  "wkd_end3" DOUBLE,
  "sat_rate1" DOUBLE,
  "sat_start1" DOUBLE,
  "sat_end1" DOUBLE,
  "sat_rate2" DOUBLE,
  "sat_start2" DOUBLE,
  "sat_end2" DOUBLE,
  "sat_rate3" DOUBLE,
  "sat_start3" DOUBLE,
  "sat_end3" DOUBLE,
  "sun_rate1" DOUBLE,
  "sun_start1" DOUBLE,
  "sun_end1" DOUBLE,
  "sun_rate2" DOUBLE,
  "sun_start2" DOUBLE,
  "sun_end2" DOUBLE,
  "sun_rate3" DOUBLE,
  "sun_start3" DOUBLE,
  "sun_end3" DOUBLE,
  "peak_hour" VARCHAR,
  "rpz_zone" VARCHAR,
  "rpz_area" DOUBLE,
  "paidarea" VARCHAR,
  "parking_time_limit" DOUBLE,
  "subarea" VARCHAR,
  "start_time_wkd" VARCHAR,
  "end_time_wkd" VARCHAR,
  "start_time_sat" VARCHAR,
  "end_time_sat" VARCHAR,
  "start_time_sun" VARCHAR,
  "end_time_sun" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "overridecomment" VARCHAR,
  "shape_length" DOUBLE
);