View In:   ArcGIS Online Map Viewer

Name: Integrated_Public_Wells_ForWebApp_Aug26

Display Field: wells_source_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The Integrated_Public_Wells feature class is a fully integrated well dataset with all values in numerical columns, such as depth, converted into numbers. This version has a WELLS derived API (American Petroleum Institute) number column, as well as redundancy handling to provide a single record for every unique API number.

Service Item Id: c822d9b1fcc849c19812eb43fecafc35

Copyright Text: Isabelle Pfander, Lucy Romeo, Michael Sabbatino, Daniel Addokwei Tetteh, Casey Cleaveland , Megan Rich, Christian Nelson, Maneesh Sharma, Daniel C Amrine, Jennifer Bauer, Kelly Rose, WELLS Database, 9/2/2026, https://edx.netl.doe.gov/dataset/wells_database ,DOI:10.18141/1964068

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.98474172607E7
YMin: 0.23149999976158142
XMax: -2.2600000016391277
YMax: 1.6112631076899998E7
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [76, 230, 0, 255]
Size: 2.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• wells_derived_api ( modelName: wells_derived_api, nullable: true, editable: true, defaultValue: null, length: 200, alias: WELLS_DERIVED_API, type: esriFieldTypeString )
• wells_source_id ( modelName: wells_source_id, nullable: true, editable: true, defaultValue: null, length: 32000, alias: WELLS_source_id, type: esriFieldTypeString )
• wells_source_name ( modelName: wells_source_name, nullable: true, editable: true, defaultValue: null, length: 300, alias: WELLS_source_name, type: esriFieldTypeString )
• wells_source_reference ( modelName: wells_source_reference, nullable: true, editable: true, defaultValue: null, length: 2000, alias: WELLS_source_reference, type: esriFieldTypeString )
• wells_source_url ( modelName: wells_source_url, nullable: true, editable: true, defaultValue: null, length: 400, alias: WELLS_source_url, type: esriFieldTypeString )
• point_x ( modelName: point_x, nullable: true, editable: true, defaultValue: null, alias: point_x, type: esriFieldTypeDouble )
• point_y ( modelName: point_y, nullable: true, editable: true, defaultValue: null, alias: point_y, type: esriFieldTypeDouble )
• spud_date ( modelName: spud_date, nullable: true, editable: true, defaultValue: null, length: 200, alias: Spud_Date, type: esriFieldTypeString )
• operator ( modelName: operator, nullable: true, editable: true, defaultValue: null, length: 6000, alias: Operator, type: esriFieldTypeString )
• well_name ( modelName: well_name, nullable: true, editable: true, defaultValue: null, length: 300, alias: Well_Name, type: esriFieldTypeString )
• status_category ( modelName: status_category, nullable: true, editable: true, defaultValue: null, length: 200, alias: Status_Category, type: esriFieldTypeString )
• type_category ( modelName: type_category, nullable: true, editable: true, defaultValue: null, length: 300, alias: Type_Category, type: esriFieldTypeString )
• wellbore_type ( modelName: wellbore_type, nullable: true, editable: true, defaultValue: null, length: 400, alias: Wellbore_Type, type: esriFieldTypeString )
• true_vertical_depth ( modelName: true_vertical_depth, nullable: true, editable: true, defaultValue: null, alias: True_Vertical_Depth, type: esriFieldTypeDouble )
• measured_depth ( modelName: measured_depth, nullable: true, editable: true, defaultValue: null, length: 400, alias: Measured_Depth, type: esriFieldTypeString )
• permit_number ( modelName: permit_number, nullable: true, editable: true, defaultValue: null, length: 200, alias: Permit_Number, type: esriFieldTypeString )
• field ( modelName: field, nullable: true, editable: true, defaultValue: null, length: 200, alias: Field, type: esriFieldTypeString )
• orientation_category ( modelName: orientation_category, nullable: true, editable: true, defaultValue: null, length: 200, alias: Orientation_Category, type: esriFieldTypeString )
• permit_category ( modelName: permit_category, nullable: true, editable: true, defaultValue: null, length: 200, alias: Permit_Category, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: null, length: 100, alias: State, type: esriFieldTypeString )
• stateabbr ( modelName: stateabbr, nullable: true, editable: true, defaultValue: null, length: 2, alias: State Abbreviation, type: esriFieldTypeString )
• county ( modelName: county, nullable: true, editable: true, defaultValue: null, length: 100, alias: County, type: esriFieldTypeString )
• county_state ( modelName: county_state, nullable: true, editable: true, defaultValue: null, length: 255, alias: County and State, type: esriFieldTypeString )
• basin ( modelName: basin, nullable: true, editable: true, defaultValue: null, length: 255, alias: Basin Name, type: esriFieldTypeString )
• wellstatus_forwebapp ( modelName: wellstatus_forwebapp, nullable: true, editable: true, defaultValue: null, length: 512, alias: Well Status (For Web App Only), type: esriFieldTypeString )
• welltype_forwebapp ( modelName: welltype_forwebapp, nullable: true, editable: true, defaultValue: null, length: 512, alias: Well Type (For Web App Only), type: esriFieldTypeString )
• tvd_range ( modelName: tvd_range, nullable: true, editable: true, defaultValue: null, length: 255, alias: True Vertical Depth Range, type: esriFieldTypeString )
• tvd_range_forwebapp ( modelName: tvd_range_forwebapp, nullable: true, editable: true, defaultValue: null, length: 255, alias: True Vertical Depth Range (For Web App Only), type: esriFieldTypeString )
• spuddate_year ( modelName: spuddate_year, nullable: true, editable: true, defaultValue: null, alias: SpudDate_Year, type: esriFieldTypeSmallInteger )
• spudyear_range ( modelName: spudyear_range, nullable: true, editable: true, defaultValue: null, length: 255, alias: Spud Year Range, type: esriFieldTypeString )
• spudyear_range_forwebapp ( modelName: spudyear_range_forwebapp, nullable: true, editable: true, defaultValue: null, length: 255, alias: Spud Year Range (For Web App Only), type: esriFieldTypeString )

Templates:

• Name: Integrated_Public_Wells_ForWebApp_Aug26
  Description:
  Prototype:
  measured_depth: null
  permit_number: null
  county: null
  county_state: null
  wells_source_name: null
  wells_source_url: null
  true_vertical_depth: null
  operator: null
  wellbore_type: null
  welltype_forwebapp: null
  point_y: null
  permit_category: null
  point_x: null
  state: null
  wells_source_id: null
  well_name: null
  tvd_range_forwebapp: null
  wells_source_reference: null
  type_category: null
  wells_derived_api: null
  spud_date: null
  orientation_category: null
  basin: null
  tvd_range: null
  stateabbr: null
  status_category: null
  field: null
  spuddate_year: null
  wellstatus_forwebapp: null
  spudyear_range: null
  spudyear_range_forwebapp: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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