About this Dataset

Ramps

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:12.022721
Tags: basemap, ctdot, roadway

Tables

Table 1

@usgov.state_of_connecticut_ramps.table_1

136.53 KB
1922 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" VARCHAR,
  "route_suffix" VARCHAR,
  "ramp_number" BIGINT,
  "ramp_suffix" VARCHAR,
  "road_type" VARCHAR,
  "town_number" BIGINT,
  "town_name" VARCHAR,
  "pri_sec_status" VARCHAR,
  "year" BIGINT,
  "globalid" VARCHAR,
  "shapestlength" DOUBLE
);