Skip to main content.

Appendix A: Database Format

The table below lists the database structure.

Field name

Records

Explanation

Units

Region ID

ARC

Auckland Regional Council

 

EBOP

Environment Bay of Plenty

 

ECAN

Environment Canterbury

 

ES

Environment Southland

 

EW

Environment Waikato

 

GDC

Gisborne District Council

 

GWRC

Greater Wellington Regional Council

 

HBRC

Hawkes Bay Regional Council

 

HRC

Horizons Regional Council

 

MDC

Marlborough District Council

 

NCC

Nelson City Council

 

NRC

Northland Regional Council

 

ORC

Otago Regional Council

 

TDC

Tasman District Council

 

TRC

Taranaki Regional Council

 

WCRC

West Cost Regional Council

 

Consent identifier

A888888#

Unique identifier as per council records

 

Primary source

Ground

   

Surface

Include all SW take include dams and lakes

 

Source type

Dam

   

Geothermal

   

Lake

   

River

   

Stream

   

Source identifier

 

Catchment or aquifer description as per council db

 

Source catchment

 

As per national catchment coverage #

 

Primary use

Drinking

   

Heating

   

Industrial

   

Irrigation

   

Recreational

   

Stock

   

Use type

Arable

   

Community

   

Domestic

   

Forestry

   

Frost protection

   

Heating

   

Horticulture

   

Mining

   

Municipal

   

Use type (continued)

Nursery

   

Pasture

   

Quarry

   

Recreational

   

Service

   

Stock water

   

Swimming

   

Storage

   

Unspecified

   

Viticulture

   

Waste

   

Instantaneous rate

 

Listed value or calculation if not listed

l/s

Daily rate

 

Listed value or calculation if not listed

m3/d

Weekly rate

 

Listed value or calculation if not listed

m3/wk

Annual rate

 

Listed value or calculation if not listed

m3/yr

Irrigated area

 

Listed value or calculation if not listed

ha

Easting

     

Northing