Asset database for the Hunter subregion on 16 June 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. 



This dataset supersedes the previous version (Asset database for the Hunter subregion on 12 February 2015; GUID = dcf8349e-aaed-4d30-80ab-1c8cbad8fe68)

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_20150616.doc", located in this file.



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_20150616.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"

## **Dataset Citation** 

Bioregional Assessment Programme (2015) Asset database for the Hunter subregion on 16 June 2015. Bioregional Assessment Derived Dataset. Viewed 13 March 2019, http://data.bioregionalassessments.gov.au/dataset/24f007de-94e1-4a50-b8e8-46d5cceb5c66.

## **Dataset Ancestors** 

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

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

* **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 GW licence extract linked to spatial locations for NorthandSouthSydney v3 13032014](https://data.gov.au/data/dataset/6860cabb-372d-40c8-9ae8-f097021d35ef)

* **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** [NSW Office of Water Surface Water Entitlements Locations v1_Oct2013](https://data.gov.au/data/dataset/fc872710-998e-4c76-8b98-1df383c53de6)

* **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** [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** [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** [Threatened migratory shorebird habitat mapping DECCW May 2006](https://data.gov.au/data/dataset/cc0b62a0-ded7-4c14-b954-1552337b395e)

* **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** [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 Surface Water Offtakes - Hunter v1 24102013](https://data.gov.au/data/dataset/d94064ab-6d03-4a40-9484-1579afa9269b)

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