Dataset: Wells In Connecticut

About this Dataset

Wells In Connecticut

Submitted online since January 1, 2021. Print a copy of an individual report at https://elicense.ct.gov and click on "Public Reports". (Note: You will need the DCP Report ID, found in the 6th column of this report.)
Organization: State of Connecticut
Last updated: 2021-08-07T13:22:47.388873
Tags: wells

Tables

Table 1

@usgov.state_of_connecticut_wells_in_connecticut.table_1

1.19 MB
5655 rows
73 columns


CREATE TABLE table_1 (
  "type_of_report" VARCHAR,
  "credential" VARCHAR,
  "credential_holder" VARCHAR,
  "credential_holder_address" VARCHAR,
  "drilling_company" VARCHAR,
  "dcpreportid" BIGINT,
  "dcpboringid" BIGINT,
  "date_of_boring_or_abandonment" VARCHAR,
  "boring_label" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "owner" VARCHAR,
  "owner_address" VARCHAR,
  "owner_address_details" VARCHAR,
  "well_address" VARCHAR,
  "well_city" VARCHAR,
  "well_state" VARCHAR,
  "well_zip" BIGINT,
  "well_address_details" VARCHAR,
  "lot_number" VARCHAR,
  "borings_in_report" VARCHAR,
  "permit_links" VARCHAR,
  "map_links" VARCHAR,
  "photo_links" VARCHAR,
  "use_of_well" TIMESTAMP,
  "drill_equipment" VARCHAR,
  "screen_used" VARCHAR,
  "casing_length" VARCHAR,
  "casing_diameter" DOUBLE,
  "casing_into_bedrock" VARCHAR,
  "casing_weight" DOUBLE,
  "casing_threaded" VARCHAR,
  "casing_welded" VARCHAR,
  "casing_drive_shoe" VARCHAR,
  "casing_grouted" VARCHAR,
  "yield_test_type" VARCHAR,
  "yield_test_hours" DOUBLE,
  "yield_test_result" DOUBLE,
  "yield_test_heightresult" VARCHAR,
  "water_depth_from_surface" DOUBLE,
  "water_during_test" DOUBLE,
  "depth_of_well" DOUBLE,
  "depth_grid_upperlowerformation_typewater_zone" VARCHAR,
  "top_of_rock" VARCHAR,
  "screen_make" VARCHAR,
  "screen_length_open_to_aquifer" DOUBLE,
  "screen_slot_size" DOUBLE,
  "screen_diameter" DOUBLE,
  "gravel_packed" DOUBLE,
  "screen_from" DOUBLE,
  "screen_to" DOUBLE,
  "location_description" VARCHAR,
  "type_of_coupling" VARCHAR,
  "type_of_casing" VARCHAR,
  "pitless_adapter_type" VARCHAR,
  "pitless_adapter_manufacturer" VARCHAR,
  "adapter_meets_standards" VARCHAR,
  "well_cap_type" VARCHAR,
  "well_cap_manufacturer" VARCHAR,
  "well_cap_meets_standards" VARCHAR,
  "bollards" VARCHAR,
  "abandonment_description" VARCHAR,
  "height_above_ground" DOUBLE,
  "geo_type" VARCHAR,
  "loop_length" DOUBLE,
  "grout_type" VARCHAR,
  "grout_volume" DOUBLE,
  "abandonment_materials" VARCHAR,
  "amounttype_of_grout_for_abandonment" VARCHAR,
  "repair_type" VARCHAR,
  "repairs_completed" VARCHAR,
  "total_new_depth_of_well" DOUBLE,
  "geolocation" VARCHAR
);