Allocated Water Take (IRIS) - GIS Layer


File ID: 36E4464F-BE73-40FC-A12C-492F56095D5B
Hierarchy Level: dataset
Abstract: These GIS layers are provided in support of the Waikato Regional Council Water Allocation Calculators (WAC). They present data for all active Resource Consents for Water takes from Authorisations and Application Activities. They are views of data held within the Consents module of the Integrated Regional Information System (IRIS) database.
Statement: IRIS comprises a set of regional council-specific business modules covering the business areas of Consents, Compliance Monitoring, Environmental Monitoring, Biosecurity, Biodiversity, Land Management, Contacts, Request for Service and Environmental Results. Each of these processes are underpinned by core information on citizens/ratepayers/customers, property and land/geography. Geographic extent is the Waikato Region and the surrounds (some consents are outside the region). The information in this dataset is up to date and has ongoing maintenance. Contains resource consent data migrated from the RUAMS database to IRIS August 2013 and data subsequently managed in IRIS. IRIS is a corporate SQL database. Daily scheduled tasks replicate the consents data from SQL Server (IRIS) to the Oracle Spatial corporate database. Data quality is achieved through data entry validation and regular reporting to Regulatory Committee, Ministry for the Environment and for the National Consent Database. The database is integrated with other corporate databases. This data set can be used for regulatory reasons (eg. consents, permitted activites, monitoring and enforcement) For consent and permitted activity processing the ability to: • Implement council policy and rules surrounding water allocation (specifically Variation6) • provide reporting functionality for consent applications in terms of RMA / Building Act processing timeframes, • store details of Applications, Resource Consents, Permitted Activities and registration of personal watercraft, • store application attributes including industry sector, consent types and subtypes, • allow multiple types of application against a resource consent, • support the requirements of the Resource Management Act (RMA), Building Act and relevant bylaws.
Keywords: Application,Authorisation,Consent,Download,IRIS,Water allocation,Water conservation,Water use,Waterway
Topic Category: environment:environmental resources, protection and conservation
Resource Reference Date: 09/12/2014
Metadata URL: https://data.waikatoregion.govt.nz:8443/ords/f?p=140:12:0::NO::P12_METADATA_ID:855

Responsible Parties

Role: owner
Position: Team Leader - Spatial Information and Data Management
Organisation: Waikato Regional Council
Delivery Point: 160 Ward Street
City: Hamilton Central
Postal Code: 3204
Country: New Zealand
Phone:
Fax:
Email:
Role: custodian
Position: Team Leader - Spatial Analysis and Modelling, Spatial Information
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

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: Information is often duplicated in the hard copy form as files. IRIS is integrated with other Waikato Regional Council corporate Oracle databases. The following listings provide attribute details to assist in query building. NB. This section contains details and/or examples (for Authorisations) where known WRC DOCS #2331061 - Water_Allocation_Calculator_Operations_Guide WRC DOCS #2223325 – Data Replication for IRS GIS – Admin notes WRC DOCS #2517251 - IRIS GIS Views Specification – Authorisations. WRC DOCS #2794911 - Authorisations (IRIS) - GIS Layer WRC DOCS #2814207 - Application Activity (IRIS) - GIS_Layer

COMPLIANCE.sdeadmin.ALLOC_IRIS_ALL_AUTHS

 
File Identifier: A1A502BD-4BEC-446E-89BD-A1EC543AACBA Parent Identifier: 36E4464F-BE73-40FC-A12C-492F56095D5B
Hierarchy Level: feature Hierarchy Level Name:feature of Allocated Water Take (IRIS) - GIS Layer
Abstract: Authorisations (IRIS) designed with monthly (seasonal) attributes to support water allocation requirements. This layer is the same as GIS_ALL.ALLOC_IRIS_AUTH_TAKE_SEASONAL except that it contains historic consents rather than just current ones. It is designed to enable the analysis of historic consents (with allocation data) within WAC catchments. This layer selects from a table that is populated by a stored procedure called REFRESH_ALLOC_IRIS_ALL_AUTHS. The stored procedure is refreshed every 2 hours Monday to Friday between 7am and 6pm.
Statement: Applications for resource consents are made on standard forms, information from these forms are entered into the IRIS database. Application forms are stored on files in Council document management system. Application activities for water allocation are presented as the Oracle view GIS_ALL.ALLOC_IRIS_APPN_TAKE_SEASONAL. At an appropriate stage of the business cycle an application activity can become an Authorisation and be presented in the Oracle view GIS_ALL.ALLOC_IRIS_AUTH_TAKE_SEASONAL (a record cannot be both an Application and an Authorisation). The IRIS database was installed in August 2013 and replaces the RUAMS database. The view GIS_ALL.ALLOC_IRIS_WATER_TAKE_SEASONAL obtains its data from the above views as well as GIS_DATASTORE.WAC_TAGS_IRIS_WATER_TAKE (this is a table updated overnight whereby each consent record is tagged with data about the WAC catchment and aquifer that the consent is spatially contained by). Note that as at January 2015 this capability is temporarily disabled. There are business rules currently in force which result in only point data being entered into the IRIS database. The GIS layers portray a single record for every location so a consent that has multiple locations will be represented by multiple rows in the layer. Geographic extent of the Waikato Region. Quality is achieved through data entry validation and regular reporting to Regulatory Committee, Ministry for the Environment and for the National Consent Database. The database is integrated with other corporate databases.
Other Information: Positional accuracy is unknown (dependent on capture/creation method) Hyperlinks to IRIS business and location web forms are provided as attributes so that users can interactively view additional information held in IRIS about any feature.
Keywords: Authorisation,Consent,IRIS,Water,Water allocation,Water conservation,Water supply
Topic Category: environment:environmental resources, protection and conservation
Resource Reference Date: 09/06/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 : 9081
topologyLevel : geometryOnly
Number of Dimensions : 2
Cell Geometry :
Transformation Param Available : N
westBoundLongitude : 1904322.0381
eastBoundLongitude : 1741470.9652
southBoundLatitude : 5653652.8869
northBoundLatitude : 5960326.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: Unrestricted
Licence Type : To be determined
Licence:
Licence Expiry:
Licence Conditions:
Copyright : All printed maps or other outputs, which contain Authorisation features, must contain the following message: “Authorisation information sourced from Waikato Regional Council database and may be subject to Privacy regulations. COPYRIGHT RESERVED.” For further information relating to the publication of this data please contact Resource Use, Waikato Regional Council.
Data Disclaimers : “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 Unique identifier for GIS, inherited from IRIS_LOC_GEOM_FINAL N Y
IRISOBJECTID Unique identifier for IRIS authorisation N N
IRISID Consent identifier, e.g. ‘AUTH123456.01.01’ N N
OBJECTTYPE Identifies between auth/app, set value of ‘Authorisation’ N N
AUTHTYPE Authorisation type e.g. ‘Resource Consent’ N N
ACTIVITYTYPE E.g. ‘Water Permit’ N N
ACTIVITYSUBTYPE E.g. ‘Ground water take’ N N
ACTIVITYCLASS E.g. ‘Discretionary’ N N
AUTHNAME E.g. ‘Ground water take’ N N
AUTHDESCRIPTION E.g. ‘Take up to 156 cubic metres per day of groundwater for …’ N N
HOLDER Name of authorisation holder N N
AUTHID Other IRIS identifier N N
ACTIVITYID Other IRIS identifier N N
APPLICATIONID Other IRIS identifier N N
COMMENCEMENTDATE Date authorisation commenced N N
EXPIRYDATE Date authorisation is set to expire N N
LAPSEDATE N N
EFFECTIVEENDDATE N N
PRIMARYINDUSTRYPURPOSE E.g. ‘Agricultural farming – dairy’, ‘Recreation/amenities/sport’ N N
SECONDARYINDUSTRYPURPOSE N N
CURRENTSTATUS Status of consent N N
CURRENTSTATUSFROMDATE Date of current status being set N N
AUTHEXERCISED ‘Yes’ or ‘No’ N N
S124STATUS E.g. ‘S.124 protection applies’ or ‘Not Applicable’, null N N
MAXDAILYDERIVEDNET Daily take rate (or equivalent) in cubic metres per day N N
MAXRATEDERIVED_NET24HR MAXDAILYDERIVEDNET/86400 applies to some WAC catchments N N
MAXANNUALDERIVEDNET Annual take rate (or equivalent) in cubic metres per year N N
MAXRATEDERIVEDNET Instantaneous take rate (or equivalent) in cubic metres per second N N
DAIRYSHEDADJUSTMENT Factor used in WAC if previously included in permitted model N N
PROPOSEDTOTALAREAIRRIGATED Proposed irrigation area where applicable N N
TAKEPOINTS Flag indicating that WAC parameters have been loaded (value=99) N N
WATERUSEPRIMARY E.g. ‘Agriculture’, ‘Domestic & Municipal Water Supply’ N N
WATERUSESECONDARY E.g. ‘Stock water and shed wash’ N N
WATERUSETERTIARY E.g. ‘Drinking water supply - Domestic, rural or urban’ N N
POINTLOCATIONCOUNT Count of locations related to this activity (from IRIS), used in WAC N N
GW_FACTOR Impact (factor from zero to 1) of a ground water take on a surface water catchment N N
GW_CATCHMENT Upstream catchment impacted by a ground water take; factor then applies to this and all downstream catchments via the calculator N N
EASTINGNZTM2000 NZTM Easting coordinate N N
NORTHINGNZTM2000 NZTM Northing coordinate N N
IRIS_AUTHORISATION_URL Link to IRIS (internal to WRC) business record N N
IRIS_LOCATION_URL Link to IRIS (internal to WRC) location record N N
APPLICABLEMONTHSFLAG Indicates if this IRIS parameter flag has been set N N
JAN_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
FEB_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
MAR_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
APR_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
MAY_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
JUN_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
JUL_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
AUG_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
SEP_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
OCT_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
NOV_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
DEC_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
JAN_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
FEB_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
MAR_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
APR_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
MAY_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
JUN_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
JUL_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
AUG_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
SEP_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
OCT_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
NOV_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
DEC_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
GEOMETRY Oracle spatial geometry (SDO GTYPE = 2005, SRID = 2193) N N

COMPLIANCE.sdeadmin.ALLOC_IRIS_APPN_TAKE_SEASONAL

 
File Identifier: 61AD6519-D621-402C-A0B5-9387678A6C85 Parent Identifier: 36E4464F-BE73-40FC-A12C-492F56095D5B
Hierarchy Level: feature Hierarchy Level Name:feature of Allocated Water Take (IRIS) - GIS Layer
Abstract: Application Activities (IRIS) designed with monthly (seasonal) attributes to support water allocation requirements.
Statement: Applications for resource consents are made on standard forms, information from these forms are entered into the IRIS database. Application forms are stored on files in Council document management system. Application activities for water allocation are presented as the Oracle view GIS_ALL.ALLOC_IRIS_APPN_TAKE_SEASONAL. At an appropriate stage of the business cycle an application activity can become an Authorisation and be presented in the Oracle view GIS_ALL.ALLOC_IRIS_AUTH_TAKE_SEASONAL (a record cannot be both an Application and an Authorisation). The IRIS database was installed in August 2013 and replaces the RUAMS database. The view GIS_ALL.ALLOC_IRIS_WATER_TAKE_SEASONAL obtains its data from the above views as well as GIS_DATASTORE.WAC_TAGS_IRIS_WATER_TAKE (this is a table updated overnight whereby each consent record is tagged with data about the WAC catchment and aquifer that the consent is spatially contained by). Note that as at January 2015 this capability is temporarily disabled. There are business rules currently in force which result in only point data being entered into the IRIS database. The GIS layers portray a single record for every location so a consent that has multiple locations will be represented by multiple rows in the layer. Geographic extent of the Waikato Region. Quality is achieved through data entry validation and regular reporting to Regulatory Committee, Ministry for the Environment and for the National Consent Database. The database is integrated with other corporate databases.
Other Information: Positional accuracy is unknown (dependent on capture/creation method) Hyperlinks to IRIS business and location web forms are provided as attributes so that users can interactively view additional information held in IRIS about any feature.
Keywords: Application,Authorisation,Consent,IRIS,Water allocation,Water use
Topic Category: environment:environmental resources, protection and conservation
Resource Reference Date: 24/10/2013

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 : 537
topologyLevel : geometryOnly
Number of Dimensions : 2
Cell Geometry :
Transformation Param Available : N
westBoundLongitude : 1903624.0381
eastBoundLongitude : 1747208.9651
southBoundLatitude : 5680364.8864
northBoundLatitude : 5947034.1189

Responsible Parties

Role: custodian
Position: Team Leader - Spatial Analysis and Modelling, Spatial Information
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
Role: owner
Position: Team Leader - Spatial Information and Data Management
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: Unrestricted
Licence Type : To be determined
Licence:
Licence Expiry:
Licence Conditions:
Copyright : All printed maps or other outputs, which contain Authorisation features, must contain the following message: “Authorisation information sourced from Waikato Regional Council database and may be subject to Privacy regulations. COPYRIGHT RESERVED.” For further information relating to the publication of this data please contact Resource Use, Waikato Regional Council.
Data Disclaimers : “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 Unique identifier for GIS, inherited from IRIS_LOC_GEOM_FINAL N Y
IRISAPPOBJECTID Other IRIS identifier N N
IRISID Consent identifier, e.g. ‘APP123456_01’ N N
OBJECTTYPE Identifies between auth/app, set value of ‘Application’ N N
APPLICATIONID Other IRIS identifier N N
APPLICATIONDESCRIPTION Application activity description e.g. ‘To take groundwater’ N N
DECISION Activity decision e.g. ‘All Activities Withdrawn’ N N
APPLICATIONTYPE Initially either ‘Resource Consent’ or ‘Certificate of Compliance’ N N
ACTIVITYNAME Another description e.g. ‘Ground water take’ N N
ACTIVITYTYPE Activity type e.g. ‘Water Permit’ N N
ACTIVITYSUBTYPE Activity subtype e.g. ‘Ground water take’ N N
ACTIVITYCLASS E.g. ‘Discretionary’, ‘Controlled’, ‘Restricted discretionary’ N N
ACTIVITYDESCRIPTION E.g. ‘To take groundwater’ N N
ACTIVITYPURPOSE Purpose e.g. ‘New’, ‘Replace’ N N
APPLICANT Name of applicant Y N
IRISAPPACTIVITYOBJECTID Unique identifier for IRIS application activity N N
ACTIVITYID Other IRIS identifier N N
PREVIOUSAUTHID ID of previous authorisation if exists N N
AUTHORISATIONIRISID This view should include only ‘0’ i.e. non-authorisations N N
COMMENCEMENTDATE N N
EXPIRYDATE N N
ACTIVITYLATESTOUTCOME This view includes just those ‘Inflight’ N N
ACTIVITYOUTCOMEDATE N N
ACTIVITYOUTCOMESTATUS N N
PRIMARYINDUSTRYPURPOSE E.g. ‘Agricultural farming – dairy’ N N
SECONDARYINDUSTRYPURPOSE N N
CURRENTSTATUS E.g. ‘Active’, ‘Active – Submissions’, ‘On Hold’ N N
CURRENTSTATUSFROMDATE Date of current status being set N N
MAXDAILYDERIVEDNET Daily take rate (or equivalent) in cubic metres per day N N
MAXRATEDERIVED_NET24HR MAXDAILYDERIVEDNET/86400 applies to some WAC catchments N N
MAXANNUALDERIVEDNET Annual take rate (or equivalent) in cubic metres per year N N
MAXRATEDERIVEDNET Instantaneous take rate (or equivalent) in cubic metres per second N N
DAIRYSHEDADJUSTMENT Factor used in WAC if previously included in permitted model N N
PROPOSETOTALAREAIRRIGATED Proposed irrigation area where applicable N N
TAKEPOINTS Flag indicating that WAC parameters have been loaded (value=99) N N
WATERUSEPRIMARY E.g. ‘Agriculture’, ‘Domestic & Municipal Water Supply’ N N
WATERUSESECONDARY E.g. ‘Stock water and shed wash’ N N
WATERUSETERTIARY E.g. ‘Drinking water supply - Domestic, rural or urban’ N N
POINTLOCATIONCOUNT Count of point locations associated with this IRIS business record. To appear in this GIS layer a record will have one or more point locations. Non-point locations (areas, lines) are not counted. N N
GW_FACTOR Impact (factor from zero to 1) of a ground water take on a surface water catchment N N
GW_CATCHMENT Upstream catchment impacted by a ground water take; factor then applies to this and all downstream catchments via the calculator N N
EASTINGNZTM2000 NZTM Easting coordinate N N
NORTHINGNZTM2000 NZTM Northing coordinate N N
IRIS_APPLICATION_URL Link to IRIS (internal to WRC) business record N N
IRIS_LOCATION_URL Link to IRIS (internal to WRC) location record N N
APPLICABLEMONTHSFLAG Indicates if this IRIS parameter flag has been set N N
JAN_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
FEB_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
MAR_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
APR_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
MAY_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
JUN_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
JUL_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
AUG_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
SEP_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
OCT_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
NOV_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
DEC_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
JAN_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
FEB_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
MAR_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
APR_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
MAY_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
JUN_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
JUL_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
AUG_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
SEP_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
OCT_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
NOV_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
DEC_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
GEOMETRY Oracle spatial geometry (SDO GTYPE = 2005, SRID = 2193) N N

COMPLIANCE.sdeadmin.ALLOC_IRIS_AUTH_TAKE_SEASONAL

 
File Identifier: 2B81314F-D178-4BD1-A7CA-67FBFAB21174 Parent Identifier: CD3D3CA8-702B-4B3D-B3CC-86A15E1DE410
Hierarchy Level: feature Hierarchy Level Name:feature of Allocated Water Take (IRIS) - GIS Layer
Abstract: Authorisations (IRIS) designed with monthly (seasonal) attributes to support water allocation requirements.
Statement: Applications for resource consents are made on standard forms, information from these forms are entered into the IRIS database. Application forms are stored on files in Council document management system. Application activities for water allocation are presented as the Oracle view GIS_ALL.ALLOC_IRIS_APPN_TAKE_SEASONAL. At an appropriate stage of the business cycle an application activity can become an Authorisation and be presented in the Oracle view GIS_ALL.ALLOC_IRIS_AUTH_TAKE_SEASONAL (a record cannot be both an Application and an Authorisation). The IRIS database was installed in August 2013 and replaces the RUAMS database. The view GIS_ALL.ALLOC_IRIS_WATER_TAKE_SEASONAL obtains its data from the above views as well as GIS_DATASTORE.WAC_TAGS_IRIS_WATER_TAKE (this is a table updated overnight whereby each consent record is tagged with data about the WAC catchment and aquifer that the consent is spatially contained by). Note that as at January 2015 this capability is temporarily disabled. There are business rules currently in force which result in only point data being entered into the IRIS database. The GIS layers portray a single record for every location so a consent that has multiple locations will be represented by multiple rows in the layer. Geographic extent of the Waikato Region. Quality is achieved through data entry validation and regular reporting to Regulatory Committee, Ministry for the Environment and for the National Consent Database. The database is integrated with other corporate databases.
Other Information: Positional accuracy is unknown (dependent on capture/creation method) Hyperlinks to IRIS business and location web forms are provided as attributes so that users can interactively view additional information held in IRIS about any feature.
Keywords: Authorisation,Consent,IRIS,Water allocation,Water conservation,Water supply
Topic Category: environment:environmental resources, protection and conservation
Resource Reference Date: 24/10/2013

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 : 4360
topologyLevel : geometryOnly
Number of Dimensions : 2
Cell Geometry :
Transformation Param Available : N
westBoundLongitude : 1904274.0381
eastBoundLongitude : 1741470.9652
southBoundLatitude : 5670860.8866
northBoundLatitude : 5960326.1192

Responsible Parties

Role: custodian
Position: Team Leader - Spatial Analysis and Modelling, Spatial Information
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
Role: owner
Position: Team Leader - Spatial Information and Data Management
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: Unrestricted
Licence Type : N/A
Licence:
Licence Expiry:
Licence Conditions:
Copyright : All printed maps or other outputs, which contain Authorisation features, must contain the following message: “Authorisation information sourced from Waikato Regional Council database and may be subject to Privacy regulations. COPYRIGHT RESERVED.” For further information relating to the publication of this data please contact Resource Use, Waikato Regional Council.
Data Disclaimers : “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 Unique identifier for GIS, inherited from IRIS_LOC_GEOM_FINAL N Y
IRISOBJECTID Unique identifier for IRIS authorisation N N
IRISID Consent identifier, e.g. ‘AUTH123456.01.01’ N N
OBJECTTYPE Identifies between auth/app, set value of ‘Authorisation’ N N
AUTHTYPE Authorisation type e.g. ‘Resource Consent’ N N
ACTIVITYTYPE E.g. ‘Water Permit’ N N
ACTIVITYSUBTYPE E.g. ‘Ground water take’ N N
ACTIVITYCLASS E.g. ‘Discretionary’ N N
AUTHNAME E.g. ‘Ground water take’ N N
AUTHDESCRIPTION E.g. ‘Take up to 156 cubic metres per day of groundwater for …’ N N
HOLDER Name of authorisation holder Y N
AUTHID Other IRIS identifier N N
ACTIVITYID Other IRIS identifier N N
APPLICATIONID Other IRIS identifier N N
COMMENCEMENTDATE Date authorisation commenced N N
EXPIRYDATE Date authorisation is set to expire N N
LAPSEDATE N N
EFFECTIVEENDDATE N N
PRIMARYINDUSTRYPURPOSE E.g. ‘Agricultural farming – dairy’, ‘Recreation/amenities/sport’ N N
SECONDARYINDUSTRYPURPOSE N N
CURRENTSTATUS Includes ‘Current’ or ‘Not yet commenced’ N N
CURRENTSTATUSFROMDATE Date of current status being set N N
AUTHEXERCISED ‘Yes’ or ‘No’ N N
S124STATUS E.g. ‘S.124 protection applies’ or ‘Not Applicable’, null N N
MAXDAILYDERIVEDNET Daily take rate (or equivalent) in cubic metres per day N N
MAXRATEDERIVED_NET24HR MAXDAILYDERIVEDNET/86400 applies to some WAC catchments N N
MAXANNUALDERIVEDNET Annual take rate (or equivalent) in cubic metres per year N N
MAXRATEDERIVEDNET Instantaneous take rate (or equivalent) in cubic metres per second N N
DAIRYSHEDADJUSTMENT Factor used in WAC if previously included in permitted model N N
PROPOSEDTOTALAREAIRRIGATED Proposed irrigation area where applicable N N
TAKEPOINTS Flag indicating that WAC parameters have been loaded (value=99) N N
WATERUSEPRIMARY E.g. ‘Agriculture’, ‘Domestic & Municipal Water Supply’ N N
WATERUSESECONDARY E.g. ‘Stock water and shed wash’ N N
WATERUSETERTIARY E.g. ‘Drinking water supply - Domestic, rural or urban’ N N
POINTLOCATIONCOUNT Count of locations related to this activity (from IRIS), used in WAC N N
GW_FACTOR Impact (factor from zero to 1) of a ground water take on a surface water catchment N N
GW_CATCHMENT Upstream catchment impacted by a ground water take; factor then applies to this and all downstream catchments via the calculator N N
EASTINGNZTM2000 NZTM Easting coordinate N N
NORTHINGNZTM2000 NZTM Northing coordinate N N
IRIS_AUTHORISATION_URL Link to IRIS (internal to WRC) business record N N
IRIS_LOCATION_URL Link to IRIS (internal to WRC) location record N N
APPLICABLEMONTHSFLAG Indicates if this IRIS parameter flag has been set N N
JAN_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
FEB_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
MAR_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
APR_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
MAY_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
JUN_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
JUL_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
AUG_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
SEP_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
OCT_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
NOV_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
DEC_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
JAN_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
FEB_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
MAR_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
APR_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
MAY_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
JUN_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
JUL_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
AUG_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
SEP_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
OCT_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
NOV_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
DEC_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
GEOMETRY Oracle spatial geometry (SDO GTYPE = 2005, SRID = 2193) N N

COMPLIANCE.sdeadmin.ALLOC_IRIS_WATER_TAKE_SEASONAL

 
File Identifier: DF20426B-96A4-4C4C-BE46-A174082A4C85 Parent Identifier: 36E4464F-BE73-40FC-A12C-492F56095D5B
Hierarchy Level: feature Hierarchy Level Name:feature of Allocated Water Take (IRIS) - GIS Layer
Abstract: Combined view of Applications and Authorisations designed with monthly (seasonal) attributes to support water allocation requirements
Statement: Applications for resource consents are made on standard forms, information from these forms are entered into the IRIS database. Application forms are stored on files in Council document management system. Application activities for water allocation are presented as the Oracle view GIS_ALL.ALLOC_IRIS_APPN_WATER_TAKE. At an appropriate stage of the business cycle an application activity can become an Authorisation and be presented in the Oracle view GIS_ALL.ALLOC_IRIS_AUTH_WATER_TAKE (a record cannot be both an Application and an Authorisation). The Oracle view GIS_ALL.ALLOCATION_IRIS_WATER_TAKE combines data from each of the above. The IRIS database was installed in August 2013 and replaces the RUAMS database. The view GIS_ALL.ALLOCATION_IRIS_WATER_TAKE obtains its data from the above views as well as GIS_DATASTORE.WAC_TAGS_IRIS_WATER_TAKE (this is a table updated overnight whereby each consent record is tagged with data about the WAC catchment and aquifer that the consent is spatially contained by). Note that as at January 2015 this capability is temporarily disabled. There are business rules currently in force which result in only point data being entered into the IRIS database. The GIS layers portray a single record for every location so a consent that has multiple locations will be represented by multiple rows in the layer. Geographic extent of the Waikato Region. Quality is achieved through data entry validation and regular reporting to Regulatory Committee, Ministry for the Environment and for the National Consent Database. The database is integrated with other corporate databases.
Other Information: Positional accuracy is unknown (dependent on capture/creation method) Hyperlinks to IRIS business and location web forms are provided as attributes so that users can interactively view additional information held in IRIS about any feature.
Keywords: Authorisation,Consent,Download,IRIS,Waikato Data Portal,Water allocation,Water conservation,Water use
Topic Category: environment:environmental resources, protection and conservation
Resource Reference Date: 24/10/2013

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 : 4897
topologyLevel : geometryOnly
Number of Dimensions : 2
Cell Geometry :
Transformation Param Available : N
westBoundLongitude : 1904274.0381
eastBoundLongitude : 1741470.9652
southBoundLatitude : 5670860.8866
northBoundLatitude : 5960326.1192

Responsible Parties

Role: owner
Position: Team Leader - Spatial Information and Data Management
Organisation: Waikato Regional Council
Delivery Point: 160 Ward Street
City: Hamilton Central
Postal Code: 3204
Country: New Zealand
Phone:
Fax:
Email:
Role: custodian
Position: Team Leader - Spatial Analysis and Modelling, Spatial Information
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: Unrestricted
Licence Type : To be determined
Licence:
Licence Expiry:
Licence Conditions:
Copyright : All printed maps or other outputs, which contain Authorisation features, must contain the following message: “Authorisation information sourced from Waikato Regional Council database and may be subject to Privacy regulations. COPYRIGHT RESERVED.” For further information relating to the publication of this data please contact Resource Use, Waikato Regional Council.
Data Disclaimers : “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
 44a06f0cd28244edae0ded7eacb46e7c Download @ Waikato Data Portal

Supporting Information Links

URLFormatNotes

General Notes:

Attribute Information

NameDescriptionNotesRestrictedPrimary Key
AUTHORISATIONID N N
PLPID N N
ACTIVITYID N N
ID Unique identifier for GIS, inherited from IRIS_LOC_GEOM_FINAL N N
IRISID Consent identifier e.g. ‘APP123456_01’, ‘AUTH123456.01.01’ N N
OBJECTTYPE Identifies between auth/app either ‘Application’ or ‘Authorisation’ N N
ACTIVITYSUBTYPE App/auth sub type e.g. ‘Ground water take’ N N
ACTIVITYNAME App/auth name e.g. ‘Ground water take’ N N
APPLICANT_OR_HOLDER App/auth name e.g. ‘Ground water take’ N N
ACTIVITYDESCRIPTION E.g. ‘Take up to 156 cubic metres per day of groundwater for …’ N N
APPACTIVITYPURPOSE Application purpose e.g. ‘New’, ‘Replace’; Apps only, null for Auths N N
APPPREVIOUSAUTHID ID of previous authorisation if exists; Apps only, null for Auths N N
AUTHEXERCISED ‘Yes’ or ‘No’; Auths only, null for Apps N N
AUTHS124STATUS E.g. ‘S.124 protection applies’; Auths only null for Apps N N
COMMENCEMENTDATE Date authorisation commenced N N
EXPIRYDATE Date authorisation is set to expire N N
PRIMARYINDUSTRYPURPOSE E.g. ‘Agricultural farming – dairy’, ‘Recreation/amenities/sport’ Purpose as listed by the consenting officer(s) on the Authorisation. Recommend that the columns WaterUsePrimary, WaterUseSecondary, WaterUseTertiary are used for filtering data. N N
SECONDARYINDUSTRYPURPOSE Purpose as listed by the consenting officer(s) on the Authorisation. Recommend that the columns WaterUsePrimary, WaterUseSecondary, WaterUseTertiary are used for filtering data. N N
CURRENTSTATUS E.g. ‘Active’ for Apps, ‘Current’ or ‘Not yet commenced’ for Auths N N
CURRENTSTATUSFROMDATE Date of current status being set N N
MAXDAILYDERIVEDNET Daily take rate (or equivalent) in cubic metres per day N N
MAXDAILY_COMMENT N N
MAXRATEDERIVED_NET24HR MAXDAILYDERIVEDNET/86400 applies to some WAC catchments N N
MAXANNUALDERIVEDNET Annual take rate (or equivalent) in cubic metres per year N N
MAXANNUAL_COMMENT N N
MAXRATEDERIVEDNET Instantaneous take rate (or equivalent) in cubic metres per second N N
MAXRATE_COMMENT N N
DAIRYSHEDADJUSTMENT Factor used in WAC if previously included in permitted model N N
PROPOSEDTOTALAREAIRRIGATED Proposed irrigation area where applicable N N
TAKEPOINTS Parameter to record number of take points - being phased out N N
WATERUSEPRIMARY E.g. ‘Agriculture’, ‘Domestic & Municipal Water Supply’ N N
WATERUSESECONDARY E.g. ‘Stock water and shed wash’ N N
WATERUSETERTIARY E.g. ‘Drinking water supply - Domestic, rural or urban’ N N
POINTLOCATIONCOUNT Count of point locations associated with this IRIS business record. To appear in this GIS layer a record will have one or more point locations. Non-point locations (areas, lines) are not counted. N N
GW_FACTOR Impact (factor from zero to 1) of a ground water take on a surface water catchment N N
GW_CATCHMENT Upstream catchment impacted by a ground water take; factor then applies to this and all downstream catchments via the calculator N N
EASTINGNZTM2000 NZTM Easting coordinate N N
NORTHINGNZTM2000 NZTM Northing coordinate N N
IRIS_AUTHAPPN_URL Link to IRIS (internal to WRC) business record Not available in public Data download N N
IRIS_LOCATION_URL Link to IRIS (internal to WRC) location record Not available in public Data download N N
APPLICABLEMONTHSFLAG Indicates if this IRIS parameter flag has been set N N
JAN_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
FEB_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
MAR_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
APR_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
MAY_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
JUN_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
JUL_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
AUG_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
SEP_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
OCT_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
NOV_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
DEC_MAXDAILY monthly maximum daily take rate, cubic metres per second N N
JAN_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
FEB_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
MAR_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
APR_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
MAY_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
JUN_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
JUL_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
AUG_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
SEP_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
OCT_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
NOV_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
DEC_MAXRATE monthly maximum instantaneous take rate, cubic metres per second N N
GEOMETRY Oracle spatial geometry (SDO GTYPE = 2005, SRID = 2193) N N
OBJECTID N N