About this Dataset

Connecticut Routes

It is derived from the Connecticut Route Segments layer, which is based on spatial information from the U.S. Bureau of Census that was published for Connecticut by the University of Connecticut, Center for Geographic Information and Analysis. The spatial information (line feature geometry) from the U.S. Bueau of Census was compiled for the year 2000 and used to create a continuous line feature for each interstate highway and route shown on the State Tourism Map 2002-2003 published by the Connecticut Department of Transportation. The Connecticut Routes layer does not include local roads, highway entrance and exit ramps, highway rest areas, exit numbers, house address, traffic direction, or traffic volume information. Features are linear and represent divided and undivided route centerlines mapped at 1:100,000 scale (1 inch = 1.578 mile).
Organization: State of Connecticut
Last updated: 2024-02-09T15:40:42.652322
Tags: base-map, boundaries, connecticut, ct, ctdeep, deep, highway, index, interstate, location, other, quadrangle-map, road, route, routes, small-scale, tiger-line, transportation, usgs

Tables

Table 1

@usgov.state_of_connecticut_connecticut_routes_8d60f.table_1

11.98 kB
233 rows
7 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "route" VARCHAR,
  "routeclass" VARCHAR,
  "routeno" VARCHAR,
  "routename" VARCHAR,
  "scalelevel" BIGINT,
  "shape_length" DOUBLE  -- Shape, Length
);