Freight Network by US Government | Transportation and Logistics

About this Dataset

Freight Network

Freight related data grouped together and made up of major truck streets, freight network, over legal routes, and heavy haul network. Data is maintained by Seattle Department of Transportation.

Feature Class:

MajTrkStrts
FMP_FreightNetwork
Freight_OverLegalRoutes
Freight_HeavyHaulNetwork

Refresh Cycle: Nightly Refresh
Organization: City of Seattle
Last updated: 2025-02-28T23:42:48.455713
Tags: freight, freight-network, heavy-haul-network, major-truck-streets, over-legal-routes, sdot, seattle-gis-open-data

Tables

Table 1

@usgov.city_of_seattle_freight_network_ec2fd.table_1

283.8 KB
2168 rows
43 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "comptype" BIGINT,
  "unitid" VARCHAR,
  "unitid2" VARCHAR,
  "unitidsort" VARCHAR,
  "unitdesc" VARCHAR,
  "stname_ord" VARCHAR,
  "onstreet" VARCHAR,
  "xstrlo" VARCHAR,
  "xstrhi" VARCHAR,
  "artclass" BIGINT,
  "artdescrip" VARCHAR,
  "owner" VARCHAR,
  "blocknbr" BIGINT,
  "speedlimit" BIGINT,
  "segdir" VARCHAR,
  "oneway" VARCHAR,
  "onewaydir" VARCHAR,
  "flow" VARCHAR,
  "seglength" DOUBLE,
  "surfacewid" BIGINT,
  "surfaced_1" VARCHAR,
  "intrlo" VARCHAR,
  "dirlo" VARCHAR,
  "intkeylo" BIGINT,
  "intrhi" VARCHAR,
  "dirhi" VARCHAR,
  "intkeyhi" BIGINT,
  "gis_mid_x" DOUBLE,
  "gis_mid_y" DOUBLE,
  "sgndbkrout" VARCHAR,
  "nghbrhdgrn" VARCHAR,
  "nationhwys" VARCHAR,
  "streettype" VARCHAR,
  "mjtrk_str" VARCHAR,
  "pvmtcondin" BIGINT,
  "pvmtcond_1" BIGINT,
  "tranclass" BIGINT,
  "trandescri" VARCHAR,
  "freightclass" BIGINT,
  "se_anno_cad_data" VARCHAR,
  "shape_length" DOUBLE
);