Transit Classification by US Government | Transportation and Logistics

About this Dataset

Transit Classification

Transit classifications of City streets data is sourced from the Hansen Asset Management System.

| Attribute Information: Transit_Classification_OD.pdf

| Update Cycle: As Needed
| Contact Email: DOT_IT_GIS@seattle.gov
Organization: City of Seattle
Last updated: 2025-02-28T23:35:21.557949
Tags: 018, classification, gis, pedestrian, sdot, seattle, seattle-gis-open-data, signal, transit, transportation, wa, wsdot

Tables

Table 1

@usgov.city_of_seattle_transit_classification_7b050.table_1

722.32 KB
5263 rows
51 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "comptype" BIGINT,
  "unitid" BIGINT,
  "unitid2" BIGINT,
  "unitidsort" BIGINT,
  "unitdesc" VARCHAR,
  "stname_ord" VARCHAR,
  "onstreet" VARCHAR,
  "xstrlo" VARCHAR,
  "xstrhi" VARCHAR,
  "artclass" BIGINT,
  "artdescript" VARCHAR,
  "owner" VARCHAR,
  "status" VARCHAR,
  "blocknbr" BIGINT,
  "speedlimit" BIGINT,
  "segdir" VARCHAR,
  "oneway" VARCHAR,
  "onewaydir" VARCHAR,
  "flow" VARCHAR,
  "seglength" DOUBLE,
  "surfacewidth" BIGINT,
  "surfacetype_1" VARCHAR,
  "surfacedate_1" TIMESTAMP,
  "surfacetype_2" VARCHAR,
  "surfacedate_2" TIMESTAMP,
  "intrlo" VARCHAR,
  "dirlo" VARCHAR,
  "intkeylo" DOUBLE,
  "intrhi" VARCHAR,
  "dirhi" VARCHAR,
  "intkeyhi" DOUBLE,
  "gis_mid_x" DOUBLE,
  "gis_mid_y" DOUBLE,
  "sgndbkroute" VARCHAR,
  "nghbrhdgrnwy" VARCHAR,
  "nationhwysys" VARCHAR,
  "streettype" VARCHAR,
  "mjtrk_str_flag" VARCHAR,
  "pvmtcondindx1" BIGINT,
  "pvmtcondindx2" BIGINT,
  "tranclass" BIGINT,
  "trandescript" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "slope_pct" DOUBLE,
  "pvmtcategory" VARCHAR,
  "parkboulevard" VARCHAR,
  "shape_length" DOUBLE
);