About this Dataset

State Routes

A custom basemap created for internal Connecticut Department of Transportation in web apps and maps.

The basemap represents the most recent and active Public Road Network as maintained by the Bureau of Policy & Planning's Roadway Inventory Unit and is updated on an annual basis.

Map styling mimics the format of an Open Street Maps style basemap and routes are differentiated by their prefix (e.g. Interstate, US, CT, etc.) with local roads sharing the same symbiology across the state.

At closer zoom levels, ortho imagery from 2019 appears within the map extent.
Organization: State of Connecticut
Last updated: 2024-02-09T15:45:37.898702
Tags: basemap, ctdot, roadway

Tables

Table 1

@usgov.state_of_connecticut_state_routes_28c0a.table_1

184.65 kB
2,493 rows
17 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "route_id" VARCHAR,
  "begin_point" DOUBLE,
  "end_point" DOUBLE,
  "route_dir" VARCHAR,
  "route_prefix" VARCHAR,
  "route_number" BIGINT,
  "route_suffix" VARCHAR,
  "ramp_number" VARCHAR,
  "ramp_suffix" VARCHAR,
  "road_type" VARCHAR,
  "town_number" BIGINT,
  "town_name" VARCHAR,
  "pri_sec_status" VARCHAR,
  "year" BIGINT,
  "globalid" VARCHAR,
  "shapestlength" DOUBLE
);