About this Dataset

State Route Local Names

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

Tables

Table 1

@usgov.state_of_connecticut_state_route_local_names_ac3fc.table_1

191.53 kB
2,587 rows
11 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "route_id" VARCHAR,
  "begin_point" DOUBLE,
  "end_point" DOUBLE,
  "xsp" VARCHAR,
  "stln_st_loc_name" VARCHAR,
  "town_number" BIGINT,
  "town_name" VARCHAR,
  "year" BIGINT,
  "globalid" VARCHAR,
  "shapestlength" DOUBLE
);