Compliance Monitoring Database (IRIS)


File ID: 7A497527-ECFE-4E1C-92DA-6E788302D658
Hierarchy Level: dataset
Abstract: All Compliance Monitoring Sites (Regimes) in the Waikato Region. This layer comprises only IRIS data.
Statement: The compliance monitoring layer contains all compliance monitoring regimes (also referred to as sites) in the Waikato Region. The layer is constructed using IRIS data. All regimes are presented in the layer, including those that have been closed (Status = complete). In addition to high level regime attributes the layer provides regime contact details (both the owner and emergency contact details), a summary statement of compliance, and information on monitoring activities planned by the Resource Use directorate for the current financial year.
Keywords: Authorisation,Compliance,IRIS,Monitoring
Topic Category: location:positional information and services
Resource Reference Date: 24/07/2015
Metadata URL: https://data.waikatoregion.govt.nz:8443/ords/f?p=140:12:0::NO::P12_METADATA_ID:4049

Responsible Parties

Role: owner
Position:
Organisation: Waikato Regional Council
Delivery Point: 160 Ward Street
City: Hamilton Central
Postal Code: 3204
Country: New Zealand
Phone:
Fax:
Email:

Metadata

Language: English
Character Set: utf8
Standard: ANZLIC
Standard Version: 1.1

Metadata Constraints

Access Constraints: copyright
Use Constraints: copyright

Download Links

URLFormatNotes

Supporting Information Links

URLFormatNotes

General Notes:

COMPLIANCE.sdeadmin.COMPLIANCE_MONITORING_BLOCK_HR

 
File Identifier: 64F7EAFD-D1D3-2630-E055-000000000001 Parent Identifier: 7A497527-ECFE-4E1C-92DA-6E788302D658
Hierarchy Level: feature Hierarchy Level Name:Feature of Compliance Monitoring Database (IRIS)
Abstract: Geographical areas used to group compliance monitoring sites (regimes) into blocks that align to the 74 Healthy Rivers Wai Ora sub-catchments within the catchment area.
Statement: The compliance monitoring blocks have been digitised to align to the Healthy Rivers Wai Ora catchment. Strategic areas have been aligned to the 4 river FMUs while the operational areas have been aligned to the 74 Healthy Rivers Wai Ora sub-catchments. Outside of the Healthy Rivers Wai Ora catchment the blocks have been divided into strategic areas using REC catchments and further split into operational areas using geographic features identified using Topo50 images. Base data used to create compliance monitoring blocks is 1:50,000 scale data; therefore this layer inherits that level of implied geographic accuracy. The compliance monitoring layer contains all compliance monitoring regimes (also referred to as sites) in the Waikato Region. The layer is constructed using IRIS data contained in GIS_ALL.COMPLIANCE_MONITORING_IRIS. All regimes are presented in the layer, including those that have been closed (Status = complete). In addition to high level regime attributes the layer provides regime contact details (both the owner and emergency contact details), a summary statement of compliance, and information on monitoring activities planned by the Resource Use directorate for the current financial year.
Other Information: The business rules that apply to the layer are contained in DM#3344828
Keywords: Farm,Healthy Rivers,Monitoring
Topic Category: boundaries:legal land descriptions
Resource Reference Date: 26/03/2018

Metadata Constraints

Access Constraints: copyright
Use Constraints: copyright

Maintenance Information

Maintenance frequency: asNeeded
Last Load Date: 26/03/2018

Spatial Representation Information

Recommended Scale: 1:50,000
Reference System: EPSG2193
Spatial Representation Type: vector

VectorGridGeographic Bounding Box
GeometricObjectType : surface
geometricObjectCount : 92
topologyLevel : geometryOnly
Number of Dimensions : 2
Cell Geometry :
Transformation Param Available : N
westBoundLongitude : 1906113.6494
eastBoundLongitude : 1740273.901
southBoundLatitude : 5646087.3429
northBoundLatitude : 5961470.1796

Responsible Parties

Role: owner
Position:
Organisation: Waikato Regional Council
Delivery Point: 160 Ward Street
City: Hamilton Central
Postal Code: 3204
Country: New Zealand
Phone:
Fax:
Email:

Data Constraints

Data Access Constraints : copyright
Data Use Constraints: copyright
Data Distribution: Third party, internal permission
Licence Type : To be determined
Licence:
Licence Expiry:
Licence Conditions:
Copyright : © Waikato Regional Council Compliance Monitoring Database (IRIS)2018 Data.
Data Disclaimers : The standard Waikato Regional Council Disclaimer applies to this data “While Waikato Regional Council has exercised all reasonable skill and care in controlling the contents of this information, Waikato Regional Council accepts no liability in contract, tort or otherwise howsoever, for any loss, damage, injury or expense (whether direct, indirect or consequential) arising out of the provision of this information or its use by you.”
Data Use Limits : .

Download Links

URLFormatNotes

Supporting Information Links

URLFormatNotes

General Notes:

Attribute Information

NameDescriptionNotesRestrictedPrimary Key
FARM_BLOCK_STRATEGIC Farm block name at the strategic level. N N
FARM_BLOCK_OPERATIONAL Farm block name at the operational level. N N
HR_PRIORITY_RANK Healthy Rivers Wai Ora sub-catchment priority rank. N N
HR_CATCHMENT_ID Healthy Rivers Wai Ora unique sub-catchment ID N N
HR_CATCHMENT_NAME Healthy Rivers Wai Ora sub-catchment name. N N
ID Unique primary key ID. N Y
GEOMETRY Geometry type. N Y

COMPLIANCE.sdeadmin.COMPLIANCE_MONITORING_IRIS

 
File Identifier: 9CE4A7E9-1C8C-49F1-8D69-FD3A6AF25064 Parent Identifier: 7A497527-ECFE-4E1C-92DA-6E788302D658
Hierarchy Level: feature Hierarchy Level Name:Feature of Compliance Monitoring Database (IRIS)
Abstract: All Compliance Monitoring Sites (Regimes) in the Waikato Region. This layer comprises only IRIS data.
Statement: The compliance monitoring layer contains all compliance monitoring regimes (also referred to as sites) in the Waikato Region. The layer is constructed using IRIS data. All regimes are presented in the layer, including those that have been closed (Status = complete). In addition to high level regime attributes the layer provides regime contact details (both the owner and emergency contact details), a summary statement of compliance, and information on monitoring activities planned by the Resource Use directorate for the current financial year.
Other Information: The business rules that apply to the layer are contained in DM#3344828 GIS_ALL.COMPLIANCE_MONITORING_IRIS is a view of materialised view GIS_DATASTORE.COMPLIANCE_MONITORING_IRIS_MV2 which is updated daily at approx 4:30am see also doc: 15999929 This was provided by Herbert M 07/03/2024 and details info on addition of new attributes in 2023 and 2024.
Keywords: Authorisation,Compliance,IRIS,Monitoring
Topic Category: location:positional information and services
Resource Reference Date: 24/07/2015

Metadata Constraints

Access Constraints: copyright
Use Constraints: copyright

Maintenance Information

Maintenance frequency: daily
Last Load Date: 15/09/2023

Spatial Representation Information

Recommended Scale:
Reference System: EPSG2193
Spatial Representation Type: vector

VectorGridGeographic Bounding Box
GeometricObjectType : point
geometricObjectCount : 9739
topologyLevel : geometryOnly
Number of Dimensions : 2
Cell Geometry :
Transformation Param Available : N
westBoundLongitude : 1904207.2727
eastBoundLongitude : 1463057
southBoundLatitude : 5648841
northBoundLatitude : 5962282

Responsible Parties

Role:
Position:
Organisation: Waikato Regional Council
Delivery Point: 160 Ward Street
City: Hamilton Central
Postal Code: 3204
Country: New Zealand
Phone:
Fax:
Email:

Data Constraints

Data Access Constraints : copyright
Data Use Constraints: copyright
Data Distribution: Third party, internal permission
Licence Type : To be determined
Licence:
Licence Expiry:
Licence Conditions:
Copyright : © Waikato Regional Council Compliance Monitoring Database (IRIS)2015 - 2018 Data.
Data Disclaimers : The standard Waikato Regional Council Disclaimer applies to this data “While Waikato Regional Council has exercised all reasonable skill and care in controlling the contents of this information, Waikato Regional Council accepts no liability in contract, tort or otherwise howsoever, for any loss, damage, injury or expense (whether direct, indirect or consequential) arising out of the provision of this information or its use by you.”
Data Use Limits : .

Download Links

URLFormatNotes

Supporting Information Links

URLFormatNotes

General Notes:

Attribute Information

NameDescriptionNotesRestrictedPrimary Key
ID N Y
IRISID N N
IRISOBJECTID N N
FILENO N N
REGIME_NAME N N
REGIME_OFFICER N N
REGIME_OWNER N N
REGIME_EMERGENCY_CONTACT N N
REGIME_CLASSIFICATION N N
REGIME_STATUS N N
COMPLIANCEMONITORINGSUMMARY N N
COMPLIANCE_DOCUMENTS N N
CURRENT_RA_IRISID N N
CURRENT_RA_SUBTYPE N N
CURRENT_RA_OFFICER N N
CURRENT_RA_PRIORITY N N
CURRENT_RA_TEAM N N
CURRENT_RA_STATUS N N
CURRENT_RA_COMPLIANCE N N
CURRENT_RA_TYPE N N
CURRENT_RA_FOCUS_AREA N N
CURRENT_RA_FOCUS_AREA_REASON N N
PRIOR_RA_FINANCIAL_YEAR N N
PRIOR_RA_COMPLIANCE_STATUS N N
LATEST_OBSERVATION_DATE N N
LATEST_OBSERVATION_TYPE N N
LATEST_OBSERVATION_WORST_COMP N N
INDUSTRY N N
INDUSTRIES N N
DAIRY_HIGH_RISK_INITIAL N N
DAIRY_HIGH_RISK_CURRENT N N
DAIRY_WINTER_MILKING N N
LATEST_OBSERVATION_WORST_COMPLIANCE N N
DAIRY_LAST_EFFLUENT_ASSESSMENT N N
LOCATION_IRISID N N
LOCATION_ACCURACY N N
NZTM_EASTING N N
NZTM_NORTHING N N
JMA_AREA N N
GEOMETRY N N
GDB_GEOMATTR_DATA N N

COMPLIANCE.sdeadmin.COMPLIANCE_MONITORING_IRISLINK

 
File Identifier: 6923610B-0675-42A8-E055-000000000001 Parent Identifier: 7A497527-ECFE-4E1C-92DA-6E788302D658
Hierarchy Level: feature Hierarchy Level Name:Feature of Compliance Monitoring Database (IRIS)
Abstract: Contains all the relationships between compliance monitoring sites and authorisations. Achieved through a join between COMPLIANCE_MONITORING_IRIS and AUTHORISATION_IRIS via IRIS_REGIME_ACTIVITYOBJ_LINK.
Statement: The compliance monitoring layer contains all compliance monitoring regimes (also referred to as sites) in the Waikato Region. The layer is constructed using IRIS data. All regimes are presented in the layer, including those that have been closed (Status = complete). In addition to high level regime attributes the layer provides regime contact details (both the owner and emergency contact details), a summary statement of compliance, and information on monitoring activities planned by the Resource Use directorate for the current financial year. The join structure between compliance monitoring, the link table and authorisations is as follows: One-to-many join between compliance monitoring (left) and the link table (right). One-to-many join between the link table (left) and authorisations (right). This results in an output where all rows in the compliance monitoring table are retained and only those rows in authorisations are retained that have a successful join to compliance monitoring. This layer contains duplicates of regimes where more than one authorisation has a relationship with the compliance monitoring site.
Other Information: The business rules that apply to the layer are contained in DM#3344828 GIS_ALL.COMPLIANCE_MONITORING_IRISLINK is a composite view made up of materialised view GIS_DATASTORE.COMPLIANCE_MONITORING_IRIS_MV2 which is updated daily at approx 4:30am and materialized view AUTHORISATION_IRIS which is updated every 2 hours. These two materialized views are joined together via IRIS_REGIME_ACTIVITYOBJ_LINK.
Keywords: Authorisation,Monitoring
Topic Category:
Resource Reference Date: 06/04/2018

Metadata Constraints

Access Constraints: copyright
Use Constraints: copyright

Maintenance Information

Maintenance frequency: daily
Last Load Date: 16/09/2023

Spatial Representation Information

Recommended Scale:
Reference System: EPSG2193
Spatial Representation Type: vector

VectorGridGeographic Bounding Box
GeometricObjectType : point
geometricObjectCount : 72802
topologyLevel : geometryOnly
Number of Dimensions : 2
Cell Geometry :
Transformation Param Available : N
westBoundLongitude : 1904207.3108
eastBoundLongitude : 1463056.9707
southBoundLatitude : 5648840.887
northBoundLatitude : 5962282.1192

Responsible Parties

Role:
Position:
Organisation: Waikato Regional Council
Delivery Point: 160 Ward Street
City: Hamilton Central
Postal Code: 3204
Country: New Zealand
Phone:
Fax:
Email:

Data Constraints

Data Access Constraints : copyright
Data Use Constraints: copyright
Data Distribution: Third party, internal permission
Licence Type : To be determined
Licence:
Licence Expiry:
Licence Conditions:
Copyright : © Waikato Regional Council Compliance Monitoring Database (IRIS)2015 Data.
Data Disclaimers : The standard Waikato Regional Council Disclaimer applies to this data “While Waikato Regional Council has exercised all reasonable skill and care in controlling the contents of this information, Waikato Regional Council accepts no liability in contract, tort or otherwise howsoever, for any loss, damage, injury or expense (whether direct, indirect or consequential) arising out of the provision of this information or its use by you.”
Data Use Limits :

Download Links

URLFormatNotes

Supporting Information Links

URLFormatNotes

General Notes:

Attribute Information

NameDescriptionNotesRestrictedPrimary Key
CM_IRISOBJECTID Derived from COMPLIANCE_MONITORING_IRIS N N
CM_IRISID Derived from COMPLIANCE_MONITORING_IRIS N N
FILENO Derived from COMPLIANCE_MONITORING_IRIS N N
REGIME_NAME Derived from COMPLIANCE_MONITORING_IRIS N N
REGIME_OFFICER Derived from COMPLIANCE_MONITORING_IRIS N N
REGIME_OWNER Derived from COMPLIANCE_MONITORING_IRIS N N
REGIME_EMERGENCY_CONTACT Derived from COMPLIANCE_MONITORING_IRIS N N
REGIME_CLASSIFICATION Derived from COMPLIANCE_MONITORING_IRIS N N
REGIME_STATUS Derived from COMPLIANCE_MONITORING_IRIS N N
COMPLIANCEMONITORINGSUMMARY Derived from COMPLIANCE_MONITORING_IRIS N N
COMPLIANCE_DOCUMENTS Derived from COMPLIANCE_MONITORING_IRIS N N
CURRENT_RA_IRISID Derived from COMPLIANCE_MONITORING_IRIS N N
CURRENT_RA_SUBTYPE Derived from COMPLIANCE_MONITORING_IRIS N N
CURRENT_RA_OFFICER Derived from COMPLIANCE_MONITORING_IRIS N N
CURRENT_RA_PRIORITY Derived from COMPLIANCE_MONITORING_IRIS N N
CURRENT_RA_TEAM Derived from COMPLIANCE_MONITORING_IRIS N N
CURRENT_RA_STATUS Derived from COMPLIANCE_MONITORING_IRIS N N
CURRENT_RA_COMPLIANCE Derived from COMPLIANCE_MONITORING_IRIS N N
CURRENT_RA_TYPE Derived from COMPLIANCE_MONITORING_IRIS N N
CURRENT_RA_FOCUS_AREA N N
CURRENT_RA_FOCUS_AREA_REASON N N
PRIOR_RA_FINANCIAL_YEAR N N
PRIOR_RA_COMPLIANCE_STATUS N N
LATEST_OBSERVATION_DATE N N
LATEST_OBSERVATION_TYPE N N
LATEST_OBSERVATION_WORST_COMPLIANCE N N
INDUSTRY N N
INDUSTRIES N N
J_CM_IRISOBJECTID Derived from IRIS_REGIME_ACTIVITYOBJ_IRIS N N
J_AUTH_IRISOBJECTID Derived from IRIS_REGIME_ACTIVITYOBJ_IRIS N N
CURRENTFROM Derived from IRIS_REGIME_ACTIVITYOBJ_IRIS N N
CURRENTTO Derived from IRIS_REGIME_ACTIVITYOBJ_IRIS N N
AUTH_IRISOBJECTID Derived from AUTHORISATION_IRIS N N
AUTH_IRISID Derived from AUTHORISATION_IRIS N N
AUTHORISATIONTYPE Derived from AUTHORISATION_IRIS N N
ACTIVITYTYPE Derived from AUTHORISATION_IRIS N N
ACTIVITYSUBTYPE Derived from AUTHORISATION_IRIS N N
ACTIVITYCLASS Derived from AUTHORISATION_IRIS N N
AUTHORISATIONNAME Derived from AUTHORISATION_IRIS N N
AUTHORISATIONDESCRIPTION Derived from AUTHORISATION_IRIS N N
MONITORINGNOTES Derived from AUTHORISATION_IRIS N N
COMMENCEMENTDATE Derived from AUTHORISATION_IRIS N N
GRANTEDDURATION Derived from AUTHORISATION_IRIS N N
EXPIRYDATE Derived from AUTHORISATION_IRIS N N
LAPSEDATE Derived from AUTHORISATION_IRIS N N
EFFECTIVEENDDATE Derived from AUTHORISATION_IRIS N N
PRIMARYINDUSTRYPURPOSE Derived from AUTHORISATION_IRIS N N
SECONDARYINDUSTRYPURPOSE Derived from AUTHORISATION_IRIS N N
HOLDER Derived from AUTHORISATION_IRIS N N
CURRENTSTATUS Derived from AUTHORISATION_IRIS N N
CURRENTSTATUSFROMDATE Derived from AUTHORISATION_IRIS N N
AUTHORISATIONEXERCISED Derived from AUTHORISATION_IRIS N N
S124STATUS Derived from AUTHORISATION_IRIS N N
AUTHORISATIONURL Derived from AUTHORISATION_IRIS N N
AUTHCOMPLIANCE N N
OBSERVATIONDATE N N
OBSERVINGOFFICERS N N
GEOMETRY N N
ID Unique ID N N

GIS_ALL.IRIS_REGIME_ACTIVITYOBJ_LINK

 
File Identifier: 672CBADC-BC3E-0B0C-E055-000000000001 Parent Identifier: 7A497527-ECFE-4E1C-92DA-6E788302D658
Hierarchy Level: feature Hierarchy Level Name:Feature of Compliance Monitoring Database (IRIS)
Abstract: A non-spatial table to be used as a link for AUTHORISATION_IRIS and COMPLIANCE_MONITORING_IRIS
Statement: A many-to-many join relationship exists between AUTHORISATION_IRIS and COMPLIANCE_MONITORING_IRIS. A single authorisations can link at one or more of the regime level / regime activity level / observation level of compliance monitoring. A compliance monitoring (regime / regime activity / observation) will link back to at least one authorisation.
Other Information:
Keywords: IRIS
Topic Category: farming:rearing of animals and/or cultivation of plants
Resource Reference Date: 12/03/2018

Metadata Constraints

Access Constraints: copyright
Use Constraints: copyright

Maintenance Information

Maintenance frequency: daily
Last Load Date: 20/08/2021

Spatial Representation Information

Recommended Scale:
Reference System:
Spatial Representation Type: textTable

VectorGridGeographic Bounding Box
GeometricObjectType :
geometricObjectCount : 73112
topologyLevel :
Number of Dimensions :
Cell Geometry :
Transformation Param Available : N
westBoundLongitude : 0
eastBoundLongitude : 0
southBoundLatitude : 0
northBoundLatitude : 0

Responsible Parties

Role: owner
Position: GIS and Data Management Team Leader
Organisation: Waikato Regional Council - Science, Policy and Information
Delivery Point: 160 Ward Street
City: Hamilton Central
Postal Code: 3204
Country: New Zealand
Phone: 0800 800 401
Fax: 07 859 0998
Email: inforeq@waikatoregion.govt.nz

Data Constraints

Data Access Constraints : copyright
Data Use Constraints: copyright
Data Distribution: Third party, internal permission
Licence Type : To be determined
Licence:
Licence Expiry:
Licence Conditions:
Copyright : © Waikato Regional Council Compliance Monitoring Database (IRIS)2018 Data.
Data Disclaimers : The standard Waikato Regional Council Disclaimer applies to this data “While Waikato Regional Council has exercised all reasonable skill and care in controlling the contents of this information, Waikato Regional Council accepts no liability in contract, tort or otherwise howsoever, for any loss, damage, injury or expense (whether direct, indirect or consequential) arising out of the provision of this information or its use by you.”
Data Use Limits :

Download Links

URLFormatNotes

Supporting Information Links

URLFormatNotes

General Notes:

Attribute Information

NameDescriptionNotesRestrictedPrimary Key
IRISOBJECTID N N
LINKEDIRISOBJECTID N N
LINKEDASRELATIONSHIPTYPE N N
DESCRIPTION N N
CURRENTFROM N N
CURRENTTO N N
ACTIVITYOBJECTRELATIONSHIPID N N
REFRESH_DATE Date data has been updated from IRIS N N
ID N Y