Asset database for the Hunter subregion on 08 September 2015

## **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.2 supersedes previous versions of the Hunter Asset database (Asset database for the Hunter subregion on 27 August 2015, 9e1c414c-1752-4bd8-83ff-c137b7d9f9ce).

This dataset contains the Asset database (.mdb), a Geodatabase version for GIS mapping purposes (.gdb), the Water Dependent Asset Register spreadsheet, a data dictionary document, and a folder (NRM_DOC) containing documentation associated with the 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_20150908.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_20150908.doc" located in this file.



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

## **Dataset History** 

VersionID	Date_	Notes

1	29/08/2014	Initial database.

1.1	16/09/2014	Update the classification for seven identical assets from Gloucester subregion

1.2	28/01/2015	Added in NSW GDEs from Hunter - Central Rivers GDE mapping from NSW DPI (50 635 polygons).

1.3	12/02/2015	New AIDs assiged to NSW GDE assets (Existing AID + 20000) to avoid duplication of AIDs assigned in other databases.



1.4	16/06/2015	"(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"



2	20/07/2015	"(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"



2.1	27/08/2015	"(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)"



Hunter Asset Database v2.2 supersedes previous versions of the Hunter Asset database. In this V2.2 database, we:

(1) Updated M2 results from the internal review for 386 Socio-cultural 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 as requested by HUN project team.



Hunter Asset Database v2.1, whcih is also useful,  supersedes previous versions of the Hunter Asset database. In this V2.1 database:

(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)

AID_from_HUN	AID_from_GIP

60715	11636

60752	12791

60753	12807

60759	12731

60763	12774

60770	12748

(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)



2.2	8/09/2015	"(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"

## **Dataset Citation** 

Bioregional Assessment Programme (2015) Asset database for the Hunter subregion on 08 September 2015. Bioregional Assessment Derived Dataset. Viewed 09 May 2017, http://data.bioregionalassessments.gov.au/dataset/536032d3-b022-4459-b9c5-aaa6c3bb362e.

## **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** [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** [Groundwater Economic Elements Hunter NSW 20150520 PersRem v02](https://data.gov.au/data/dataset/7174b44f-7146-4b70-a77f-b55c989a3278)

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

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

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

* **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** [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 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** [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** [Fauna Corridors for North East NSW](https://data.gov.au/data/dataset/c8b21575-8003-41ba-bb7e-378c2eb3486d)

* **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** [Gosford Council Endangered Ecological Communities (Umina woodlands) EEC3906](https://data.gov.au/data/dataset/485b84ef-7f56-40b3-bf25-5ba359dd4623)

* **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** [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)



Tags: Hunter subregion, biota, economy, environment, society
Organization: Bioregional Assessment Program