Asset database for the Hunter subregion on 20 November 2015

Brief description

## **Abstract**



The dataset was derived by the Bioregional Assessment Programme from multiple source datasets. The source datasets are identified in the Lineage field in this metadata statement. The processes undertaken to produce this derived dataset are described in the History field in this metadata statement.

Hunter Asset Database v2.4 supersedes previous versions of the Hunter Asset database. In this V2.4 database:

(1) Updated M2 test results for 86 assets from the external review

(2) Updated asset names for two assets (AID: 8642 and 8643) required from the external review

(3) Created Draft Water Dependent Asset Register file using the template V5





This dataset contains the Asset database (.mdb), a Geodatabase version for GIS mapping purposes (.gdb), the draft Water Dependent Asset Register spreadsheet, a data dictionary document, and a folder (NRM_DOC) containing documentation associated with the Water Asset Information Tool (WAIT) process as outlined below.



The Asset database is registered to the BA repository as an ESRI personal goedatabase (.mdb - doubling as a MS Access database) that can store, query, and manage non-spatial data while the spatial data is in a separate file geodatabase joined by AID/ElementID.

Under the BA program, a spatial assets database is developed for each defined bioregional assessment project. The spatial elements that underpin the identification of water dependent assets are identified in the first instance by regional NRM organisations (via the WAIT tool) and supplemented with additional elements from national and state/territory government datasets. A report on the WAIT process for the Hunter is included in the zip file as part of this dataset.



Elements are initially included in the preliminary assets database if they are partly or wholly within the subregion's preliminary assessment extent (Materiality Test 1, M1). Elements are then grouped into assets which are evaluated by project teams to determine whether they meet the second Materiality Test (M2). Assets meeting both Materiality Tests comprise the water dependent asset list. Descriptions of the assets identified in the Hunter subregion are found in the "AssetList" table of the database.



Assets are the spatial features used by project teams to model scenarios under the BA program. Detailed attribution does not exist at the asset level. Asset attribution includes only the core set of BA-derived attributes reflecting the BA classification hierarchy, as described in Appendix A of " HUN_asset_database_doc_20151120.doc", located in this filet.



The "Element_to_Asset" table contains the relationships and identifies the elements that were grouped to create each asset.



Detailed information describing the database structure and content can be found in the document " HUN_asset_database_doc_20151120.doc" located in this file.



Some of the source data used in the compilation of this dataset is restricted.





## **Dataset History**

OBJECTID\tVersionID\tNotes\tDate_

1\t1\tInitial database.\t29/08/2014

3\t1.1\tUpdate the classification for seven identical assets from Gloucester subregion\t16/09/2014

4\t1.2\tAdded in NSW GDEs from Hunter - Central Rivers GDE mapping from NSW DPI (50 635 polygons).\t28/01/2015

5\t1.3\tNew AIDs assiged to NSW GDE assets (Existing AID + 20000) to avoid duplication of AIDs assigned in other databases.\t12/02/2015

6\t1.4\t"(1) Add 20 additional datasets required by HUN assessment project team after HUN community workshop

(2) Turn off previous GW point assets (AIDs from 7717-7810 inclusive)

(3) Turn off new GW point asset (AID: 0)

(4) Assets (AIDs: 8023-8026) are duplicated to 4 assets (AID: 4747,4745,4744,4743 respectively) in NAM subregion . Their AID, Asset Name, Group, SubGroup, Depth, Source, ListDate and Geometry are using

values from that NAM assets.

(5) Asset (AID 8595) is duplicated to 1 asset ( AID 57) in GLO subregion . Its AID, Asset Name, Group, SubGroup, Depth, Source, ListDate and Geometry are using values from that GLO assets.

(6) 39 assets (AID from 2969 to 5040) are from NAM Asset database and their attributes were updated to use the latest attributes from NAM asset database

(7)The databases, especially spatial database, were changed such as duplicated attributes fields in spatial data were removed and only ID field is kept. The user needs to join the Table Assetlist or Elementlist to

the spatial data"\t16/06/2015

7\t2\t"(1) Updated 131 new GW point assets with previous AID and some of them may include different element number due to the change of 77 FTypes requested by Hunter assessment project team

(2) Added 104 EPBC assets, which were assessed and excluded by ERIN

(3) Merged 30 Darling Hardyhead assets to one (asset AID 60140) and deleted another 29

(4) Turned off 5 assets from community workshop (60358 - 60362) as they are duplicated to 5 assets from 104 EPBC excluded assets

(5) Updated M2 test results

(6) Asset Names (AID: 4743 and 4747) were changed as requested by Hunter assessment project team (4 lower cases to 4 upper case only). Those two assets are from Namoi asset database and their asset names

may not match with original names in Namoi asset database.

(7)One NSW WSP asset (AID: 60814) was added in as requested by Hunter assessment project team. The process method (without considering 1:M relation) for this asset is not robust and is different to other NSW

WSP assets. It should NOT use for other subregions.

(8) Queries of Find_All_Used_Assets and Find_All_WD_Assets in the asset database can be used to extract all used assts and all water dependant assts"\t20/07/2015

8\t2.1\t"(1) There are following six assets (in Hun subregion), which is same as 6 assets in GIP subregion. Their AID, Asset Name, Group, SubGroup, Depth, Source and ListDate are using values from GIP assets. You will

not see AIDs from AID_from_HUN in whole HUN asset datable and spreadsheet anymore and you only can see AIDs from AID_from_GIP ( Actually (a) AID 11636 is GIP got from MBC (B) only AID, Asset Name

and ListDate are different and changed)

(2) For BA-NSB-HUN-130-WaterDependentAssetRegister-AssetList-V20150827.xlsx, (a) Extracted long ( >255 characters) WD rationale for 19 assets (AIDs:

8682,9065,9073,9087,9088,9100,9102,9103,60000,60001,60792,60793,60801,60713,60739,60751,60764,60774,60812 ) in tab "Water-dependent asset register" and 37 assets (AIDs:

5040,8651,8677,8682,8650,8686,8687,8718,8762,9094,9065,9067,9073,9077,9081,9086,9087,9088,9100,9102,9103,60000,60001,60739,60742,60751,60713,60764,60771,

60774,60792,60793,60798,60801,60809,60811,60812) in tab "Asset list" in 1.30 Excel file (b) recreated draft BA-NSB-HUN-130-WaterDependentAssetRegister-AssetList-V20150827.xlsx

(3) Modified queries (Find_All_Asset_List and Find_Waterdependent_asset_register) for (2)(a)"\t27/08/2015



9\t2.2\t"(1) Updated M2 results from the internal review for 386 Sociocultural assets

(2)Updated the class to Ecological/Vegetation/Habitat (potential species distribution) for assets/elements from sources of WAIT_ALA_ERIN, NSW_TSEC, NSW_DPI_Fisheries_DarlingHardyhead"\t8/09/2015



10\t2.3\t"(1) Updated M2 results from the internal review

\\*\tChanged "Assessment team do not say No" to "All economic assets are by definition water dependent"

\\*\tChanged "Assessment team say No" : to "These are water dependent, but excluded by the project team based on intersection with the PAE is negligible"

\\*\tChanged "Rivertyles" to "RiverStyles""\t22/09/2015



11\t2.4\t"(1) Updated M2 test results for 86 assets from the external review

(2) Updated asset names for two assets (AID: 8642 and 8643) required from the external review

(3) Created Draft Water Dependent Asset Register file using the template V5"\t20/11/2015

## **Dataset Citation**

Bioregional Assessment Programme (2015) Asset database for the Hunter subregion on 20 November 2015. Bioregional Assessment Derived Dataset. Viewed 07 June 2018, http://data.bioregionalassessments.gov.au/dataset/0bbcd7f6-2d09-418c-9549-8cbd9520ce18.

## **Dataset Ancestors**

* **Derived From** [NSW Office of Water Surface Water Entitlements Locations v1_Oct2013](https://data.gov.au/data/dataset/fc872710-998e-4c76-8b98-1df383c53de6)

* **Derived From** [Travelling Stock Route Conservation Values](https://data.gov.au/data/dataset/198900d5-0d06-4bd0-832b-e30a7c4e8873)

* **Derived From** [Spatial Threatened Species and Communities (TESC) NSW 20131129](https://data.gov.au/data/dataset/a6664894-1489-46d1-a6ca-16f9ab519a28)

* **Derived From** [NSW Wetlands](https://data.gov.au/data/dataset/90476e12-77a2-4970-a0be-942eeb84e95e)

* **Derived From** [Climate Change Corridors Coastal North East NSW](https://data.gov.au/data/dataset/0a1b4dc6-07a4-4f2b-acc2-000eed75db22)

* **Derived From** [Communities of National Environmental Significance Database - RESTRICTED - Metadata only](https://data.gov.au/data/dataset/c01c4693-0a51-4dbc-bbbd-7a07952aa5f6)

* **Derived From** [Climate Change Corridors for Nandewar and New England Tablelands](https://data.gov.au/data/dataset/d480bd52-c46a-41ae-bab8-0e8d7620160b)

* **Derived From** [National Groundwater Dependent Ecosystems (GDE) Atlas](https://data.gov.au/data/dataset/e358e0c8-7b83-4179-b321-3b4b70df857d)

* **Derived From** [Asset database for the Hunter subregion on 27 August 2015](https://data.gov.au/data/dataset/9e1c414c-1752-4bd8-83ff-c137b7d9f9ce)

* **Derived From** [Birds Australia - Important Bird Areas (IBA) 2009](https://data.gov.au/data/dataset/5d488350-83b6-4e71-8d17-687ad8ff9941)

* **Derived From** [Estuarine Macrophytes of Hunter Subregion NSW DPI Hunter 2004](https://data.gov.au/data/dataset/fb7bf5a0-f0e3-429b-9b54-0d4b58fb49c2)

* **Derived From** [Hunter CMA GDEs (DRAFT DPI pre-release)](https://data.gov.au/data/dataset/469d6d2e-900f-47a7-a137-946b89b3d188)

* **Derived From** [Camerons Gorge Grassy White Box Endangered Ecological Community (EEC) 2008](https://data.gov.au/data/dataset/cc77d836-86d3-429d-b0ab-1599cff00414)

* **Derived From** [NSW Office of Water Surface Water Licences Processed for Hunter v1 20140516](https://data.gov.au/data/dataset/25d233eb-dbc4-4ca3-b200-1d1df2b5126c)

* **Derived From** [Threatened migratory shorebird habitat mapping DECCW May 2006](https://data.gov.au/data/dataset/cc0b62a0-ded7-4c14-b954-1552337b395e)

* **Derived From** [Asset database for the Hunter subregion on 12 February 2015](https://data.gov.au/data/dataset/dcf8349e-aaed-4d30-80ab-1c8cbad8fe68)

* **Derived From** [NSW Office of Water Surface Water Offtakes - Hunter v1 24102013](https://data.gov.au/data/dataset/d94064ab-6d03-4a40-9484-1579afa9269b)

* **Derived From** [National Groundwater Dependent Ecosystems (GDE) Atlas (including WA)](https://data.gov.au/data/dataset/6dbaee0d-8813-46b1-9c13-1b796e7ed3bf)

* **Derived From** [Asset list for Hunter - CURRENT](https://data.gov.au/data/dataset/51b1e021-2958-4cd3-8daa-ba46ece09d1c)

* **Derived From** [Species Profile and Threats Database (SPRAT) - Australia - Species of National Environmental Significance Database (BA subset - RESTRICTED - Metadata only)](https://data.gov.au/data/dataset/7276dd93-cc8c-4c01-8df0-cef743c72112)

* **Derived From** [Ramsar Wetlands of Australia](https://data.gov.au/data/dataset/d65cc156-944d-4961-bfba-eacfd61db63a)

* **Derived From** [Native Vegetation Management (NVM) - Manage Benefits](https://data.gov.au/data/dataset/b299e256-1d37-4f89-8c51-93567ebf3753)

* **Derived From** [Commonwealth Heritage List Spatial Database (CHL)](https://data.gov.au/data/dataset/57720684-4948-45db-a2c8-37259d531d87)

* **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** [Atlas of Living Australia NSW ALA Portal 20140613](https://data.gov.au/data/dataset/cb420b33-b828-40fe-a844-7fdbe828d4d6)

* **Derived From** [Gosford Council Endangered Ecological Communities (Umina woodlands) EEC3906](https://data.gov.au/data/dataset/485b84ef-7f56-40b3-bf25-5ba359dd4623)

* **Derived From** [National Heritage List Spatial Database (NHL) (v2.1)](https://data.gov.au/data/dataset/26daa8d7-a90e-47f3-982b-0df362414e65)

* **Derived From** [Climate Change Corridors (Dry Habitat) for North East NSW](https://data.gov.au/data/dataset/8871574a-62ac-4b59-9cc3-bc991a6abd57)

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

* **Derived From** [Asset database for the Hunter subregion on 20 July 2015](https://data.gov.au/data/dataset/35bc515e-581a-4a7f-ae2a-c0b62b2c9169)

* **Derived From** [NSW Office of Water combined geodatabase of regulated rivers and water sharing plan regions](https://data.gov.au/data/dataset/24157c41-c42f-4e1f-a791-a1ad18c8215d)

* **Derived From** [Asset database for the Hunter subregion on 22 September 2015](https://data.gov.au/data/dataset/59d91125-2b58-4680-9ef0-645d77a9f76d)

* **Derived From** [Asset database for the Hunter subregion on 16 June 2015](https://data.gov.au/data/dataset/24f007de-94e1-4a50-b8e8-46d5cceb5c66)

* **Derived From** [Australia World Heritage Areas](https://data.gov.au/data/dataset/4927789b-7ba7-4a77-b6fc-be1b29b6590c)

* **Derived From** [Lower Hunter Spotted Gum Forest EEC 2010](https://data.gov.au/data/dataset/5a8f525b-d602-4120-99a3-900fc05180e7)

* **Derived From** [New South Wales NSW Regional CMA Water Asset Information WAIT tool databases, RESTRICTED Includes ALL Reports](https://data.gov.au/data/dataset/a2a929ea-2cb3-42ab-86b9-87deac68acae)

* **Derived From** [Fauna Corridors for North East NSW](https://data.gov.au/data/dataset/c8b21575-8003-41ba-bb7e-378c2eb3486d)

* **Derived From** [Groundwater Economic Elements Hunter NSW 20150520 PersRem v02](https://data.gov.au/data/dataset/7174b44f-7146-4b70-a77f-b55c989a3278)

* **Derived From** [Directory of Important Wetlands in Australia (DIWA) Spatial Database (Public)](https://data.gov.au/data/dataset/6636846e-e330-4110-afbb-7b89491fe567)

* **Derived From** [HUN AssetList Database v1p2 20150128](https://data.gov.au/data/dataset/64ecd565-bb7c-4f21-951e-f35966b91c99)

* **Derived From** [New South Wales NSW - Regional - CMA - Water Asset Information Tool - WAIT - databases](https://data.gov.au/data/dataset/330532aa-66ba-44f5-984b-8a21a99661a0)

* **Derived From** [Climate Change Corridors (Moist Habitat) for North East NSW](https://data.gov.au/data/dataset/f8445d2e-ec1f-4f5a-99cc-7f90d1f96103)

* **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** [Australia - Species of National Environmental Significance Database](https://data.gov.au/data/dataset/4eff885b-0d68-45e8-b4b1-e3e5448354eb)

* **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** [Northern Rivers CMA GDEs (DRAFT DPI pre-release)](https://data.gov.au/data/dataset/ac1bd285-5f50-46e2-bc04-b21e8e182a62)

* **Derived From** [NSW Office of Water GW licence extract linked to spatial locations for NorthandSouthSydney v3 13032014](https://data.gov.au/data/dataset/6860cabb-372d-40c8-9ae8-f097021d35ef)

* **Derived From** [Australia, Register of the National Estate (RNE) - Spatial Database (RNESDB) Internal](https://data.gov.au/data/dataset/878f6780-be97-469b-8517-54bd12a407d0)

* **Derived From** [NSW Office of Water Groundwater Entitlements Spatial Locations](https://data.gov.au/data/dataset/0f4da0d0-9e82-42f3-84da-1148e0b730c1)

* **Derived From** [NSW Office of Water Groundwater Licence Extract, North and South Sydney - Oct 2013](https://data.gov.au/data/dataset/b48f941e-b557-411f-aebd-e3c463b60614)

* **Derived From** [NSW Office of Water - GW licence extract linked to spatial locations for North and South Sydney v2 20140228](https://data.gov.au/data/dataset/0e6034bc-7a91-46c9-80e0-0e3330a0b7da)

* **Derived From** [Collaborative Australian Protected Areas Database (CAPAD) 2010 (Not current release)](https://data.gov.au/data/dataset/7b649c6d-fdbf-40e3-b002-db521665af53)

* **Derived From** [Darling River Hardyhead Predicted Distribution in Hunter River Catchment NSW 2015](https://data.gov.au/data/dataset/643c6228-6435-4f5a-9f09-5f53efe234d2)