Groundwater Economic Elements Hunter NSW 20150520 PersRem v02

Brief description

## **Abstract**

The dataset was derived by the Bioregional Assessment Programme. This dataset was derived from multiple datasets. You can find a link to the parent datasets in the Lineage Field in this metadata statement. The History Field in this metadata statement describes how this dataset was derived.



This dataset has been created to represent Groundwater Economic Elements (Groundwater entitlements) in the Hunter region.

This dataset differs from "Groundwater Economic Assets Hunter NSW 20150331 PersRem" which is version 1 by the inclusion of two further spreadsheets from NSW Office of Water (see lineage) which updated values of unknown FTYPE (use) in the database.

## **Purpose**

The purpose of this dataset is to represent the Economic elements (Groundwater entitlements) in the Hunter PAE.

## **Dataset History**

The dataset was derived by the Bioregional Assessment Programme. This dataset was derived from multiple datasets. You can find a link to the parent datasets in the Lineage Field in this metadata statement. The History Field in this metadata statement describes how this dataset was derived.



This data is a new version of the dataset "Groundwater Economic Assets Hunter NSW 20150331 PersRem (ca620380-3d67-43bb-811a-3cafdf41056a) to be sent to ERIN for reprocessing into a new version of the Hunter Economic Asset Database. This dataset differs from the previous version as data extracts were supplied by the NSW Office of Water to infill records of "Unknown" FTYPE (or use). The result of this is that many more records have been able to be assigned an asset class.

Also fields were added to include what the NSW Office of water term 'High Security' Assets. The resulting 'security' field defines the records with a value of 'High Security". They are Town Water Supply bores.

This new information was joined to the Bores in the previous version of the dataset, new records with values for FTYPE were selected and used to populate (update) the FTYPE in the base table.

Basic processing steps is summarized below:



Join existing Hunter_Elements to new table provided by NSW office of Water, 197 records joined\t\t\t\t

Select where "NewSpreadsheetNSW.StateBoreID" IS NOT NULL\t\t\t\t

Update \\[FTYPE\\] from NewSpreadsheetNSW \t\t\t\t

Update \\[Status\\] from NewSpreadsheetNSW \t\t\t\t

Remove join\t\t\t\t



Now join with second spreadsheet supplied by NSW Office of Water containing High security water descriptions

Join with "UknownExport"\t\t\t\t

Update FTYPE from "UnknownsExport"\t\t\t\t

Update "FileUpdate"\t\t\t\t

Now add in high security descriptions\t\t\t\t

131 total records supplied, only \t\t\t\t

66 matches in Hunter Bores\t\t\t\t

AddField: PurposeDesc\t\t\t\t

AddField: Security\t\t\t\t

Remove join\t\t\t\t



Add join MonitoringBom\t\t\t\t

AddField: PurposeDesc + "NOW OWNED"\t\t\t\t

Now delete all non functioning bores (433 records)\t\t\t\t

Status = 'ABN' OR "Status" = 'DCM' OR "Status" = 'NON' OR "Status" = 'RMV'\t\t\t\t

However keep if have volume associated \t\t\t\t

Use "Remove from Current selection" Volper Element > 0\t\t\t\t

Leaves 389 records to be deleted (Note Back up copy created with undeleted records HunterElementsVol20150331_Merg2\t\t\t\t

7377 records remain\t\t\t\t

Now reclassify\t\t\t\t

Note mines added from GA classified FTYPE as "MINE, MNAS"\t\t\t\t

See Classificaton LUT\t\t\t\t

Join\t\t\t\t

Field calculate Asset_class\t\t\t\t



The AssetClass was then populated by the following classification



FType\t DEFINITION\t\t Class

COMS\t Water supply for commercial activities\t\t Water Access Right

DRNG\t Potable water supply i.e. drinking water\t\t Water Access Right

EXPR \t Exploration or research\t\t NULL

EXPR, MNAS\t Exploration or research, Water supply for mining activities\t\t Water Access Right

HUSE\t Water supply for household needs e.g. washing, toilet\t\t Water Access Right

INDS\t Water supply for manufacturing and industry\t\t Water Access Right

INDS, MINE\t Water supply for manufacturing and industry, Mining\t\t Water Access Right

IRAG\t Water supply for irrigated agriculture\t\t Water Access Right

MINE, MNAS\t Mining, Water supply for mining activities\t\t Water Access Right

MON\t Monitoring of groundwater conditions\t\t NULL

RECN\t Recreational purposes\t\t Water Access Right

STOK\t Water supply for livestock\t\t Basic Access Right

UNK\t Unknown i.e. purpose of groundwater feature is unknown\t\t Water Access Right

WSUP\t Water supply\t\t Water Access Right

WSUP, INDS\t Water supply, Water supply for manufacturing and industry\t\t Water Access Right

## **Dataset Citation**

Bioregional Assessment Programme (2015) Groundwater Economic Elements Hunter NSW 20150520 PersRem v02. Bioregional Assessment Derived Dataset. Viewed 13 March 2019, http://data.bioregionalassessments.gov.au/dataset/7174b44f-7146-4b70-a77f-b55c989a3278.

## **Dataset Ancestors**

* **Derived From** [GW Element Bores with Unknown FTYPE Hunter NSW Office of Water 20150514](https://data.gov.au/data/dataset/e8b6a2f3-2951-4cdd-9570-871441120e02)

* **Derived From** [Monitoring Power Generation and Water Supply Bores Hunter NOW 20150514](https://data.gov.au/data/dataset/055adb26-5b43-451c-ad21-c9063f1d5aed)

* **Derived From** [Operating Mines OZMIN Geoscience Australia 20150201](https://data.gov.au/data/dataset/65c0c042-1ba8-47a8-9793-4363672500b9)

* **Derived From** [NSW Office of Water - National Groundwater Information System 20141101v02](https://data.gov.au/data/dataset/6c364d09-fc3b-47c3-aa98-6c702d3d8137)

* **Derived From** [Groundwater Economic Assets Hunter NSW 20150331 PersRem](https://data.gov.au/data/dataset/ca620380-3d67-43bb-811a-3cafdf41056a)

* **Derived From** [Groundwater Entitlement Hunter NSW Office of Water 20150324](https://data.gov.au/data/dataset/19697f0a-4513-42a4-a7ce-4e00f48a715a)