|
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: |
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: |
|
|---|
|
Metadata
| Language: |
English |
|---|
| Character Set: |
utf8 |
|---|
| Standard: |
ANZLIC |
|---|
| Standard Version: |
1.1 |
|---|
Metadata Constraints
| Access Constraints: |
copyright |
|---|
| Use Constraints: |
copyright |
|---|
Download Links
Supporting Information Links
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: |
22/11/2024 |
|---|
Spatial Representation Information
| Recommended Scale: |
|
|---|
| Reference System: |
EPSG2193 |
|---|
| Spatial Representation Type: |
vector |
|---|
| Vector | Grid | Geographic Bounding Box |
|---|
| GeometricObjectType : |
point |
|---|
| geometricObjectCount : |
8827 |
|---|
| topologyLevel : |
geometryOnly |
|---|
|
| Number of Dimensions : |
2 |
|---|
| Cell Geometry : |
|
|---|
| Transformation Param Available : |
N |
|---|
|
| westBoundLongitude : |
1904322 |
|---|
| eastBoundLongitude : |
1741471 |
|---|
| southBoundLatitude : |
5653653 |
|---|
| northBoundLatitude : |
5960326 |
|---|
|
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
Supporting Information Links
General Notes:
Attribute Information
| Name | Description | Notes | Restricted | Primary 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: |
23/11/2024 |
|---|
Spatial Representation Information
| Recommended Scale: |
|
|---|
| Reference System: |
EPSG2193 |
|---|
| Spatial Representation Type: |
vector |
|---|
| Vector | Grid | Geographic Bounding Box |
|---|
| GeometricObjectType : |
point |
|---|
| geometricObjectCount : |
392 |
|---|
| 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
Supporting Information Links
General Notes:
Attribute Information
| Name | Description | Notes | Restricted | Primary 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: |
22/11/2024 |
|---|
Spatial Representation Information
| Recommended Scale: |
|
|---|
| Reference System: |
EPSG2193 |
|---|
| Spatial Representation Type: |
vector |
|---|
| Vector | Grid | Geographic Bounding Box |
|---|
| GeometricObjectType : |
point |
|---|
| geometricObjectCount : |
4091 |
|---|
| 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
Supporting Information Links
General Notes:
Attribute Information
| Name | Description | Notes | Restricted | Primary 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: |
23/11/2024 |
|---|
Spatial Representation Information
| Recommended Scale: |
|
|---|
| Reference System: |
EPSG2193 |
|---|
| Spatial Representation Type: |
vector |
|---|
| Vector | Grid | Geographic Bounding Box |
|---|
| GeometricObjectType : |
point |
|---|
| geometricObjectCount : |
4873 |
|---|
| 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 : |
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
Supporting Information Links
General Notes:
Attribute Information
| Name | Description | Notes | Restricted | Primary 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 |
|
|
|