LOCATED - Culverts GIS Layer


File ID: 42869D42-D12D-4366-A1AB-BCE7EC60C8AA
Hierarchy Level: dataset
Abstract: The GIS layer has information about the geographic location(s) where environmental data are/have been collected for Culverts.
Statement: This layer reflects the content of the LOCATED Application, which catalogues all locations in the Waikato region where Waikato Regional Council holds environmental data/information electronically. In September 2005 the culvert data was analysed against a number of variables in order to rank them in terms of priority for remedial action. This data is stored in the Oracle spatial database and accessible from the GIS, but must be treated as current only as at September 2005. Also note other data limitations.
Keywords: Groundwater,LOCATED,Waterway
Topic Category: inlandWaters:inland water features, drainage systems and their characteristics
Resource Reference Date: 26/09/2006
Metadata URL: https://data.waikatoregion.govt.nz:8443/ords/f?p=140:12:0::NO::P12_METADATA_ID:1000

Responsible Parties

Role: owner
Position: GIS and Data Management Team Leader
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: EWDOCS# 977849 - Prioritisation for Culvert survey analysis for use by Andy Haigh - GIS Services [process notes for the collation of ranking variables for the GIS_ALL.LOCATED_CULVERT_RANKING_2005 feature]

ENVIRONMENTAL_MONITORING.sdeadmin.LOCATED_CULVERTS

 
File Identifier: 3D36900D-388C-4294-B008-C70A75544000 Parent Identifier: 9836F35E-ACF5-438D-82C5-3C27A3751641
Hierarchy Level: feature Hierarchy Level Name:feature of LOCATED - Culverts GIS layer
Abstract: Culverts in the Waikato region.
Statement: * Data Acquisition Method(s): General culvert information - various, some unknown (for general culvert data as stored in LOCATED Database). *Positional Accuracy: Positional accuracy is mostly to scales of 1:50000 but some locations have been ‘fixed’ using techniques of greater accuracy. The LOCATED Application holds metadata about the positional accuracy of bore and well locations. * Data Quality: Geographical location map references are accurate to ± 50 m (1:50000 scale) unless otherwise indicated by the LOCATED Application.
Other Information: Attribute accuracy is unknown
Keywords: Construction,Culvert,Fishes,Ranking,Remedial,Waterway
Topic Category: inlandWaters:inland water features, drainage systems and their characteristics
structure:man made construction
Resource Reference Date: 26/09/2006

Metadata Constraints

Access Constraints: copyright
Use Constraints: copyright

Maintenance Information

Maintenance frequency: daily
Last Load Date: 05/07/2023

Spatial Representation Information

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

VectorGridGeographic Bounding Box
GeometricObjectType : point
geometricObjectCount : 1739
topologyLevel : geometryOnly
Number of Dimensions : 2
Cell Geometry :
Transformation Param Available : N
westBoundLongitude : 1855775.0371
eastBoundLongitude : 1749619.965
southBoundLatitude : 5753053.8849
northBoundLatitude : 5956941.1191

Responsible Parties

Role: owner
Position: GIS & Data Management Team Leader
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: Waikato Regional Council owns this data set. WRC maintains this data via the LOCATED application. In general, information from this dataset can be published freely.
Copyright : © Waikato Regional Council 2005-2006. LOCATED - Culverts Data. This Data may be subject to the Privacy Act.
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 : Some of the data is likely to be out of date (changed/fixed since the dataset was published).

Download Links

URLFormatNotes

Supporting Information Links

URLFormatNotes

General Notes:

Attribute Information

NameDescriptionNotesRestrictedPrimary Key
LOCATED_KEY LOCATED Key N N
CULVERT_SITE_ID Culvert Site ID Can join to GIS_ALL.LOCATED_CULVERT_RANKING_2005 N N
SOURCE_NAME Name of water source N N
LOCATION_NAME Name of location N N
SOURCE_ID ID of source N N
LOCATION_ID Location ID N N
DESCRIPTION Description of site N N
COMMENTS Additional Comments N N
CVT_INSPECTION_DATE Culvert Inspection Date N N
CVT_LENGTH_M Culvert Length in Metres N N
CVT_DIAMETER_M Culvert Diameter in Metres N N
CVT_WATER_DEPTH_M Culvert Water Depth in Metres N N
CVT_SEDIMENT_DEPTH_M Culvert Sediement Depth in Metres N N
CVT_UNDERCUT_LENGTH_M Culvert Undercut Length N N
CVT_PERCHED_HEIGHT_M Culvert Perched Height in Metres N N
CVT_FIXED Culvert Fixed Y, N, Null N N
CVT_FIXED_YEAR Culvert Fixed Year N N
CVT_DOWNSTREAM_BARRIERS Culvert Downstream Barriers Y, N, Null N N
CVT_UPSTREAM_BARRIERS Culvert Upstream Barriers Y, N, Null N N
CVT_BANK_EROSION_AT_END Culvert bank erosion Y, N, Null N N
FISH_PASSAGE_RESTRICTION Restrictions for fish passage N N
PRIMARY_BED_MATERIAL Primary sediment type in river bed N N
SECONDARY_BED_MATERIAL Secondary sediment type in river bed N N
FLOW_CONDITION Water flow conditions N N
STM_ALIGNMENT_CF_CVT Stream Alignment eg. 'Stream alignment - curved in and out of culvert' N N
STM_GRADIENT_CF_CVT Stream Gradient eg. 'Stream gradient - flatter than culvert gradient' N N
STM_LEVEL_CF_CVT_INLET Stream Level eg. 'Stream level - above culvert invert level' N N
CVT_STM_WIDTH_CF_CVT Stream width N N
CVT_TYPE Culvert Type 'Arch Culvert;, 'Box Culvert', Corrugated Pipe', 'Ford without Culvert', 'Pipe', Null N N
CVT_INLET_XSECTION Culvert Inlet Cross section 'Flat', 'Perched', 'Pooled', Null N N
CVT_OUTLET_XSECTION Culvert Outlet Cross section 'Flat', 'Perched', 'Pooled', Null N N
CVT_CONSTRUCTION_MATERIAL Culvert Construction Material eg. 'Concrete', 'Galvanised Steel' N N
ID Unique Identifier N Y
MAP_REFERENCE Map Reference N N
COORDINATE_ERROR Co-ordinate errors N N
EASTING NZMG Easting N N
NORTHING NZMG Northing N N
GEOMETRY SDO Geometry = 2001 (Point) N N

ENVIRONMENTAL_MONITORING.sdeadmin.LOCATED_CULVERT_RANKING_2005

 
File Identifier: 6AEFFD80-B06D-4EF4-9D78-4A7C063598C3 Parent Identifier: 9836F35E-ACF5-438D-82C5-3C27A3751641
Hierarchy Level: feature Hierarchy Level Name:feature of LOCATED - Culverts GIS Layer
Abstract: Culvert rankings based on a regional snapshot of culverts in July 2005.
Statement: Ranking information only exists for culverts identified as being less than 100 km from the sea. *Positional Accuracy: Positional accuracy is mostly to scales of 1:50000 but some locations have been ‘fixed’ using techniques of greater accuracy. The LOCATED Application holds metadata about the positional accuracy of bore and well locations. * Data Quality: Geographical location map references are accurate to ± 50 m (1:50000 scale) unless otherwise indicated by the LOCATED Application.
Other Information: Data Acquisition Method(s): * General culvert information - various, some unknown (for general culvert data as stored in Located). * For the LOCATED_CULVERT_RANKING_2005 information the following steps were undertaken. For each culvert less than 100 km from the sea the following were identified: •REC REACH_ID (from the GIS_ALL.REC_WATERCOURSE feature) •TA name (from intersection with GIS_ALL.TERRITORIAL_AUTHORITY) •Fish passage restriction (from GIS_ALL.LOCATED_CULVERTS and stored here as a record of barrier status as at September 2005) •Distance to the sea (from the GIS_ALL.REC_WATERCOURSE feature) •Upstream watercourse length (from the GIS_ALL.REC_WATERCOURSE feature) •Upstream % of indigenous forest (from the GIS_ALL.REC_NIWA_EXTRA feature used in conjunction with upstream catchment area from the GIS_ALL.REC_WATERCOURSE feature) •Number of culverts upstream and downstream (and a total upstream or downstream) * Each culvert was then given five scoring values (using formula from MS Excel): •Barrier score (IF(FISH_PASSAGE_RESTRICTION ="Most flow conditions","3",IF(FISH_PASSAGE_RESTRICTION ="Low flow only","2",IF(FISH_PASSAGE_RESTRICTION ="High flow conditions","1")))) •Distance score (IF(DISTSEA_M >=50000,"1",IF(DISTSEA_M <=10000,"3","2"))) •Length score (IF(US_LENGTH_M >=50000,"3",IF(US_LENGTH_M <=10000,"1","2"))) •Forest score (IF(US_LCDB1_IF_PERC >=50,"3",IF(US_LCDB1_IF_PERC <=10,"1","2"))) •Culvert score (IF(Num_CUL_All >1,"1",IF(Num_CUL_All =0,"3","2"))) Two priority values were then calculated using a weighting system, where a higher number represents a higher priority: •Priority 1 - with culvert score in equation (( Score_Barrier *5)+( Score_distance *4)+( Score_length *3)+( Score_Forest *2)+( Score_culvert *1)) •Priority 2 – without culvert score in equation (( Score_Barrier *5)+( Score_distance *4)+( Score_length *3)+( Score_Forest *2)) T* he priority scores were then ranked for the whole Region and by District, whereby a low number is a high rank for remedial action. * For more information about this process see EWDOCS# 977849. For raw data stored in MS Excel (excluding TA ranking values) see EWDOCS# 1026642. * This data analysis has been stored in the corporate Oracle GIS database with attributes CULVERT_SITE_ID and REC_REACH_ID in order to enable joins to the GIS_ALL.LOCATED_CULVETS and GIS_ALL.REC_WATERCOURSE layers respectively. * There are a number of limitations that must be considered in regard to the culvert ranking dataset: •The assessment of each structure is based on a 80/20 ratio of correctness •Given the age of this data – some structures may have been affected by weather events and deteriorated and may in fact now rank higher in this system •Alternatively, some structures may have been remediated since data was collected and may in fact now rank lower in this system or not at all •As this data is provided as a guideline only – it would be recommended that a fishery and/or hydrological survey be undertaken before any major work is undertaken on remedial measures at any of these structures •The provision of this data does not resolve any legislative requirements by any operating authority * The culvert ranking dataset is only for culverts deemed restrictive to fish passage at low, high or most flow conditions, as these are considered the type most in need for remediation (culverts with none/minimal restriction on fish passage were not ranked). When determining final priorities, the perch height and undercut also need to be taken into account (these factors were not considered in the ranking process described above). Other considerations that need to be taken into account are whether culverts have d/s barriers which can’t be remediated (ie: floodgates, dams, waterfalls), or whether remediation may allow access to alien fish species that would not otherwise be present. * The culvert ranking information is based on a regional snapshot of culverts in July 2005.
Keywords: Construction,Culvert,Fishes,Groundwater,Ranking,Remedial,Waterway
Topic Category: inlandWaters:inland water features, drainage systems and their characteristics
structure:man made construction
Resource Reference Date: 26/09/2006

Metadata Constraints

Access Constraints: copyright
Use Constraints: copyright

Maintenance Information

Maintenance frequency: asNeeded
Last Load Date: 26/09/2006

Spatial Representation Information

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

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

Responsible Parties

Role: owner
Position: GIS and Data Management Team Leader
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: Waikato Regional Council owns this data set. WRC maintains this data via the LOCATED application. In general, information from this dataset can be published freely.
Copyright : © Waikato Regional Council 2005-2006. LOCATED - Culverts Data. This Data may be subject to the Privacy Act.
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 : 2013: Some of the data is likely to be out of date (changed/fixed in the last 7 years)

Download Links

URLFormatNotes

Supporting Information Links

URLFormatNotes

General Notes: For more information about this process see EWDOCS# 977849. For raw data stored in MS Excel (excluding TA ranking values) see EWDOCS# 1026642.

Attribute Information

NameDescriptionNotesRestrictedPrimary Key
ID Unique numeric identifier N Y
CULVERT_SITE_ID CULVERT_SITE_ID Enables join to GIS_ALL.LOCATED_CULVETS N N
REC_REACH_ID REC REACH ID from the GIS_ALL.REC_WATERCOURSE feature Enables join to GIS_ALL.REC_WATERCOURSE N N
TA_NAME Territorial Authority Named Created from intersection with GIS_ALL.TERRITORIAL_AUTHORITY N N
FISH_PASSAGE_RESTRICTION Fish passage restriction from GIS_ALL.LOCATED_CULVERTS and stored here as a record of barrier status as at September 2005 N N
DISTSEA_M Distance to the sea from the GIS_ALL.REC_WATERCOURSE feature N N
US_LENGTH_M Upstream watercourse length from the GIS_ALL.REC_WATERCOURSE feature N N
US_LCDB1_IF_PERC Upstream % of indigenous forest from the GIS_ALL.REC_NIWA_EXTRA feature used in conjunction with upstream catchment area from the GIS_ALL.REC_WATERCOURSE feature N N
NUM_CVT_US Number of culverts upstream and downstream N N
NUM_CVT_DS Number of culverts downstream N N
NUM_CUL_ALL Number of culverts upstream and downstream N N
SCORE_BARRIER Barrier score (IF(FISH_PASSAGE_RESTRICTION ="Most flow conditions","3",IF(FISH_PASSAGE_RESTRICTION ="Low flow only","2",IF(FISH_PASSAGE_RESTRICTION ="High flow conditions","1")))) N N
SCORE_DISTANCE Distance score (IF(DISTSEA_M >=50000,"1",IF(DISTSEA_M <=10000,"3","2"))) N N
SCORE_LENGTH Length score (IF(US_LENGTH_M >=50000,"3",IF(US_LENGTH_M <=10000,"1","2"))) N N
SCORE_FOREST Forest score (IF(US_LCDB1_IF_PERC >=50,"3",IF(US_LCDB1_IF_PERC <=10,"1","2"))) N N
SCORE_CULVERT Culvert score (IF(Num_CUL_All >1,"1",IF(Num_CUL_All =0,"3","2"))) N N
PRIORITY1 Priority 1 - with culvert score in equation (( Score_Barrier *5)+( Score_distance *4)+( Score_length *3)+( Score_Forest *2)+( Score_culvert *1)) N N
PRIORITY2 Priority 2 – without culvert score in equation (( Score_Barrier *5)+( Score_distance *4)+( Score_length *3)+( Score_Forest *2)) N N
REG_RANK1 N N
REG_RANK2 N N
DIST_RANK1 N N
DIST_RANK2 N N