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

3.07 MB
47,878 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  -- Shape, Length
);