Catchment Areas
State of Connecticut
@usgov.state_of_connecticut_catchment_areas
State of Connecticut
@usgov.state_of_connecticut_catchment_areas
CREATE TABLE table_1 (
"objectid" BIGINT,
"global_id" VARCHAR,
"catchment_area_id" VARCHAR,
"maintenance_district" BIGINT,
"maintenance_garage" VARCHAR,
"municipality" VARCHAR,
"highway" BIGINT,
"lrs_id" VARCHAR,
"mile_point" DOUBLE,
"local_road_name" VARCHAR,
"location" VARCHAR,
"major_drainage_basin" VARCHAR,
"major_drainage_basin_number" BIGINT,
"regional_drainage_basin" VARCHAR,
"regional_drainage_basin_number" BIGINT,
"subregional_drainage_basin" VARCHAR,
"subregional_drainage_basin_number" BIGINT,
"local_drainage_basin_number" VARCHAR,
"associated_h_e_id" VARCHAR,
"associated_bmp_id" VARCHAR,
"associated_screening_sampling_id" VARCHAR,
"catchment_area_source" VARCHAR,
"project_number" VARCHAR,
"idde_priority" VARCHAR,
"key_junction_manhole" VARCHAR,
"treatment_status" VARCHAR,
"disconnection_status" VARCHAR,
"system_vulnerability_factor_notes" VARCHAR,
"total_drainage_area_acres" DOUBLE,
"total_impervious_area_acres" DOUBLE,
"total_directly_connected_impervious_area_acres" DOUBLE,
"ctdot_drainage_area_acres" DOUBLE,
"ctdot_impervious_area_acres" DOUBLE,
"ctdot_directly_connected_impervious_area_acres" DOUBLE,
"created_user" VARCHAR,
"created_date" VARCHAR,
"last_edited_user" VARCHAR,
"last_edited_date" VARCHAR,
"shape_area" DOUBLE,
"shape_length" DOUBLE
);
Anyone who has the link will be able to view this.