Layers:

Layer: Oil and Gas Wells (1)

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)

Tables:

Table: oil_gas_scanned_documents (5)

Name: oil_gas_scanned_documents

Display Field: file_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: c2a0c06589ec426cbbe06b2ea586fad9

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
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: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• log_id_number ( modelName: LOG_ID_NUMBER, nullable: true, editable: true, defaultValue: null, alias: Log ID Number, type: esriFieldTypeDouble )
• wa_file_number ( modelName: WA_FILE_NUMBER, nullable: true, editable: true, defaultValue: null, length: 10, alias: WA File Number, type: esriFieldTypeString )
• file_name ( modelName: FILE_NAME, nullable: true, editable: true, defaultValue: null, length: 20, alias: File Name, type: esriFieldTypeString )
• log_type_code ( modelName: LOG_TYPE_CODE, nullable: true, editable: true, defaultValue: null, length: 20, alias: Log Type Code, type: esriFieldTypeString )
• log_type ( modelName: LOG_TYPE, nullable: true, editable: true, defaultValue: null, length: 60, alias: Log Type, type: esriFieldTypeString )
• depth_datum ( modelName: DEPTH_DATUM, nullable: true, editable: true, defaultValue: null, length: 20, alias: Depth Datum, type: esriFieldTypeString )
• log_start_depth_feet ( modelName: LOG_START_DEPTH_FEET, nullable: true, editable: true, defaultValue: null, alias: Log Start Depth (feet), type: esriFieldTypeDouble )
• log_end_depth_feet ( modelName: LOG_END_DEPTH_FEET, nullable: true, editable: true, defaultValue: null, alias: Log End Depth (feet), type: esriFieldTypeDouble )
• temperature_fahrenheit ( modelName: TEMPERATURE_FAHRENHEIT, nullable: true, editable: true, defaultValue: null, alias: Temperature (degrees Fahrenheit), type: esriFieldTypeDouble )
• temperature_type ( modelName: TEMPERATURE_TYPE, nullable: true, editable: true, defaultValue: null, length: 20, alias: Temperature Type, type: esriFieldTypeString )
• time_since_circ_hrs ( modelName: TIME_SINCE_CIRC_HRS, nullable: true, editable: true, defaultValue: null, alias: Time Since Circulation (hours), type: esriFieldTypeDouble )
• fluid_type ( modelName: FLUID_TYPE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Fluid Type, type: esriFieldTypeString )
• log_date ( modelName: LOG_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Log Date, type: esriFieldTypeDate )
• comments ( modelName: COMMENTS, nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• document_url ( modelName: DOCUMENT_URL, nullable: true, editable: true, defaultValue: null, length: 255, alias: Hyperlink, type: esriFieldTypeString )
Templates:
• Name: oil_gas_scanned_documents
  Description:
  Prototype:
  fluid_type: null
  log_end_depth_feet: null
  comments: null
  file_name: null
  log_type_code: null
  depth_datum: null
  temperature_type: null
  log_id_number: null
  wa_file_number: null
  log_type: null
  log_date: null
  temperature_fahrenheit: null
  time_since_circ_hrs: null
  document_url: null
  log_start_depth_feet: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SCANDOC_TO_GEOLOILGASWELLS (0) -- Related To: Oil and Gas Wells (1)