Name: Well Inspections (Enforcement)

Display Field: wl_nbr

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Locations for well inspections

Service Item Id: 3a0fbe30b1c048b4a6b4b48bbb71c239

Copyright Text: Oregon Water Resources Department

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000000.0

Max Scale: 100.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.3888193283737296E7
YMin: 5151226.453552051
XMax: -1.2996519877346424E7
YMax: 5817964.821710878
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: false
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: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• well_inspection_id ( type: esriFieldTypeInteger, alias: well_inspection_id )
• physical_location_id ( type: esriFieldTypeInteger, alias: physical_location_id )
• inspection_date ( type: esriFieldTypeDate, alias: inspection_date, length: 8 )
• startcard_nbr ( type: esriFieldTypeInteger, alias: startcard_nbr )
• enf_county_code ( type: esriFieldTypeString, alias: enf_county_code, length: 4 )
• enf_wl_nbr ( type: esriFieldTypeInteger, alias: enf_wl_nbr )
• wl_county_code ( type: esriFieldTypeString, alias: wl_county_code, length: 4 )
• wl_nbr ( type: esriFieldTypeInteger, alias: wl_nbr )
• startcard_nbr_on_well ( type: esriFieldTypeInteger, alias: startcard_nbr_on_well )
• well_tag_nbr_on_well ( type: esriFieldTypeInteger, alias: well_tag_nbr_on_well )
• no_log ( type: esriFieldTypeSmallInteger, alias: no_log )
• property_owner_when_drilled ( type: esriFieldTypeString, alias: property_owner_when_drilled, length: 150 )
• inspection_status ( type: esriFieldTypeString, alias: inspection_status, length: 3 )
• special_standards ( type: esriFieldTypeSmallInteger, alias: special_standards )
• title ( type: esriFieldTypeString, alias: title, length: 3 )
• inspection_purpose ( type: esriFieldTypeString, alias: inspection_purpose, length: 3 )
• witnesses ( type: esriFieldTypeString, alias: witnesses, length: 150 )
• name_owner ( type: esriFieldTypeString, alias: name_owner, length: 80 )
• street ( type: esriFieldTypeString, alias: street, length: 35 )
• city ( type: esriFieldTypeString, alias: city, length: 20 )
• state ( type: esriFieldTypeString, alias: state, length: 2 )
• zip ( type: esriFieldTypeString, alias: zip, length: 10 )
• phone_home ( type: esriFieldTypeString, alias: phone_home, length: 25 )
• phone_company ( type: esriFieldTypeString, alias: phone_company, length: 25 )
• gps_on_well ( type: esriFieldTypeSmallInteger, alias: gps_on_well )
• distance_to_well ( type: esriFieldTypeInteger, alias: distance_to_well )
• bearing_to_well ( type: esriFieldTypeInteger, alias: bearing_to_well )
• drilling_method ( type: esriFieldTypeString, alias: drilling_method, length: 3 )
• use_of_well ( type: esriFieldTypeString, alias: use_of_well, length: 3 )
• drilling_machine_on_site ( type: esriFieldTypeSmallInteger, alias: drilling_machine_on_site )
• rough_log_available ( type: esriFieldTypeSmallInteger, alias: rough_log_available )
• well_tag_remarks ( type: esriFieldTypeString, alias: well_tag_remarks, length: 500 )
• monitoring_completion_type ( type: esriFieldTypeString, alias: monitoring_completion_type, length: 3 )
• monitoring_completion_abv_grnd ( type: esriFieldTypeSmallInteger, alias: monitoring_completion_abv_grnd )
• protective_posts_in_place ( type: esriFieldTypeSmallInteger, alias: protective_posts_in_place )
• well_locked ( type: esriFieldTypeSmallInteger, alias: well_locked )
• consultant_on_site ( type: esriFieldTypeSmallInteger, alias: consultant_on_site )
• water_in_vault ( type: esriFieldTypeSmallInteger, alias: water_in_vault )
• seal_test_method_type ( type: esriFieldTypeString, alias: seal_test_method_type, length: 3 )
• samples_taken ( type: esriFieldTypeSmallInteger, alias: samples_taken )
• casing_diameter ( type: esriFieldTypeSingle, alias: casing_diameter )
• csg_above_land_surface ( type: esriFieldTypeSingle, alias: csg_above_land_surface )
• csg_gauge ( type: esriFieldTypeSingle, alias: csg_gauge )
• borehole_diameter ( type: esriFieldTypeSingle, alias: borehole_diameter )
• dedicated_measuring_tube ( type: esriFieldTypeSmallInteger, alias: dedicated_measuring_tube )
• access_port ( type: esriFieldTypeSmallInteger, alias: access_port )
• access_port_type ( type: esriFieldTypeString, alias: access_port_type, length: 3 )
• measuring_point ( type: esriFieldTypeSingle, alias: measuring_point )
• measuring_point_above_ground ( type: esriFieldTypeSmallInteger, alias: measuring_point_above_ground )
• depth_below_measuring_point_sw ( type: esriFieldTypeSingle, alias: depth_below_measuring_point_sw )
• depth_below_measuring_point_so ( type: esriFieldTypeSingle, alias: depth_below_measuring_point_so )
• tape_hold ( type: esriFieldTypeSingle, alias: tape_hold )
• tape_missing ( type: esriFieldTypeSingle, alias: tape_missing )
• tape_cut ( type: esriFieldTypeSingle, alias: tape_cut )
• water_level_measurement_status ( type: esriFieldTypeString, alias: water_level_measurement_status, length: 3 )
• water_level_measurement_method ( type: esriFieldTypeString, alias: water_level_measurement_method, length: 3 )
• cascading_water ( type: esriFieldTypeSmallInteger, alias: cascading_water )
• pump_type ( type: esriFieldTypeString, alias: pump_type, length: 3 )
• pump_make ( type: esriFieldTypeString, alias: pump_make, length: 50 )
• pump_hp ( type: esriFieldTypeInteger, alias: pump_hp )
• flowmeter_make ( type: esriFieldTypeString, alias: flowmeter_make, length: 50 )
• flowmeter_serial_nbr ( type: esriFieldTypeString, alias: flowmeter_serial_nbr, length: 50 )
• flowmeter_meter_reading ( type: esriFieldTypeString, alias: flowmeter_meter_reading, length: 50 )
• flowmeter_units ( type: esriFieldTypeString, alias: flowmeter_units, length: 3 )
• associated_water_rights ( type: esriFieldTypeString, alias: associated_water_rights, length: 100 )
• nbr_of_houses_served ( type: esriFieldTypeInteger, alias: nbr_of_houses_served )
• deficiency_remarks ( type: esriFieldTypeString, alias: deficiency_remarks, length: 500 )
• inspection_remarks ( type: esriFieldTypeString, alias: inspection_remarks, length: 500 )
• work_new ( type: esriFieldTypeSmallInteger, alias: work_new )
• work_deepening ( type: esriFieldTypeSmallInteger, alias: work_deepening )
• work_conversion ( type: esriFieldTypeSmallInteger, alias: work_conversion )
• work_alteration ( type: esriFieldTypeSmallInteger, alias: work_alteration )
• work_abandonment ( type: esriFieldTypeSmallInteger, alias: work_abandonment )
• work_existing ( type: esriFieldTypeSmallInteger, alias: work_existing )
• work_other ( type: esriFieldTypeString, alias: work_other, length: 50 )
• drill_rotary_air ( type: esriFieldTypeSmallInteger, alias: drill_rotary_air )
• drill_rotary_mud ( type: esriFieldTypeSmallInteger, alias: drill_rotary_mud )
• drill_cable ( type: esriFieldTypeSmallInteger, alias: drill_cable )
• drill_cable_mud ( type: esriFieldTypeSmallInteger, alias: drill_cable_mud )
• drill_reverse_rotary_air ( type: esriFieldTypeSmallInteger, alias: drill_reverse_rotary_air )
• drill_reverse_mud ( type: esriFieldTypeSmallInteger, alias: drill_reverse_mud )
• drill_auger ( type: esriFieldTypeSmallInteger, alias: drill_auger )
• drill_push_probe ( type: esriFieldTypeSmallInteger, alias: drill_push_probe )
• drill_hand_auger ( type: esriFieldTypeSmallInteger, alias: drill_hand_auger )
• drill_hollow_stem ( type: esriFieldTypeSmallInteger, alias: drill_hollow_stem )
• drill_sonic ( type: esriFieldTypeSmallInteger, alias: drill_sonic )
• drill_other ( type: esriFieldTypeString, alias: drill_other, length: 20 )
• use_domestic ( type: esriFieldTypeSmallInteger, alias: use_domestic )
• use_irrigation ( type: esriFieldTypeSmallInteger, alias: use_irrigation )
• use_community ( type: esriFieldTypeSmallInteger, alias: use_community )
• use_industrial ( type: esriFieldTypeSmallInteger, alias: use_industrial )
• use_livestock ( type: esriFieldTypeSmallInteger, alias: use_livestock )
• use_dewatering ( type: esriFieldTypeSmallInteger, alias: use_dewatering )
• use_monitoring ( type: esriFieldTypeSmallInteger, alias: use_monitoring )
• use_thermal ( type: esriFieldTypeSmallInteger, alias: use_thermal )
• use_injection ( type: esriFieldTypeSmallInteger, alias: use_injection )
• use_piezometer ( type: esriFieldTypeSmallInteger, alias: use_piezometer )
• use_observation ( type: esriFieldTypeSmallInteger, alias: use_observation )
• use_recovery ( type: esriFieldTypeSmallInteger, alias: use_recovery )
• use_other ( type: esriFieldTypeString, alias: use_other, length: 50 )
• bentonite_abandonment ( type: esriFieldTypeSmallInteger, alias: bentonite_abandonment )
• conductivity ( type: esriFieldTypeInteger, alias: conductivity )
• conductivity_sample_type ( type: esriFieldTypeString, alias: conductivity_sample_type, length: 3 )
• measurement_remarks ( type: esriFieldTypeString, alias: measurement_remarks, length: 500 )
• well_tag_nbr ( type: esriFieldTypeInteger, alias: well_tag_nbr )
• bonded_license_nbr ( type: esriFieldTypeInteger, alias: bonded_license_nbr )
• unbonded_license_nbr ( type: esriFieldTypeInteger, alias: unbonded_license_nbr )
• bonded_driller_name ( type: esriFieldTypeString, alias: bonded_driller_name, length: 150 )
• unbonded_driller_name ( type: esriFieldTypeString, alias: unbonded_driller_name, length: 150 )
• county_code ( type: esriFieldTypeString, alias: county_code, length: 4 )
• tax_lot ( type: esriFieldTypeString, alias: tax_lot, length: 18 )
• township ( type: esriFieldTypeSingle, alias: township )
• township_char ( type: esriFieldTypeString, alias: township_char, length: 1 )
• range ( type: esriFieldTypeSingle, alias: range )
• range_char ( type: esriFieldTypeString, alias: range_char, length: 1 )
• sctn ( type: esriFieldTypeInteger, alias: sctn )
• qtr40 ( type: esriFieldTypeString, alias: qtr40, length: 2 )
• qtr160 ( type: esriFieldTypeString, alias: qtr160, length: 2 )
• latitude_dec ( type: esriFieldTypeDouble, alias: latitude_dec )
• longitude_dec ( type: esriFieldTypeDouble, alias: longitude_dec )
• gps_horizontal_err ( type: esriFieldTypeDouble, alias: gps_horizontal_err )
• year_constructed ( type: esriFieldTypeInteger, alias: year_constructed )
• date_construction_started ( type: esriFieldTypeDate, alias: date_construction_started, length: 8 )
• date_construction_ended ( type: esriFieldTypeDate, alias: date_construction_ended, length: 8 )
• deficiencies ( type: esriFieldTypeString, alias: deficiencies, length: 2 )
• previous_inspection ( type: esriFieldTypeSmallInteger, alias: previous_inspection )
• inspected_by ( type: esriFieldTypeString, alias: inspected_by, length: 219 )
• wm_region ( type: esriFieldTypeString, alias: wm_region, length: 2 )
• well_tag_attach_method ( type: esriFieldTypeString, alias: well_tag_attach_method, length: 80 )
• depth ( type: esriFieldTypeSingle, alias: depth )
• static_water_level ( type: esriFieldTypeSingle, alias: static_water_level )
• status_of_well ( type: esriFieldTypeString, alias: status_of_well, length: 15 )
• location_remarks ( type: esriFieldTypeString, alias: location_remarks, length: 80 )
• site_visit ( type: esriFieldTypeSmallInteger, alias: site_visit )
• type_of_log ( type: esriFieldTypeString, alias: type_of_log, length: 1 )
• casing_cap ( type: esriFieldTypeString, alias: casing_cap, length: 3 )
• pictures_taken ( type: esriFieldTypeSmallInteger, alias: pictures_taken )
• street_of_well_driller ( type: esriFieldTypeString, alias: street_of_well_driller, length: 70 )
• street_of_well_inspection ( type: esriFieldTypeString, alias: street_of_well_inspection, length: 70 )
• last_updt_date ( type: esriFieldTypeDate, alias: last_updt_date, length: 8 )
• last_updt_userid ( type: esriFieldTypeString, alias: last_updt_userid, length: 20 )
• rec_creation_date ( type: esriFieldTypeDate, alias: rec_creation_date, length: 8 )
• rec_creation_userid ( type: esriFieldTypeString, alias: rec_creation_userid, length: 20 )
• get_well_log ( type: esriFieldTypeString, alias: get_well_log, length: 125 )
• inspection_date_int ( type: esriFieldTypeInteger, alias: inspection_date_int )
• trsqq_key ( type: esriFieldTypeString, alias: trsqq_key, length: 103 )
• use_description ( type: esriFieldTypeString, alias: use_description, length: 200 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata