About this Dataset

HPMS Asset

A collection of roadway assets maintained by the Roadway Inventory Unit. This data is a yearly snapshot and any up to date information after the Temporal Date Range should contact the data owner or custodian.
Organization: State of Connecticut
Last updated: 2024-02-09T15:32:05.997284
Tags: access-control, approaches, boroughs, classification, configuration, ctdot, curbs, exits, facility-type, functional-class, highway-type, hpms, intersection-approaches, intersections, inventory-dates, lanes, legislative, legislative-names, limited-access, medians, nhs, overlaps, ownership, permits, private-roads, road-work, roadway, roadway-designated-urban-area, roadways, rumble-strips, runaway-truck-ramps, scenic-roads, shoulders, state-local-names, strahnet

Tables

Table 1

@usgov.state_of_connecticut_hpms_asset_46459.table_1

242.79 kB
2,817 rows
37 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "route_id" VARCHAR,
  "begin_point" DOUBLE,
  "end_point" DOUBLE,
  "hpms_p_lanes" BIGINT,
  "hpms_cp_lanes" DOUBLE,
  "hpms_rt_lanes" DOUBLE,
  "rt_lane_desc" VARCHAR,
  "hpms_lt_lanes" DOUBLE,
  "lt_lane_desc" VARCHAR,
  "hpms_speed_limit" BIGINT,
  "hpms_sig_type" DOUBLE,
  "sig_type_desc" VARCHAR,
  "hpms_pct_g_time" DOUBLE,
  "hpms_num_sig" BIGINT,
  "hpms_stop_sig" BIGINT,
  "hpms_at_g_other" BIGINT,
  "hpms_lane_wid" BIGINT,
  "hpms_med_type" BIGINT,
  "med_type_desc" VARCHAR,
  "hpms_med_wid" DOUBLE,
  "hpms_shld_type" BIGINT,
  "shdl_type_desc" VARCHAR,
  "hpms_r_shld_wid" DOUBLE,
  "hpms_l_shld_wid" DOUBLE,
  "hpms_peak_pk" DOUBLE,
  "peak_pk_desc" VARCHAR,
  "hpms_wid_obs" VARCHAR,
  "hpms_wid_pot" BIGINT,
  "hpms_ter_type" DOUBLE,
  "ter_type_desc" VARCHAR,
  "hpms_pct_pas_sight" DOUBLE,
  "town_number" BIGINT,
  "town_name" VARCHAR,
  "year" BIGINT,
  "globalid" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);