Layer: Copy_Agricultural_Pollution_Control_Farm

View In: Map Viewer

Name: Copy_Agricultural_Pollution_Control_Farm_Inspections

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Copy Agricultural Pollution Control Farm Inspections","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field: globalid

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
Site_name (type: esriFieldTypeString, alias: Site Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CRN (type: esriFieldTypeString, alias: CRN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CPH (type: esriFieldTypeString, alias: CPH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Local_Authority (type: esriFieldTypeString, alias: Local Authority, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Blaenau Gwent - Blaenau Gwent: Blaenau Gwent - Blaenau Gwent], [Caerffili - Caerphilly: Caerffili - Caerphilly], [Merthyr Tudful - Merthyr Tydfil: Merthyr Tudful - Merthyr Tydfil], ... 19 more ...)
Correspondance_via_email (type: esriFieldTypeString, alias: Correspondance via email?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Visit_Contact (type: esriFieldTypeString, alias: Visit Contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Post_Visit_Contact (type: esriFieldTypeString, alias: Post Visit Contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Tel_Mobile (type: esriFieldTypeString, alias: Tel/Mobile, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Hostile_Site (type: esriFieldTypeString, alias: Hostile Site?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Disease_Status (type: esriFieldTypeString, alias: Disease Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [TB: TB], [Avian Influenza: Avian Influenza], ... 2 more ...)
Disease_Status_Other (type: esriFieldTypeString, alias: Disease Status comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Inspected_by (type: esriFieldTypeString, alias: Inspected by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Nicola Mills: Nicola Mills], [Kelly Gurney: Kelly Gurney], [Andrew Williams: Andrew Williams], ... 14 more ...)
Accompanied_by (type: esriFieldTypeString, alias: Accompanied by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Date_Time_of_Inspection (type: esriFieldTypeDate, alias: Date and Time of Inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Inspection_Completion_Time (type: esriFieldTypeString, alias: Time taken to complete inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Previous_NRW_EAW_Engagement (type: esriFieldTypeString, alias: Previous NRW/EAW Engagement, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Raining: Raining], [Showers: Showers], [Windy: Windy], ... 3 more ...)
Rainfall_mm (type: esriFieldTypeString, alias: Rainfall (mm), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
River_Name (type: esriFieldTypeString, alias: WFD Waterbody, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Main_Catchment (type: esriFieldTypeString, alias: Main Catchment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Groundwater_Vulnerability_Classification (type: esriFieldTypeString, alias: Groundwater Vulnerability Classification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [High: High], [Medium: Medium], [Low: Low])
Source_Protection_Zone (type: esriFieldTypeString, alias: Source Protection Zone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Other_Pre_Visit_Notes (type: esriFieldTypeString, alias: Other relevant information to note from pre visit checks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Business_structure (type: esriFieldTypeString, alias: Buiness Structure, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Sole Trader: Sole Trader], [Partnerhsip: Partnerhsip], [Ltd Company: Ltd Company])
Trading_as (type: esriFieldTypeString, alias: Trading as, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Owned_Land_Hectarage (type: esriFieldTypeDouble, alias: Owned Land Hectarage, SQL Type: sqlTypeOther, nullable: true, editable: true)
Rented_Land_Hectarage (type: esriFieldTypeDouble, alias: Rented Land Hectarage, SQL Type: sqlTypeOther, nullable: true, editable: true)
Common_land_inlcuded (type: esriFieldTypeString, alias: Does the farmed area include any common land?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Farm_assurance_schemes (type: esriFieldTypeString, alias: Is the farm a member of any Farm Assurance Schemes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [FAWL: FAWL], [RT: RT], [Soil Association: Soil Association], ... 2 more ...)
FAS_number (type: esriFieldTypeString, alias: Farm assurance scheme number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Land_management_agreements (type: esriFieldTypeString, alias: Does the farm operate under any land management agreements, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
LMA_details (type: esriFieldTypeString, alias: LMA details, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Farm_type (type: esriFieldTypeString, alias: Farm Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Beef: Beef], [Sheep: Sheep], [Dairy: Dairy], ... 4 more ...)
Main_farm_enterprise (type: esriFieldTypeString, alias: Main Farm Enterprise, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Dairy: Dairy], [Beef: Beef], [Poultry: Poultry], ... 4 more ...)
Other_enterprises (type: esriFieldTypeString, alias: Other Enterprises, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Crops_grown (type: esriFieldTypeString, alias: Crops grown, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
more_than_20m3_water_day_abs (type: esriFieldTypeString, alias: Does the farm abstract more then 20m³ of water a day?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Water_abstraction_licence (type: esriFieldTypeString, alias: Do they have a licence?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Licence_number (type: esriFieldTypeString, alias: Licence Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
WG_funded_agri_scheme (type: esriFieldTypeString, alias: Is the buisness currently in a WG funded agri scheme ?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Registered_with_Farming_Connect (type: esriFieldTypeString, alias: Are you registered with Farming Connect?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Help_via_Farming_Connect (type: esriFieldTypeString, alias: Have you accessed help through Farming Connect?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Farming_Connect_Support (type: esriFieldTypeString, alias: Farming Connect Support Details, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Up_to_date_Drainage_Plan (type: esriFieldTypeString, alias: Is there an up to date drainage plan?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Yards_Generating_Slurry (type: esriFieldTypeString, alias: Have all yards generating slurry been identified?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Roof_water_discharge (type: esriFieldTypeString, alias: Does any roof water discharge onto slurry generating yards?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Solid_manure_storage (type: esriFieldTypeString, alias: Is solid manure (FYM) stored on the yards?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Slurry_contained (type: esriFieldTypeString, alias: Is slurry contained?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Woodchip_corral_standoff_pad (type: esriFieldTypeString, alias: Is there a woodchip corral or standoff pad on site?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Woodchip corral: Woodchip corral], [Standoff pad: Standoff pad], [None: None], ... 1 more ...)
Standoff_Pad (type: esriFieldTypeString, alias: Is the standoff pad drainage satisfactory?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Dimensions_Yard_Slurry_Areas (type: esriFieldTypeString, alias: Dimensions of yard areas generating slurry, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Containment_Slurry (type: esriFieldTypeString, alias: Is slurry generated contained?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Farm_Slurry_Calculation (type: esriFieldTypeString, alias: Has all slurry generated been included in farm slurry calculation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Yard_Drainage (type: esriFieldTypeString, alias: Is yard drainage satisfactory?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Yards_mitigation_measures (type: esriFieldTypeString, alias: Mitigation measures (yards) and date required by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Livestock_manures_WH_limit (type: esriFieldTypeString, alias: What is the whole holding limit for livestock manures?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Livestock_numbers (type: esriFieldTypeString, alias: All livestock numbers recorded as required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
WH_N_Limit_calculated (type: esriFieldTypeString, alias: Has the Whole holding N limit been calculated including produced, imports and exports?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
WH_livestock_manure_compliant (type: esriFieldTypeString, alias: Is the farm compliant with the Whole Holding livestock manure limit?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
WH_Mitigation_measures (type: esriFieldTypeString, alias: Whole Holding mitigation measures, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Produce_SOM_Slurry (type: esriFieldTypeString, alias: Does the farm produce solid organic manure/slurry?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Store_SOM_Slurry (type: esriFieldTypeString, alias: Does the farm store solid organic manure/slurry?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Import_SOM_Slurry (type: esriFieldTypeString, alias: Does the farm import solid organic manure/slurry?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Export_Som_Slurry (type: esriFieldTypeString, alias: Does the farm export solid organic manure/slurry?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Tem_OM_Field_Sites (type: esriFieldTypeString, alias: Are temporary organic manure field sites marked on risk map?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [NA: N/A])
Parlour_washings (type: esriFieldTypeString, alias: Parlour washings, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Temp_Field_Heaps_CoAPR_Compliant (type: esriFieldTypeString, alias: Do temporary field heaps comply with CoAPR requirements?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [NA: N/A])
Temp_silage_made_stored (type: esriFieldTypeString, alias: Is silage made and / or stored on this farm?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Info (type: esriFieldTypeString, alias: Record details of all constructed silage clamps, effluent tanks, slurry( as defined) lagoons and reception pits, parlour washings/washwater water solid organic manure stores, silage bales and field silage stores. For type of facility, e.g. constructed FYM store, weeping wall, underground effluent tank, steel "tin tank", prefab concrete lagoon, clay-lined lagoon, silage clamp, silage bales, field silage, etc. Please use the Slurry Calculator CoAPR to calculate and record storage capacity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Guidance (type: esriFieldTypeString, alias: Please click the + to create a record for each storage location / structure., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Parlour_washings_vol (type: esriFieldTypeString, alias: Parlour washings volume - high or low hose, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Low_rate_irrigation (type: esriFieldTypeString, alias: Low rate irrigation used to spread washings, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Sl_si_sm_stores_compliant (type: esriFieldTypeString, alias: Are the slurry stores/reception pits, silage clamps and solid manure stores CoAPR compliant?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Sl_storage_period_compliant (type: esriFieldTypeString, alias: Is the farm compliant with the slurry storage period capacity and associated record keeping requirements?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
SM_rec_requirements_compliant (type: esriFieldTypeString, alias: Is the farm compliant with the solid manure record keeping requirements?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Mitigation_Si_Sl_SM_facilities (type: esriFieldTypeString, alias: Mitigation measures for silage, slurry, and solid organic manure facilities, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Comments (type: esriFieldTypeString, alias: Comments/notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Spreading_risk_map (type: esriFieldTypeString, alias: Has the farm produced a spreading risk map as required by CoAPR?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Surface_water_nitrogen_risk (type: esriFieldTypeString, alias: Has the farmer assessed the risk of nitrogen fertiliser getting into surface water?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Spreading_controls_aware (type: esriFieldTypeString, alias: Is the farmer aware of all the spreading controls?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Spreading_controls_complaint (type: esriFieldTypeString, alias: Is the farmer compliant with all the spreading controls?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Spreading_mitigation_measures (type: esriFieldTypeString, alias: Spreading controls mitigation measures and date required by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
twelve_month_period_check (type: esriFieldTypeString, alias: Which 12 month period checked?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Fields_assessed (type: esriFieldTypeString, alias: Number of fields assessed (min 10%), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Organic_manure_high_m (type: esriFieldTypeString, alias: Does the farm spread organic manure with high available N?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Written_nitrogen_plan (type: esriFieldTypeString, alias: Is there a written nitrogen plan?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
exemption_requirement_SFM (type: esriFieldTypeString, alias: Does the farm meet the exemption requirements for recording spreading of fertilising materials?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
N_plan_meet_CoAPR_requirements (type: esriFieldTypeString, alias: Does the N plan and applications records as supplied meet the CoAPR requirements as detailed in checklist, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Optimum_N (type: esriFieldTypeString, alias: Has optimum N for crops been calculated accurately, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Compliant_250kgha_limit (type: esriFieldTypeString, alias: Is the farm compliant with the 250kg/ha field limit?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Compliant_max_N_limits (type: esriFieldTypeString, alias: Is the farm compliant with the maximum N limits ?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Complaint_MF_closed_period (type: esriFieldTypeString, alias: Is the farm compliant with the manufactured fertiliser closed period ?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Compliant_high_N_RAN (type: esriFieldTypeString, alias: Is the farm compliant with the high readily available N (RAN) closed period, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [NA: N/A])
Compliant_limits_high_RAN (type: esriFieldTypeString, alias: Is the farm compliant with the limits immediately following the high RAN closed period?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [NA: N/A])
N_plan_mitigation_measures (type: esriFieldTypeString, alias: Mitigation measures for N plan, field limit, maximum N , closed periods and associated records and date required by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Stock_info (type: esriFieldTypeString, alias: Please create a new record for each Stock Type or Sub Stock Type by clicking the + at the bottom of the stock category questions, on the righthand side of the page, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Submit_form (type: esriFieldTypeString, alias: Please click the ✓ in the bottom righthand side of the form to save your form, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Inspection (type: esriFieldTypeString, alias: After saving your form, click the link below to start your Farm Inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Link1 (type: esriFieldTypeString, alias: Link1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Relationships:

Copy_Agricultural_Pollution_Control_Farm_Inspections_Storage_structure (1) -- Related To: Storage_structure (1)
Copy_Agricultural_Pollution_Control_Farm_Inspections_Stock_categories (2) -- Related To: Stock_categories (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/4/2025 10:41:49 AM

Schema Last Edit Date: 5/21/2025 9:46:28 AM

Data Last Edit Date: 6/4/2025 10:41:49 AM

Supported Operations: Add Features Apply Edits Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: Copy_Agricultural_Pollution_Control_Farm_Inspections (ID:0)