About this Dataset

Roadway Sections North 2019

State DOTs provide the location limits of highway sections to be used to represent statewide aggregations based on a statistically valid Sample Panel.
The North contains data for the following States: Maine, New Hampshire, Vermont, New York, Massachusetts, Rhode Island, Connecticut, New Jersey, Pennsylvania, Ohio, Maryland, District of Columbia, and Delaware.
Organization: Department of Transportation
Last updated: 2025-07-01T13:01:48.157581
Tags: hpms, hppi

Tables

Table 1

@usgov.dot_gov_roadway_sections_north_2019.table_1

68.89 MB
16,343,564 rows
10 columns

CREATE TABLE table_1 (
  "year_record" BIGINT,
  "state_code" BIGINT,
  "route_id" VARCHAR,
  "begin_point" DOUBLE,
  "end_point" DOUBLE,
  "data_item" VARCHAR,
  "value_numeric" VARCHAR,
  "value_text" VARCHAR,
  "value_date" TIMESTAMP,
  "natroute_id" VARCHAR
);