Groundwater Economic Elements Hunter NSW 20150520 PersRem v02

## **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				

Select where "NewSpreadsheetNSW.StateBoreID" IS NOT NULL				

Update \[FTYPE\] from NewSpreadsheetNSW 				

Update \[Status\] from NewSpreadsheetNSW 				

Remove join				



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

Join with "UknownExport"				

Update FTYPE from "UnknownsExport"				

Update "FileUpdate"				

Now add in high security descriptions				

131 total records supplied, only 				

66 matches in Hunter Bores				

AddField: PurposeDesc				

AddField: Security				

Remove join				



Add join MonitoringBom				

AddField: PurposeDesc + "NOW OWNED"				

Now delete all non functioning bores (433 records)				

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

However keep if have volume associated 				

Use "Remove from Current selection" Volper Element > 0				

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

7377 records remain				

Now reclassify				

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

See Classificaton LUT				

Join				

Field calculate Asset_class				



The AssetClass was then populated by the following classification



FType	                                           DEFINITION		                                                                       Class

COMS	                  Water supply for commercial activities		                                              Water Access Right

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

EXPR           	          Exploration or research		                                                                      NULL

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

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

INDS	                          Water supply for manufacturing and industry		                                      Water Access Right

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

IRAG	                          Water supply for irrigated agriculture		                                              Water Access Right

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

MON	                          Monitoring of groundwater conditions		                                              NULL

RECN	                  Recreational purposes		                                                                      Water Access Right

STOK	                  Water supply for livestock		                                                              Basic Access Right

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

WSUP	                  Water supply		                                                                                      Water Access Right

WSUP, INDS	          Water supply, Water supply for manufacturing and industry		              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)



Tags: Hunter subregion, New South Wales, economy, geoscientificInformation
Organization: Bioregional Assessment Program