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
