All Layers and Tables (Test

Layers:

Layer: Water Wells WWC5 (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

The Water Well Completion Form Database (WWC5) contains information from records submitted by water well drillers to the Kansas Department of Health and Environment. Data is compiled by the Kansas Geological Survey. Drilling companies are mandated by state legislation under the Kansas Groundwater Exploration and Protection Act (KSA 82a-1201 et seq.) to provide information pertaining to the location, type, use, casing, nearest source of contamination, and so on of the well drilled using the WWC5 form. No water quality data is provided in this database. A good portion of the archived WWC5 records are in the form of electronically scanned images of the forms themselves. As such, the only standard database items entered into an Oracle RDBMS relate to the location information of the WWC5 wells, use of the well, when the well was completed, status of the wells, well depth, static water elevation, and the name of the drilling company servicing the site.

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"TYPE_OF_ACTION_CODE","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"56137d49ce7b63ddd84d0770cdf60d12","imageData":"iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABxklEQVQ4jb2Uz0vCYBzGX2TTkJZJgs2DCMLSg1QoBBF0MG/iWTzukO6cf8AguhUdNzx4lP6KrKOggomgQxFU9KAiIoypKPHVNG3+mBE9sNuXz/u8z/d5h6E/FPYvMJqmCY1GQ7XbxyZJOiBJMt9QqVR1juNSO8EYhnHmcpdPtZqdkiSCFEUdwvE+0uvrPbfb9U5RSXYVVAbz+Z5v43EXW6k4JpBFNZtmolaze1sts9PvN4RfXu5ja2HgCED5/BW57iqiqEOZzA05GuE8w7QKiw6xxYwEYeoIKVChcEEYjSWWpulgNBqtL8Eg7HL51Pnzaus0HO4hmKeoJBy+DJtujVDkaiaY73QMJwih1BIM1q/U1UwwL0n7cwNzGPQI1r+LcLyPxmN1TwaDQkKPYP1KYWq12DOZCoIMBiv2eM7T5fLZNYS7TVptF1ksWWEwGMhhIKs1zVar9timns1kNmcbDsdrmOentZDBeJ5/CwSOWAwbPUKPVjnUarsTkMXyEYH5jc8pFnuIhEJtwWgs3RWLLq8oHqLhUDMJGzKiqIRgsyWCit7mzCFNDwQoJPQI1g9bg7AhI477vtpWGOjricC39pejGPYbfQKoPNX9e8kHZQAAAABJRU5ErkJggg==","contentType":"image/png","width":14,"height":14,"angle":0,"xoffset":0,"yoffset":0},"value":"1","label":"Constructed"},{"symbol":{"type":"esriPMS","url":"646c64d267cf5bf709e303eb8a0a2679","imageData":"iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABy0lEQVQ4jWNhoCJgoYthSUlJvOzs7GpvRSWkfvBwS0revf2ciYnp2fTp08+SZFhmZqbxVVPL3icq6mo/eHglv/HxMbD+/Mkg+PL5Z2d9o4NqF881YDMUwzC/rp60/QamDY80tCS/8fGjyL2WluV9oqLu80ZGzjhCUKRkRVvzMpyGgVwEMuiGmaUkLq984+NnuGjjKPmXmWVGZuabm8guZEEOo1v6RmAXMRABbhqZ8Yo/vNeQlJSUPm/evGcohoEC+76WnjG613CB3+zsDCD1ahfPgSxHNQwSa7xEuQoGQOrfC4qoMzAwnEUxDBT9oFgjBXzj42P4wc0FdwDcMFA6AkU/KYD150+Gf6ysnzEMAyVIUDoCRT+xhrF9//5Z6t6dWxiGgaLYVcfg3H1tfXtQ4BICXJ8+MijcuHLr169fmIaBgPLl8w2PVTWW4UtnMCB349pz3SMHSmZAkwWGYTNmzDgQJSDcwPL3Tw8oHWFzIdenj2CDFK5emgVSjzc7LetonZXx4e0t8Yf3iu/oG/uA0h3IUFBgg8JI7fzpWxrnTqUTlTdhLkxKSroFSpCgdASKflCsgQIbFEbTkbxG0DAQgGYREMZZ5BBtGDkAACZGxfl+X9kiAAAAAElFTkSuQmCC","contentType":"image/png","width":14,"height":14,"angle":0,"xoffset":0,"yoffset":0},"value":"2","label":"Reconstructed"},{"symbol":{"type":"esriPMS","url":"9ad0e32334c45c5308b8beebffac97ee","imageData":"iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABp0lEQVQ4jb2UTW6CQBzFx8mMXxnEMW7oAewBPEAv4Clm0cpGF7hgyQHahW40Llx6jvYAdl8OoBsT+XASIxGbv5FGilRomr6EBDLw4z/vPSDoD0X+BSaEUEqlUqtcLt9hjLXtdrvCGC/H4/EiF0zX9Tbn/IUx1qKUaoQQFIYh2u12vmmab67rWtegCZhhGI+cc0tRFI1SGlurVCoKY6xTrVbb/X5/MBwO56mw80RWo9HQ0rZCKUXNZlMrFAoTXdc/Licklx6pqnqaCGUQ51yRUlpCiKfZbLaMwcDsWq3W/r61NGGMEdzvui68PA6D1MBslEOUUq1YLN4jhBYxGMQPqeURIeT03Nd1dAI9gvjzKAxDgPkJGBQSegTxZ4UdDgdfSmknYBCxaZrvqqo+gLm3FAQB8jzP3u/3SRjIcRyLMTb/qWeRfN9frdfrQVSLBGwymbz2ej3reDw+Q4+uTRgEwQnked4U7r9cS8Q3Go2m3W7XllIa9Xq9A70DKJgNHm02G9txnKdM32Y0oRDChkJCjyB+SA3MBo8ut3YTBjo/AEfqLycz7Df6BLjutV1f4sTaAAAAAElFTkSuQmCC","contentType":"image/png","width":14,"height":14,"angle":0,"xoffset":0,"yoffset":0},"value":"3","label":"Plugged"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,225,210,255],"toColor":[252,225,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[185,179,252,255],"toColor":[185,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[185,252,179,255],"toColor":[185,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,251,255],"toColor":[182,252,251,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,228,255],"toColor":[252,182,228,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[199,222,252,255],"toColor":[199,222,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,242,182,255],"toColor":[252,242,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,182,255],"toColor":[252,179,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[222,252,212,255],"toColor":[222,252,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[233,204,252,255],"toColor":[233,204,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,227,255],"toColor":[252,210,227,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[242,184,252,255],"toColor":[242,184,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,222,255],"toColor":[179,252,222,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
INPUT_SEQ_NUMBER (type: esriFieldTypeInteger, alias: KGS Record ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
DWR_APPROPRIATION_NUMBER (type: esriFieldTypeString, alias: DWR Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
OWNER_NAME (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
WATER_USE_CODE (type: esriFieldTypeInteger, alias: WATER_USE_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
TYPE_OF_ACTION_CODE (type: esriFieldTypeInteger, alias: TYPE_OF_ACTION_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
CONTRACTORS_LICENSE (type: esriFieldTypeString, alias: CONTRACTORS_LICENSE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
TOWNSHIP (type: esriFieldTypeSmallInteger, alias: TOWNSHIP, SQL Type: sqlTypeOther, nullable: true, editable: true)
TOWNSHIP_DIRECTION (type: esriFieldTypeString, alias: TOWNSHIP_DIRECTION, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
RANGE (type: esriFieldTypeSmallInteger, alias: RANGE, SQL Type: sqlTypeOther, nullable: true, editable: true)
RANGE_DIRECTION (type: esriFieldTypeString, alias: RANGE_DIRECTION, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
SECTION (type: esriFieldTypeSmallInteger, alias: SECTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
QUARTER_CALL_1_LARGEST (type: esriFieldTypeString, alias: QUARTER_CALL_1_LARGEST, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
QUARTER_CALL_2 (type: esriFieldTypeString, alias: QUARTER_CALL_2, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
QUARTER_CALL_3 (type: esriFieldTypeString, alias: QUARTER_CALL_3, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
COMPLETION_DATE (type: esriFieldTypeDate, alias: COMPLETION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CONTRACTOR_NAME (type: esriFieldTypeString, alias: Driller, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
UPDATE_DATE (type: esriFieldTypeDate, alias: UPDATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
MONITORING_NUMBER (type: esriFieldTypeString, alias: Well ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
NAD27_LATITUDE (type: esriFieldTypeDouble, alias: Latitude (NAD27), SQL Type: sqlTypeOther, nullable: true, editable: true)
NAD27_LONGITUDE (type: esriFieldTypeDouble, alias: Longitude (NAD27), SQL Type: sqlTypeOther, nullable: true, editable: true)
LONGITUDE_LATITUDE_SOURCE (type: esriFieldTypeString, alias: LONGITUDE_LATITUDE_SOURCE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
COUNTY (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
USE_DESC (type: esriFieldTypeString, alias: Use, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
CONTRACTOR (type: esriFieldTypeString, alias: Driller, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
DEPTH_TXT (type: esriFieldTypeString, alias: Depth (ft), SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
ELEV_TXT (type: esriFieldTypeString, alias: Elevation (ft), SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
STATIC_LEVEL_TXT (type: esriFieldTypeString, alias: Static Water Level (ft), SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
YIELD_TXT (type: esriFieldTypeString, alias: Estimated Yield (gpm), SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
COMP_DATE_TXT (type: esriFieldTypeString, alias: Completion Date, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
MAPPER_DEPTH (type: esriFieldTypeDouble, alias: MAPPER_DEPTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
MAPPER_LEVEL (type: esriFieldTypeDouble, alias: MAPPER_LEVEL, SQL Type: sqlTypeOther, nullable: true, editable: true)
MAPPER_YIELD (type: esriFieldTypeDouble, alias: MAPPER_YIELD, SQL Type: sqlTypeOther, nullable: true, editable: true)
WELL_TYPE_CATEGORY (type: esriFieldTypeString, alias: WELL_TYPE_CATEGORY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
KOLAR_DOC_ID (type: esriFieldTypeInteger, alias: KOLAR_DOC_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
CONTRACTORS_LICENSE_NUMBER (type: esriFieldTypeInteger, alias: CONTRACTORS_LICENSE_NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
FILE_URL (type: esriFieldTypeString, alias: Scanned Doc, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)

Types:

TYPE_OF_ACTION_CODE: 1

TYPE_OF_ACTION_CODE: 2

TYPE_OF_ACTION_CODE: 3

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (Test_Wells)

Layers:

Layer: Water Wells WWC5 (0)