Groundwater Economic Elements Hunter NSW 20150520 PersRem v02

## **Abstract** \n\nThe 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.\n\n\n\nThis dataset has been created to represent Groundwater Economic Elements (Groundwater entitlements) in the Hunter region. \n\nThis 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.\n\n## **Purpose** \n\nThe purpose of this dataset is to represent the Economic elements (Groundwater entitlements) in the Hunter PAE.\n\n## **Dataset History** \n\nThe 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.\n\n\n\nThis 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.\n\nAlso 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. \n\nThis 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.\n\nBasic processing steps is summarized below: \n\n\n\nJoin existing Hunter_Elements to new table provided by NSW office of Water, 197 records joined\t\t\t\t\n\nSelect where "NewSpreadsheetNSW.StateBoreID" IS NOT NULL\t\t\t\t\n\nUpdate \\[FTYPE\\] from NewSpreadsheetNSW \t\t\t\t\n\nUpdate \\[Status\\] from NewSpreadsheetNSW \t\t\t\t\n\nRemove join\t\t\t\t\n\n\n\nNow join with second spreadsheet supplied by NSW Office of Water containing High security water descriptions\n\nJoin with "UknownExport"\t\t\t\t\n\nUpdate FTYPE from "UnknownsExport"\t\t\t\t\n\nUpdate "FileUpdate"\t\t\t\t\n\nNow add in high security descriptions\t\t\t\t\n\n131 total records supplied, only \t\t\t\t\n\n66 matches in Hunter Bores\t\t\t\t\n\nAddField: PurposeDesc\t\t\t\t\n\nAddField: Security\t\t\t\t\n\nRemove join\t\t\t\t\n\n\n\nAdd join MonitoringBom\t\t\t\t\n\nAddField: PurposeDesc + "NOW OWNED"\t\t\t\t\n\nNow delete all non functioning bores (433 records)\t\t\t\t\n\nStatus = 'ABN' OR "Status" = 'DCM' OR "Status" = 'NON' OR "Status" = 'RMV'\t\t\t\t\n\nHowever keep if have volume associated \t\t\t\t\n\nUse "Remove from Current selection" Volper Element > 0\t\t\t\t\n\nLeaves 389 records to be deleted (Note Back up copy created with undeleted records HunterElementsVol20150331_Merg2\t\t\t\t\n\n7377 records remain\t\t\t\t\n\nNow reclassify\t\t\t\t\n\nNote mines added from GA classified FTYPE as "MINE, MNAS"\t\t\t\t\n\nSee Classificaton LUT\t\t\t\t\n\nJoin\t\t\t\t\n\nField calculate Asset_class\t\t\t\t\n\n\n\nThe AssetClass was then populated by the following classification\n\n\n\nFType\t DEFINITION\t\t Class\n\nCOMS\t Water supply for commercial activities\t\t Water Access Right\n\nDRNG\t Potable water supply i.e. drinking water\t\t Water Access Right\n\nEXPR \t Exploration or research\t\t NULL\n\nEXPR, MNAS\t Exploration or research, Water supply for mining activities\t\t Water Access Right\n\nHUSE\t Water supply for household needs e.g. washing, toilet\t\t Water Access Right\n\nINDS\t Water supply for manufacturing and industry\t\t Water Access Right\n\nINDS, MINE\t Water supply for manufacturing and industry, Mining\t\t Water Access Right\n\nIRAG\t Water supply for irrigated agriculture\t\t Water Access Right\n\nMINE, MNAS\t Mining, Water supply for mining activities\t\t Water Access Right\n\nMON\t Monitoring of groundwater conditions\t\t NULL\n\nRECN\t Recreational purposes\t\t Water Access Right\n\nSTOK\t Water supply for livestock\t\t Basic Access Right\n\nUNK\t Unknown i.e. purpose of groundwater feature is unknown\t\t Water Access Right\n\nWSUP\t Water supply\t\t Water Access Right\n\nWSUP, INDS\t Water supply, Water supply for manufacturing and industry\t\t Water Access Right\n\n## **Dataset Citation** \n\nBioregional 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.\n\n## **Dataset Ancestors** \n\n* **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)\n\n* **Derived From** [Monitoring Power Generation and Water Supply Bores Hunter NOW 20150514](https://data.gov.au/data/dataset/055adb26-5b43-451c-ad21-c9063f1d5aed)\n\n* **Derived From** [Operating Mines OZMIN Geoscience Australia 20150201](https://data.gov.au/data/dataset/65c0c042-1ba8-47a8-9793-4363672500b9)\n\n* **Derived From** [NSW Office of Water - National Groundwater Information System 20141101v02](https://data.gov.au/data/dataset/6c364d09-fc3b-47c3-aa98-6c702d3d8137)\n\n* **Derived From** [Groundwater Economic Assets Hunter NSW 20150331 PersRem](https://data.gov.au/data/dataset/ca620380-3d67-43bb-811a-3cafdf41056a)\n\n* **Derived From** [Groundwater Entitlement Hunter NSW Office of Water 20150324](https://data.gov.au/data/dataset/19697f0a-4513-42a4-a7ce-4e00f48a715a)\n\n