Water well construction data collected since April 2000 as required by ECL 15-1525.
This dataset has the following 16 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
DEC Well Number | dec_well_number | text | Well number assigned by DEC. The first one or two characters represent the abbreviation for the county in which the well is located. The remaining characters are sequential whole numbers. | A000801 A000802 A000803 A000804 A000805 view top 100 |
Well Location | well_location | text | Description of well location. N/A indicates the value was not reported. | N/A Well 2 Well 1 Lot 2 Lot 1 view top 100 |
Street Name | street_name | text | Street on which the well is located. N/A indicates the value was not reported. | N/A River Rd Rt 9 Ridge Rd South Shore Rd view top 100 |
Town | town | text | Town where well is located. | Wilton Warwick East Fishkill Mamakating Greenfield view top 100 |
County | county | text | County where well is located. | Orange Saratoga Ulster Dutchess Washington view top 100 |
DEC Region | dec_region | number | DEC Region where well is located. | 3 5 4 7 9 view top 100 |
Well Depth (Feet bgs) | well_depth_feet_bgs | number | Depth to bottom of well (feet below ground surface). Blank indicates the value was not reported. | 300 200 100 120 140 view top 100 |
Depth to Bedrock (Feet bgs) | depth_to_bedrock_feet_bgs | number | Depth to top of bedrock (feet below ground surface). ‘-999’ indicates that bedrock was not encountered. Blank indicates the value was not reported. | -999 10 20 30 5 view top 100 |
Depth to Groundwater (Feet bgs) | depth_to_groundwater_feet | number | Depth to groundwater (feet below ground surface). Blank indicates the value was not reported. | 20 30 40 10 15 view top 100 |
Cased Depth (Feet bgs) | cased_depth_feet_bgs | number | Depth to bottom of casing (feet below ground surface). Blank indicates the value was not reported. | 19 20 40 39 18 view top 100 |
Screened | screened | text | Is the well screened (Y/N). | N Y view top 100 |
Yield Test Average Discharge (gpm) | yield_test_average_discharge | number | Average discharge rate (gallons per minute). Blank indicates the value was not reported. Zero indicates no discharge. | 10.0 5.0 20.0 15.0 8.0 view top 100 |
Driller Registration Number | driller_registration_number | text | Registration number of drilling company. | NYRD10119 NYRD10178 NYRD10024 NYRD10002 NYRD10118 view top 100 |
Latitude | latitude | number | Latitude (decimal degrees), GCS_WGS_1984. Blank indicates the value was not reported or was removed from the dataset due to inaccuracy. | 43.1325 42.7625 43.1275 42.54472222 41.34 view top 100 |
Longitude | longitude | number | Longitude (decimal degrees), GCS_WGS_1984. Blank indicates the value was not reported or was removed from the dataset due to inaccuracy. | -73.74166667 -73.725 -73.66416667 -73.72133333 -73.7025 view top 100 |
Georeference | georeference | point | Open Data/Socrata-generated geocoding information from supplied address components. | {"coordinates":[-76.73227778,43.25652778],"type":"Point"} {"coordinates":[-73.51466667,41.771],"type":"Point"} {"coordinates":[-73.87305556,41.02458333],"type":"Point"} {"coordinates":[-73.58133333,41.6765],"type":"Point"} {"coordinates":[-73.68952778,41.03652778],"type":"Point"} view top 100 |