All Layers and Tables (Hosted/ODNR_Idle_Well_Report

Layers:

Layer: Idle_Well_Report (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount:

MaxSelectionCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Supports ValidateSQL:

Supports Calculate:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Size:

Angle:

XOffset:

YOffset:

Outline:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
uniquerowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: RowID, type: esriFieldTypeGUID )
version ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Report Version, type: esriFieldTypeString , Coded Values: [initial: Initial Report] , [follow_up: Follow-Up Report] )
complaint_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Complaint Date:, type: esriFieldTypeDate )
inspection_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date of Inspection:, type: esriFieldTypeDate )
date_format ( nullable: true, editable: true, defaultValue: null, length: 255, alias: date_format, type: esriFieldTypeString )
well_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: ODNR Well Name:, type: esriFieldTypeString )
well_number ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Well Number:, type: esriFieldTypeString )
case_number ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Orphan Case Number:, type: esriFieldTypeString )
well_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Well Address:, type: esriFieldTypeString )
well_city ( nullable: true, editable: true, defaultValue: null, length: 255, alias: City:, type: esriFieldTypeString )
well_zipcode ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Zipcode:, type: esriFieldTypeString )
county ( nullable: true, editable: true, defaultValue: null, length: 255, alias: County:, type: esriFieldTypeString , Coded Values: [Allen: Allen] , [Athens: Athens] , [Auglaize: Auglaize] , ...3 more... )
township ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Township:, type: esriFieldTypeString , Coded Values: [Alexander: Alexander] , [Amanda: Amanda] , [Athens: Athens] , ...14 more... )
section_lot ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Section/Lot:, type: esriFieldTypeString )
gps_confirmed ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Professionally Surveyed?, type: esriFieldTypeString )
directions ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Directions to Well:, type: esriFieldTypeString )
compl_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Name:, type: esriFieldTypeString )
compl_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Address:, type: esriFieldTypeString )
compl_city ( nullable: true, editable: true, defaultValue: null, length: 255, alias: City:, type: esriFieldTypeString )
compl_state ( nullable: true, editable: true, defaultValue: null, length: 255, alias: State:, type: esriFieldTypeString , Coded Values: [AL: Alabama] , [AK: Alaska] , [AZ: Arizona] , ...48 more... )
compl_zipcode ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Zipcode:, type: esriFieldTypeString )
compl_phone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Phone #:, type: esriFieldTypeString )
compl_cell ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Cellphone #:, type: esriFieldTypeString )
compl_email ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Email:, type: esriFieldTypeString )
landow_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Name:, type: esriFieldTypeString )
landow_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Address:, type: esriFieldTypeString )
landow_city ( nullable: true, editable: true, defaultValue: null, length: 255, alias: City:, type: esriFieldTypeString )
landow_state ( nullable: true, editable: true, defaultValue: null, length: 255, alias: State:, type: esriFieldTypeString , Coded Values: [AL: Alabama] , [AK: Alaska] , [AZ: Arizona] , ...48 more... )
landow_zipcode ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Zipcode:, type: esriFieldTypeString )
landow_phone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Phone #:, type: esriFieldTypeString )
landow_cell ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Cellphone #:, type: esriFieldTypeString )
landow_email ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Email:, type: esriFieldTypeString )
access_road ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Acces Road Conditon:, type: esriFieldTypeString , Coded Values: [good: Good] , [poor: Poor] )
oil_tanks ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Oil Storage Tanks Present?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
oil_quantity_yes ( nullable: true, editable: true, defaultValue: null, alias: Quantity:, type: esriFieldTypeInteger )
oil_quantity_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Quantity:, type: esriFieldTypeString )
oil_size_yes ( nullable: true, editable: true, defaultValue: null, alias: Size:, type: esriFieldTypeInteger )
oil_size_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Size:, type: esriFieldTypeString )
casing ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Casing:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
casing_size_yes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Casing Sizes:, type: esriFieldTypeString )
casing_size_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Casing Sizes:, type: esriFieldTypeString )
separator ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Separator:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
tubing ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Tubing:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
tubing_size_yes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Tubing Sizes:, type: esriFieldTypeString )
tubing_size_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Tubing Sizes:, type: esriFieldTypeString )
gas_meter ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Gas Meter:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
brine_tank ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Brine Tank/Vault:, type: esriFieldTypeString , Coded Values: [aboveground: Above-ground] , [buried: Buried] , [none: None] )
rods ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Rods:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
visible_impact ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Visible Impact:, type: esriFieldTypeString , Coded Values: [oil: Oil] , [brine: Brine] , [none: None] )
well_head ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Well Head:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
odor ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Odor:, type: esriFieldTypeString , Coded Values: [gas: Natural Gas] , [sulfide: Hydrogen Sulfide] , [none: None] )
casing_hanger ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Casing Hanger:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
veg_kill ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Vegetative Kill Area:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
veg_kill_yes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Area:, type: esriFieldTypeString )
veg_kill_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Area:, type: esriFieldTypeString )
gas_escape ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Gas Escape Packer:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
well_pressure ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Pressure on Well:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
well_press_yes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Measurement:, type: esriFieldTypeString )
well_press_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Measurement:, type: esriFieldTypeString )
pumping_unit ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Pumping Unit:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
waterways ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Nearby Waterways:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
waterways_yes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Distance:, type: esriFieldTypeString )
waterways_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Distance:, type: esriFieldTypeString )
plunger ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Plunger Lift:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
obstruction ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Obstruction in Well, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
obstruction_yes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Obstruction Notes:, type: esriFieldTypeString )
obstruction_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Obstruction Notes:, type: esriFieldTypeString )
flow_line ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Visible Flow Line:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
gas_use ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Domestic Gas Use:, type: esriFieldTypeString , Coded Values: [current: Current] , [prior: Prior] , [unknown: Unknown] )
well_vault ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Well Vault and Vent:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
open_pits ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Open Pits, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
utilities ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Overhead Utilities:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
remove_trees ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Trees to be Removed:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
stream_cross ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Stream Crossing:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
water_well ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Water Well on Property:, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
water_well_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Water Well Location:, type: esriFieldTypeString )
inhabit_structures ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Inhabited Structures Near the Well (, type: esriFieldTypeString )
inhabit_dist_yes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Distance:, type: esriFieldTypeString )
inhabit_dist_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Distance:, type: esriFieldTypeString )
inhabit_dir_yes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Direction:, type: esriFieldTypeString )
inhabit_dir_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Direction:, type: esriFieldTypeString )
uninhabit_structures ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Uninhabited Structures Near the Well (, type: esriFieldTypeString )
uninhabit_dist_yes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Distance:, type: esriFieldTypeString )
uninhabit_dist_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Distance:, type: esriFieldTypeString )
uninhabit_dir_yes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Direction:, type: esriFieldTypeString )
uninhabit_dir_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Direction:, type: esriFieldTypeString )
signage ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Is signage posted at the well?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
already_pluuged ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Do records or on-site physical evidence indicate that this well was previously plugged?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
production_capable ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Is this well capable of production?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
production_current ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Is this well being currently produced?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
producer_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Producer Name:, type: esriFieldTypeString )
producer_phone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Phone Number:, type: esriFieldTypeString )
detect_gas ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Is gas detected in any way leaking from the well?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
detect_gas_yes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Describe:, type: esriFieldTypeString )
photo_count ( nullable: true, editable: true, defaultValue: null, alias: Number of Photos Taken:, type: esriFieldTypeInteger )
video ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Video Taken?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
accompany ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Accompanied to Site by:, type: esriFieldTypeString )
accomp_phone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Phone #:, type: esriFieldTypeString )
inspector_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Inspector Name:, type: esriFieldTypeString )
slctqa1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: QA Status, type: esriFieldTypeString , Coded Values: [Unchecked: Unchecked] , [Checked: Checked] )
slctchangesmade1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Were changes made to the entry?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
txtchangesmade1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Explain the changes made., type: esriFieldTypeString )
txtinitials1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: QA checker intials, type: esriFieldTypeString )
txtdate1 ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Enter date checked., type: esriFieldTypeDate )
gen_report ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Export the report?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
coordinate_format ( nullable: true, editable: true, defaultValue: null, length: 255, alias: coordinate_format, type: esriFieldTypeString )
compl_state_abb ( nullable: true, editable: true, defaultValue: null, length: 255, alias: compl_state_abb, type: esriFieldTypeString )
landow_state_abb ( nullable: true, editable: true, defaultValue: null, length: 255, alias: landow_state_abb, type: esriFieldTypeString )
field_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: CEC Field ID:, type: esriFieldTypeString )
name_for_report ( nullable: true, editable: true, defaultValue: null, length: 255, alias: name_for_report, type: esriFieldTypeString )
project_number ( nullable: true, editable: true, defaultValue: null, length: 255, alias: project_number, type: esriFieldTypeString )
report_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: report_name, type: esriFieldTypeString )
email ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Email, type: esriFieldTypeString )
output_folder ( nullable: true, editable: true, defaultValue: null, length: 255, alias: output_folder, type: esriFieldTypeString )
greenlight ( nullable: true, editable: true, defaultValue: null, length: 255, alias: greenlight, type: esriFieldTypeString )
move_point ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Moved to Survey Point?, type: esriFieldTypeString )
pin ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Parcel ID Number:, type: esriFieldTypeString )
area_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Area Name:, type: esriFieldTypeString )
ww_lat_round ( nullable: true, editable: true, defaultValue: null, alias: Water Well Coordinates:, type: esriFieldTypeDouble )
ww_long_round ( nullable: true, editable: true, defaultValue: null, alias: Water Well Coordinates:, type: esriFieldTypeDouble )
packet_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Packet Status:, type: esriFieldTypeString , Coded Values: [Complete: Complete] , [Not Complete: Not Complete] )
anomaly_category ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Anomaly Type:, type: esriFieldTypeString , Coded Values: [1: Category 1 - Ground Confirmed (GC) Well (Active)] , [2: Category 2 - Ground Confirmed (GC) Well] , [3: Category 3 - Ground Located (GL) Well-Like Anomaly] , ...2 more... )
api_no ( nullable: true, editable: true, defaultValue: null, length: 255, alias: API Number:, type: esriFieldTypeString )
lat83 ( nullable: true, editable: true, defaultValue: null, alias: Rounded, type: esriFieldTypeDouble )
long83 ( nullable: true, editable: true, defaultValue: null, alias: Rounded, type: esriFieldTypeDouble )
export ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Export Reports and Photos?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
ww_number ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Water Well Number:, type: esriFieldTypeString )
risk_eval ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Risk Evaluation:, type: esriFieldTypeString , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
void_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: void_name, type: esriFieldTypeString )
well_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Well Status:, type: esriFieldTypeString )
insp_summary ( nullable: true, editable: true, defaultValue: null, length: 500, alias: insp_summary, type: esriFieldTypeString )

Name: New Feature
Description:
Prototype:
Drawing Tool: N/A

Relationships:

ODNR_Idle_Well_Report_photo_repeat (0) -- Related To: photo_repeat (1)

Tables:

Table: photo_repeat (1)