View In:   ArcGIS Online Map Viewer

Name: Idle_Well_Report

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3b30a5bd6bc24fb0ac6337027ad4e377

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -180.0
YMin: -90.0
XMax: 180.0
YMax: 90.0
Spatial Reference: 4326  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 0, 0, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 0, 255] Width: 1
Label: ODNR_Idle_Well_Report
Description: Survey Data Locations
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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 )

Templates:

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

Relationships:

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

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Ownership Based Access Control:

• Allow Others to Update: true
• Allow Others to Delete: true
• Allow Others to Query: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata