View In:   ArcGIS Online Map Viewer

Name: Oil and Gas Wells

Display Field: well_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: These data contain point locations that represent oil and gas test well sites in Washington State from 1890 to present. Oil seeps were first reported in Washington about 1881 along the sea cliffs on the west side of the Olympic Peninsula. Natural gas seeps associated with mud cones and mounds were also reported in this same general area. Of all the exploratory wells that have been drilled in Washington to date, 249 reportied shows for oil and gas. In 1965 the Jackson Prairie natural gas storage project was developed, which remains the Northwest's largest natural gas storage facility.

Service Item Id: c2a0c06589ec426cbbe06b2ea586fad9

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 633896.999897331
YMin: 108917.0001334846
XMax: 2507482.000095159
YMax: 1340843.999857232
Spatial Reference: 2927  (2927)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [WELL_NAME]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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 )
• oil_gas_id ( modelName: OIL_GAS_ID, nullable: true, editable: true, defaultValue: null, alias: Oil and Gas ID, type: esriFieldTypeDouble )
• api_number ( modelName: API_NUMBER, nullable: true, editable: true, defaultValue: null, length: 15, alias: API Number, type: esriFieldTypeString )
• wa_file_number ( modelName: WA_FILE_NUMBER, nullable: true, editable: true, defaultValue: null, length: 10, alias: WA File Number, type: esriFieldTypeString )
• well_name ( modelName: WELL_NAME, nullable: true, editable: true, defaultValue: null, length: 60, alias: Well Name, type: esriFieldTypeString )
• alternate_names ( modelName: ALTERNATE_NAMES, nullable: true, editable: true, defaultValue: null, length: 50, alias: Alternate Names, type: esriFieldTypeString )
• company_name ( modelName: COMPANY_NAME, nullable: true, editable: true, defaultValue: null, length: 75, alias: Company Name, type: esriFieldTypeString )
• elevation_reference ( modelName: ELEVATION_REFERENCE, nullable: true, editable: true, defaultValue: null, length: 40, alias: Elevation Reference, type: esriFieldTypeString )
• elevation_feet ( modelName: ELEVATION_FEET, nullable: true, editable: true, defaultValue: null, alias: Elevation (feet), type: esriFieldTypeDouble )
• depth_feet ( modelName: DEPTH_FEET, nullable: true, editable: true, defaultValue: null, alias: Depth (feet), type: esriFieldTypeDouble )
• permit_date ( modelName: PERMIT_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Permit Date, type: esriFieldTypeDate )
• drill_start_date ( modelName: DRILL_START_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Drill Start Date, type: esriFieldTypeDate )
• date_comments ( modelName: DATE_COMMENTS, nullable: true, editable: true, defaultValue: null, length: 30, alias: Date Comments, type: esriFieldTypeString )
• drill_stop_date ( modelName: DRILL_STOP_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Drill Stop Date, type: esriFieldTypeDate )
• hydrocarbon_show ( modelName: HYDROCARBON_SHOW, nullable: true, editable: true, defaultValue: null, length: 15, alias: Hydrocarbon Show, type: esriFieldTypeString )
• township ( modelName: TOWNSHIP, nullable: true, editable: true, defaultValue: null, length: 10, alias: Township, type: esriFieldTypeString )
• range ( modelName: RANGE, nullable: true, editable: true, defaultValue: null, length: 10, alias: Range, type: esriFieldTypeString )
• section ( modelName: SECTION, nullable: true, editable: true, defaultValue: null, length: 10, alias: Section, type: esriFieldTypeString )
• location_description ( modelName: LOCATION_DESCRIPTION, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location Description, type: esriFieldTypeString )
• well_status ( modelName: WELL_STATUS, nullable: true, editable: true, defaultValue: null, length: 40, alias: Well Status, type: esriFieldTypeString )
• scanned_documents_flag ( modelName: SCANNED_DOCUMENTS_FLAG, nullable: true, editable: true, defaultValue: null, length: 10, alias: Scanned Documents Flag, type: esriFieldTypeString )
• permit_flag ( modelName: PERMIT_FLAG, nullable: true, editable: true, defaultValue: null, length: 10, alias: Permit Flag, type: esriFieldTypeString )
• comments ( modelName: COMMENTS, nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• county ( modelName: COUNTY, nullable: true, editable: true, defaultValue: null, length: 20, alias: County, type: esriFieldTypeString )
• latitude ( modelName: LATITUDE, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( modelName: LONGITUDE, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )

Templates:

• Name: Oil and Gas Wells
  Description:
  Prototype:
  depth_feet: null
  latitude: null
  county: null
  range: null
  section: null
  scanned_documents_flag: null
  wa_file_number: null
  well_name: null
  longitude: null
  drill_stop_date: null
  comments: null
  elevation_reference: null
  oil_gas_id: null
  api_number: null
  well_status: null
  location_description: null
  alternate_names: null
  date_comments: null
  company_name: null
  permit_date: null
  hydrocarbon_show: null
  elevation_feet: null
  permit_flag: null
  drill_start_date: null
  township: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• GEOLOILGASWELLS_TO_SCANDOC (0) -- Related To: oil_gas_scanned_documents (5)

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:   Field Groups   Contingent Values

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