Asset database for the Gwydir subregion on 24 August 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 database is an update (v2) of the initial asset database for the Gwydir subregion (titled "Asset database for the Gwydir subregion on 8 May 2015", ID 429a2721-6fc1-4f3b-96d1-3eaeaa98a993).



This dataset contains a combination of spatial and non-spatial (attribute) components of the Gwydir subregion Asset List - an mdb file (readable as an MS Access database or as an ESRI personal geodatabase) holds the non-spatial tabular attribute data, and an ESRI file geodatabase contains the spatial data layers, which are attributed only with unique identifiers ("AID" for assets, and "ElementID" for elements). The dataset also contains a draft "Water-dependent asset register and asset list" spreadsheet (BA-NIC-GWY-130-WaterDependentAssetRegister-AssetList-V20150824.xlsx).



The tabular attribute data can be joined in a GIS to the "Assetlist" table in the mdb database using the "AID" field to view asset attributes (BA attribution). To view the more detailed attribution at the element-level, the intermediate table "Element_to_asset" can be joined to the assets spatial datasets using AID, and then joining the individual attribute tables from the Access database using the common "ElementID" fields.  Alternatively, the spatial feature layers representing elements can be linked directly to the individual attribute tables in the Access database  using "ElementID", but this arrangement will not provide the asset-level groupings.



Further information is provided in the accompanying document, "GWY_asset_database_doc20150824.doc" located within this dataset.

## **Dataset History** 

VersionID	Date                Notes

1.0	        8/05/2015	Initial database

2.0	        24/08/2015     v2 - additions as follows:



(1) At the request of NSW OEH, data identifying species and ecological communities listed under NSW legislation has been included in two additional attribute tables "NSW_TS" and "NSW_TEC" (a total of 110 elements and assets, AIDs 70150-70259). However, given the extremely course catchment-scale resolution of the data as compared to the relatively fine-scale of the PAE, it is essentially a non-spatial list of species and communities which may or may not occur within the PAE. As the data was unable to be meaningfully used as a spatial dataset it was subsequently "turned off" at decision M0 (not fit for purpose), with the decision reflected in the "Assetlist"and "AssetDecisions" tables. Although they are included in the asset database, these new assets are not included in the asset count for GWY.

(2) The database has been updated to include M2 (water dependency) test results from the GWY project team, and a draft "Water-dependent asset register and asset list" spreadsheet (BA-NIC-GWY-130-WaterDependentAssetRegister-AssetList-V20150824.xlsx) has been created and is included in this dataset. 

(3) Four queries have been added to the non-spatial database (mdb) (Find_All_Used_Assets, Find_All_WD_Assets, Find_Amount_Asset_in_Class and Find_Amount_Elements_in_Class) to assist project teams to identify and calculate figures to be published.



Further information is contained in the associate document "GWY_asset_database_doc_20150824.doc".

## **Dataset Citation** 

Bioregional Assessment Programme (2013) Asset database for the Gwydir subregion on 24 August 2015. Bioregional Assessment Derived Dataset. Viewed 08 February 2017, http://data.bioregionalassessments.gov.au/dataset/7350df87-5103-40f5-b82c-42b0fc59a6a5.

## **Dataset Ancestors** 

* **Derived From** [NSW Office of Water GW licence extract linked to spatial locations NIC v2 (28 February 2014)](https://data.gov.au/data/dataset/505e8a67-90b4-408a-aa0d-038a9fb14f42)

* **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** [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** [NSW Office of Water Surface Water Licences in NIC linked to locations v1 (22 April 2014)](https://data.gov.au/data/dataset/5f0f242b-3f0f-4c7d-bdb2-5ce7b1af6976)

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

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

* **Derived From** [Environmental Asset Database - Commonwealth Environmental Water Office](https://data.gov.au/data/dataset/29fd1654-8aa1-4cb3-b65e-0b37698ac9a6)

* **Derived From** [Ecological assets of the Gwydir wetlands and floodplain  2008  VIS_ID 3923](https://data.gov.au/data/dataset/d8a08865-a79a-4411-8f99-7bbb730fc58c)

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

* **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** [Key Environmental Assets - KEA - of the Murray Darling Basin](https://data.gov.au/data/dataset/9948195e-3d3b-49dc-96d2-ea7765297308)

* **Derived From** [Asset database for the Gwydir subregion on 8 May 2015](https://data.gov.au/data/dataset/429a2721-6fc1-4f3b-96d1-3eaeaa98a993)

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

* **Derived From** [Great Artesian Basin and Laura Basin groundwater recharge areas](https://data.gov.au/data/dataset/8c646031-9765-4d7b-97df-a0869d66eabe)

* **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** [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** [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** [Collaborative Australian Protected Areas Database (CAPAD) 2010 (Not current release)](https://data.gov.au/data/dataset/7b649c6d-fdbf-40e3-b002-db521665af53)

* **Derived From** [Australia - Species of National Environmental Significance Database](https://data.gov.au/data/dataset/4eff885b-0d68-45e8-b4b1-e3e5448354eb)

* **Derived From** [NSW Office of Water Surface Water Offtakes - NIC v1 20131024](https://data.gov.au/data/dataset/7dd7c978-299f-4d20-8c66-6c951d26fac8)

* **Derived From** [NSW Office of Water Groundwater Licence Extract NIC-  Oct 2013](https://data.gov.au/data/dataset/808fd05a-f451-4170-a1d3-8439105c0273)

* **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** [National Groundwater Dependent Ecosystems (GDE) Atlas](https://data.gov.au/data/dataset/e358e0c8-7b83-4179-b321-3b4b70df857d)

* **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** [NSW Office of Water Groundwater licences extract linked to spatial locations NIC v3 (13 March 2014)](https://data.gov.au/data/dataset/b0ea1363-4603-463a-b82e-fc586db6b967)



Tags: Gwydir subregion, economy, environment
Organization: Bioregional Assessment Program