View In:   ArcGIS Online Map Viewer

Name: Well Reports

Display Field: owner_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This is a hybrid of location sources for well reports (logs). There is one location for all reports, even if it is the same well (new, deepening, etc. may all be separate reports and will be seperate locations).Sources are in a hierarchy with the best source providing the final location. Only 25% of the reports have a latitude/longitude from a source. Most reports are located by the center of the township/range/section/quarter-quarter section or at the section level.

Service Item Id: 0b618309a923421484df022e1c50280b

Copyright Text: Oregon Water Resources Department

Default Visibility: false

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

Supports Datum Transformation: true

Extent:

XMin: -1.3895832039900074E7
YMin: 5149075.6721738
XMax: -1.2955086449832374E7
YMax: 5884000.802540802
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [217, 95, 2, 255]
Size: 4.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:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: false
Supports Query With LOD Spatial Reference: false
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 ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• wl_id ( type: esriFieldTypeInteger, alias: wl_id, editable: true, nullable: false, defaultValue: null, modelName: wl_id, required: true )
• type_of_log ( type: esriFieldTypeString, alias: type_of_log, editable: true, nullable: true, length: 50, defaultValue: null, modelName: type_of_log )
• wl_image_id ( type: esriFieldTypeInteger, alias: wl_image_id, editable: true, nullable: true, defaultValue: null, modelName: wl_image_id )
• wl_county_code ( type: esriFieldTypeString, alias: wl_county_code, editable: true, nullable: true, length: 4, defaultValue: null, modelName: wl_county_code )
• wl_nbr ( type: esriFieldTypeInteger, alias: wl_nbr, editable: true, nullable: true, defaultValue: null, modelName: wl_nbr )
• wl_version ( type: esriFieldTypeInteger, alias: wl_version, editable: true, nullable: true, defaultValue: null, modelName: wl_version )
• well_tag_nbr ( type: esriFieldTypeInteger, alias: well_tag_nbr, editable: true, nullable: true, defaultValue: null, modelName: well_tag_nbr )
• startcard_nbr ( type: esriFieldTypeInteger, alias: startcard_nbr, editable: true, nullable: true, defaultValue: null, modelName: startcard_nbr )
• owner_name ( type: esriFieldTypeString, alias: owner_name, editable: true, nullable: true, length: 250, defaultValue: null, modelName: owner_name )
• bonded_full_name ( type: esriFieldTypeString, alias: bonded_full_name, editable: true, nullable: true, length: 250, defaultValue: null, modelName: bonded_full_name )
• bonded_name_company ( type: esriFieldTypeString, alias: bonded_name_company, editable: true, nullable: true, length: 250, defaultValue: null, modelName: bonded_name_company )
• bonded_license_nbr ( type: esriFieldTypeInteger, alias: bonded_license_nbr, editable: true, nullable: true, defaultValue: null, modelName: bonded_license_nbr )
• owner_well_nbr ( type: esriFieldTypeString, alias: owner_well_nbr, editable: true, nullable: true, length: 30, defaultValue: null, modelName: owner_well_nbr )
• company_job_nbr ( type: esriFieldTypeString, alias: company_job_nbr, editable: true, nullable: true, length: 30, defaultValue: null, modelName: company_job_nbr )
• work_new ( type: esriFieldTypeString, alias: work_new, editable: true, nullable: true, length: 1, defaultValue: null, modelName: work_new )
• work_deepening ( type: esriFieldTypeString, alias: work_deepening, editable: true, nullable: true, length: 1, defaultValue: null, modelName: work_deepening )
• work_conversion ( type: esriFieldTypeString, alias: work_conversion, editable: true, nullable: true, length: 1, defaultValue: null, modelName: work_conversion )
• work_alteration ( type: esriFieldTypeString, alias: work_alteration, editable: true, nullable: true, length: 1, defaultValue: null, modelName: work_alteration )
• work_abandonment ( type: esriFieldTypeString, alias: work_abandonment, editable: true, nullable: true, length: 1, defaultValue: null, modelName: work_abandonment )
• work_other ( type: esriFieldTypeString, alias: work_other, editable: true, nullable: true, length: 50, defaultValue: null, modelName: work_other )
• depth_first_water ( type: esriFieldTypeDouble, alias: depth_first_water, editable: true, nullable: true, defaultValue: null, modelName: depth_first_water )
• post_static_water_level ( type: esriFieldTypeDouble, alias: post_static_water_level, editable: true, nullable: true, defaultValue: null, modelName: post_static_water_level )
• completed_depth ( type: esriFieldTypeDouble, alias: completed_depth, editable: true, nullable: true, defaultValue: null, modelName: completed_depth )
• casing_diameter_max ( type: esriFieldTypeDouble, alias: casing_diameter_max, editable: true, nullable: true, defaultValue: null, modelName: casing_diameter_max )
• start_date ( type: esriFieldTypeDate, alias: start_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: start_date )
• complete_date ( type: esriFieldTypeDate, alias: complete_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: complete_date )
• received_date ( type: esriFieldTypeDate, alias: received_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: received_date )
• location_county ( type: esriFieldTypeString, alias: location_county, editable: true, nullable: true, length: 4, defaultValue: null, modelName: location_county )
• tr_key ( type: esriFieldTypeString, alias: tr_key, editable: true, nullable: true, length: 25, defaultValue: null, modelName: tr_key )
• trs_key ( type: esriFieldTypeString, alias: trs_key, editable: true, nullable: true, length: 25, defaultValue: null, modelName: trs_key )
• trsqq_key ( type: esriFieldTypeString, alias: trsqq_key, editable: true, nullable: true, length: 25, defaultValue: null, modelName: trsqq_key )
• tax_lot ( type: esriFieldTypeString, alias: tax_lot, editable: true, nullable: true, length: 18, defaultValue: null, modelName: tax_lot )
• street_of_well ( type: esriFieldTypeString, alias: street_of_well, editable: true, nullable: true, length: 500, defaultValue: null, modelName: street_of_well )
• longitude_dec ( type: esriFieldTypeDouble, alias: longitude_dec, editable: true, nullable: true, defaultValue: null, modelName: longitude_dec )
• latitude_dec ( type: esriFieldTypeDouble, alias: latitude_dec, editable: true, nullable: true, defaultValue: null, modelName: latitude_dec )
• coordinate_source ( type: esriFieldTypeString, alias: coordinate_source, editable: true, nullable: true, length: 100, defaultValue: null, modelName: coordinate_source )
• est_horizontal_error ( type: esriFieldTypeDouble, alias: est_horizontal_error, editable: true, nullable: true, defaultValue: null, modelName: est_horizontal_error )
• tds_amount ( type: esriFieldTypeDouble, alias: tds_amount, editable: true, nullable: true, defaultValue: null, modelName: tds_amount )
• tds_unit ( type: esriFieldTypeString, alias: tds_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: tds_unit )
• yield_gpm ( type: esriFieldTypeDouble, alias: yield_gpm, editable: true, nullable: true, defaultValue: null, modelName: yield_gpm )
• temperature ( type: esriFieldTypeInteger, alias: temperature, editable: true, nullable: true, defaultValue: null, modelName: temperature )
• temperature_unit ( type: esriFieldTypeString, alias: temperature_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: temperature_unit )
• primary_use ( type: esriFieldTypeString, alias: primary_use, editable: true, nullable: true, length: 200, defaultValue: null, modelName: primary_use )
• deficiency_status_descr ( type: esriFieldTypeString, alias: deficiency_status_descr, editable: true, nullable: true, length: 200, defaultValue: null, modelName: deficiency_status_descr )
• well_log_url ( type: esriFieldTypeString, alias: well_log_url, editable: true, nullable: true, length: 255, defaultValue: null, modelName: well_log_url )

Templates:

• Name: Well Reports
  Description:
  Prototype:
  deficiency_status_descr: null
  well_log_url: null
  wl_id: 0
  type_of_log: null
  wl_image_id: null
  wl_county_code: null
  wl_nbr: null
  wl_version: null
  well_tag_nbr: null
  startcard_nbr: null
  owner_name: null
  bonded_full_name: null
  bonded_name_company: null
  bonded_license_nbr: null
  owner_well_nbr: null
  company_job_nbr: null
  work_new: null
  work_deepening: null
  work_conversion: null
  work_alteration: null
  work_abandonment: null
  work_other: null
  depth_first_water: null
  post_static_water_level: null
  completed_depth: null
  casing_diameter_max: null
  start_date: null
  complete_date: null
  received_date: null
  location_county: null
  tr_key: null
  trs_key: null
  trsqq_key: null
  tax_lot: null
  street_of_well: null
  longitude_dec: null
  latitude_dec: null
  coordinate_source: null
  est_horizontal_error: null
  tds_amount: null
  tds_unit: null
  yield_gpm: null
  temperature: null
  temperature_unit: null
  primary_use: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata