Manholes
State of Connecticut
@usgov.state_of_connecticut_manholes
State of Connecticut
@usgov.state_of_connecticut_manholes
CREATE TABLE table_1 (
"objectid" BIGINT,
"global_id" VARCHAR,
"manhole_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,
"type_of_manhole" VARCHAR,
"key_junction" VARCHAR,
"structure_cover" VARCHAR,
"sump_feet" DOUBLE,
"top_of_frame_to_bottom_of_structure_feet" VARCHAR,
"top_of_frame_to_lowest_invert_out_feet" VARCHAR,
"top_of_frame_elevation" DOUBLE,
"lowest_invert_out_elevation" DOUBLE,
"bottom_of_structure_elevation" DOUBLE,
"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,
"x" DOUBLE,
"y" DOUBLE
);
Anyone who has the link will be able to view this.