Open Conveyances by US Government | Demographics and Population Studies

About this Dataset

Open Conveyances

This service represents CTDOT’s Stormwater Drainage Network. The data is collected from a collection of resources including completed construction plans, right-of-way plans, permits & field reconnaissance. Not all drainage features depicted on the map accurately reflect the condition of the drainage network that is currently built. Data is updated, modified and added daily by CTDOT to both grow the inventory of drainage structures statewide and to improve accuracy. Drainage data is collected for continued compliance of the CTDOT MS4 Permit and for CTDOT’s Asset Management Purposes.

Please refer to the CTDOT Maintenance Guide for definitions of all Drainage Features:

ctdot-ms4-gis-database-maintenance-guide-jan-2021.pdf

This data is digitized at a scale of approximately 1:500 and was digitized from the 2016, 2019 and 2023 CT imagery.

The coordinate system used is NAD 1983 2011 State Plane Connecticut FIPS 0600 Ft US WKID: 6434 Authority: EPSG.

It is edited in the Drainage Network - Office Editors group and is maintained by the Office of Environmental Planning in the Bureau of Planning and the Office of Environmental Compliance in the Bureau of Engineering.

The data is updated daily. The metadata is updated as needed.
Organization: State of Connecticut
Last updated: 2025-03-22T16:49:46.364269
Tags: blind-ties, bmps, catchment-areas, closed-conveyances, connecticut, ctdot, culverts, drainage, drainage-network, end-walls, headwalls, inlets, interconnections, manholes, open-conveyances

Tables

Table 1

@usgov.state_of_connecticut_open_conveyances.table_1

282.02 KB
3977 rows
36 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "global_id" VARCHAR,
  "open_conveyance_id" VARCHAR,
  "maintenance_district" BIGINT,
  "maintenance_garage" VARCHAR,
  "municipality" VARCHAR,
  "highway" VARCHAR,
  "lrs_id" VARCHAR,
  "mile_point" DOUBLE,
  "local_road_name" VARCHAR,
  "requires_traffic_control" VARCHAR,
  "location" VARCHAR,
  "catchment_area_id" VARCHAR,
  "project_number" VARCHAR,
  "year_installed" DOUBLE,
  "datum_of_plans" VARCHAR,
  "data_source" VARCHAR,
  "owned_by" VARCHAR,
  "maintained_by" VARCHAR,
  "cover" VARCHAR,
  "height_inches" DOUBLE,
  "width_inches" DOUBLE,
  "length_ft" DOUBLE,
  "elevation_in" VARCHAR,
  "elevation_out" VARCHAR,
  "condition_rating_inspection_status" VARCHAR,
  "last_condition_rating_inspection_date" VARCHAR,
  "maintenance_activity_reason" VARCHAR,
  "last_maintenance_activity_date" VARCHAR,
  "archive_status" VARCHAR,
  "archive_year" DOUBLE,
  "created_user" VARCHAR,
  "created_date" VARCHAR,
  "last_edited_user" VARCHAR,
  "last_edited_date" VARCHAR,
  "shape_length" DOUBLE
);