About this Dataset

Rumble Strips

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:36:22.022296
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_rumble_strips.table_1

272.21 KB
4180 rows
18 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "route_id" VARCHAR,
  "begin_point" DOUBLE,
  "end_point" DOUBLE,
  "route_type" VARCHAR,
  "rumb_iit_x_sect" VARCHAR,
  "rumb_install_month" VARCHAR,
  "rumb_install_year" VARCHAR,
  "rumb_bgn_desc" VARCHAR,
  "rumb_end_desc" VARCHAR,
  "rumb_rumb_id" DOUBLE,
  "rumb_project_id" VARCHAR,
  "rumb_rs_detail" VARCHAR,
  "rumb_type" VARCHAR,
  "rumb_remarks" VARCHAR,
  "year" BIGINT,
  "globalid" VARCHAR,
  "shape_length" DOUBLE
);