Asset database for the Gloucester subregion on 12 February 2016

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.

This Gloucester dataset contains v8.2 of the Asset database (GLO_asset_database_20160212.mdb), a Geodatabase version for GIS mapping purposes (GLO_asset_database_20160212_GISOnly.gdb), the draft Water Dependent Asset Register spreadsheet (BA-NSB-GLO-130-WaterDependentAssetRegister-AssetList-v20160212.xlsx), a data dictionary (GLO_asset_database_doc_20160212.doc), a folder (Indigenous_doc) containing documentation associated with Indigenous water asset project, a folder (NRM_DOC) and a folder (NRM_DOC) containing documentation associated with the Water Asset Information Tool (WAIT) process as outlined below.

The Gloucester Asset database v8.2 supersedes the previous version of the GLO Asset database in asset relevant tables/ feature class only (i.e. AssetDecisions, AssetList, Element_to_Asset, ElementList, tbl_Indigenous_water_asset, tbl_GAL_Species_TEC_decisions_review_23112015 in GLO_asset_database_20160212.mdb and GM_GLO_AssetList_pt, GM_GLO_ElementList_pt in GLO_asset_database_20160212_GISOnly.gdb). This version of GLO asset database has been updated to:

(1) Total number of registered water assets was increased by 18 due to:

(a) The 3 assets changed M2 test to "Yes" from the review done by Ecologist group.

(b) 15 indigenous water assets from OWS were added.

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 separated file geodatabase joined by AID/Element ID/BARID. 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. All reports received associated with the WAIT process for Gloucester are 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 Gloucester subregion are found in the "AssetList" table of the database. In this version of the database only M1 has been assessed. 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 "GLO_asset_database_doc_20160212.doc", located in the zip file as part of this dataset. 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 "GLO_asset_database_doc_20160212.doc" located in the zip file. The public version of this asset database can be accessed via the following dataset: Asset database for the Gloucester subregion on 12 February 2016 Public v02 (https://data.gov.au/data/dataset/5def411c-dbc4-4b75-b509-4230964ce0fa).

## **Purpose**

Used for Gloucester subregion for bioregional assessments

The public version of this asset database can be accessed via the following dataset: Asset database for the Gloucester subregion on 12 February 2016 Public v02 (https://data.gov.au/data/dataset/5def411c-dbc4-4b75-b509-4230964ce0fa).

## **Dataset History**

VersionID\tDate Notes

1.0\t 17/03/2014\t Initial database

1.01\t 19/03/2014\t Update classification using latest one

2.0\t 23/05/2014\t Update asset area for some assets

3.0\t 9/07/2014\t updated to include new assets and elements identified by community.

4.0\t 29/08/2014\t updated assets and elements from WSP

5.0\t 4/09/2014\t Table AssetDecisions is added to record decision making process and decisions about M2 are also added in table

asset list

6.0\t 8/04/2015\t 195/9 Groundwater economic point elements/assets were added in while 81/7 Groundwater economic point

elements/assets were turned off

7.0\t 27/05/2015\t The receptor data ( tables: ReceptorList, tbl_Receptors_GDE, tbl_Receptors_GW, tbl_Receptors_SW and

tbl_Receptors_SW_Catchment_Ref_Only; and spatial data: GM_GLO_ReceptorList_pt) is added

7.1\t 21/08/2015\t "(1) Delete (a) line 26 from tab "Description" and (b) column E from tab "Receptor register" about "Depth" parameters

in BA-NSB-GLO-140-ReceptorRegister-v20150821.xlsx

(2) Delete field of "Depth" from table "ReceptorList" in GLO_asset_database_20150821.mdb

(3) Add two fields of "InRegister" and "Registered Date" to table "ReceptorList" in GLO_asset_database_20150821.mdb

for the consistency with other subregions in the future"

8\t 16/09/2015\t "(1) (a) Update Latitude, Longitude, LandscapeClass using the latest data from GLO project team and update the values

for RegisteredDate, and Group using "GDE", "SW" and "GW" in table ReceptorList in

GLO_asset_database_20150916.mdb; (b) Create draft BA-NSB-GLO-140-ReceptorRegister-v20150916.xlsx

(2) Update tbl_Receptors_GDE, tbl_Receptors_GW and tbl_Receptors_SW in GLO_asset_database_20150916.mdb,

using the latest data from GLO project team.

(3) Update GM_GLO_ReceptorList_pt in GLO_asset_database_20150916_GISOnly.gdb, using the latest data from GLO

project team"



8.1\t 29/10/2015\t (a) Update LandscapeClass field in table ReceptorList for all 222 economic Receptors to match the latest decision about

this parameter (b) Create draft BA-NSB-GLO-140-ReceptorRegister-v20151029.xlsx



8.2\t 12/02/2016\t "(1) Total number of registered water assets was increased by 18 due to:

(a) The 3 assets changed M2 test to "Yes" from the review done by Ecologist group. The original data is included the

database as the table tbl_GLO_Species_TEC_decisions_review_23112015

(b) 15 indigenous water assets from OWS were added. The data and documents from OWS are included in

subdirectory Indigenous_doc

(c)The draft new Water Dependent Asset Register file (BA-NSB-GLO-130-WaterDependentAssetRegister-AssetList-

v20160212.xlsx) was created"



The source metadata was updated to meet the purpose of the Bioregional Assessment Programme

## **Dataset Citation**

Bioregional Assessment Programme (2014) Asset database for the Gloucester subregion on 12 February 2016. Bioregional Assessment Derived Dataset. Viewed 18 July 2018, http://data.bioregionalassessments.gov.au/dataset/72a47bec-1393-49d6-b379-0e48551d26a9.

## **Dataset Ancestors**

* **Derived From** [Standard Instrument Local Environmental Plan (LEP) - Heritage (HER) (NSW)](https://data.gov.au/data/dataset/fd1ff106-2f48-4bda-bfd1-a7206747c483)

* **Derived From** [NSW Office of Water GW licence extract linked to spatial locations - GLO v5 UID elements 27032014](https://data.gov.au/data/dataset/0115c2ba-73c6-4c98-b539-9f67594980cf)

* **Derived From** [Asset database for the Gloucester subregion on 21 August 2015](https://data.gov.au/data/dataset/0811c5c0-ddd3-41ac-9328-9fd321fd6124)

* **Derived From** [Gloucester digitised coal mine boundaries](https://data.gov.au/data/dataset/be85b60f-49dd-485c-bb85-11d45de9792d)

* **Derived From** [Groundwater Dependent Ecosystems supplied by the NSW Office of Water on 13/05/2014](https://data.gov.au/data/dataset/1bdc6089-c114-4485-b962-35a8b3d2357f)

* **Derived From** [NSW Office of Water GW licence extract linked to spatial locations GLOv4 UID 14032014](https://data.gov.au/data/dataset/98341388-5705-4c42-9f7a-186e16647614)

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

* **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 Gloucester subregion on 16 September 2015](https://data.gov.au/data/dataset/480d6775-35eb-4eb2-9e2b-d27f0798d4bc)

* **Derived From** [GEODATA 9 second DEM and D8: Digital Elevation Model Version 3 and Flow Direction Grid 2008](https://data.gov.au/data/dataset/ebcf6ca2-513a-4ec7-9323-73508c5d7b93)

* **Derived From** [National Groundwater Information System (NGIS) v1.1](https://data.gov.au/data/dataset/e157b1cd-3cb7-4cf9-a13c-a6bed576b8c7)

* **Derived From** [Groundwater Entitlement Data GLO NSW Office of Water 20150320 PersRemoved](https://data.gov.au/data/dataset/5afdddd5-f5b5-42d1-8ca6-8db19ecf1fd3)

* **Derived From** [Asset database for the Gloucester subregion on 29 October 2015](https://data.gov.au/data/dataset/85954bcb-3fc6-4b17-a35c-705b5093bec5)

* **Derived From** [Geofabric Surface Cartography - V2.1](https://data.gov.au/data/dataset/5342c4ba-f094-4ac5-a65d-071ff5c642bc)

* **Derived From** [Groundwater Entitlement Data Gloucester - NSW Office of Water 20150320](https://data.gov.au/data/dataset/bf435e81-60d4-40c7-ac00-76585fc1fe77)

* **Derived From** [Collaborative Australian Protected Areas Database (CAPAD) 2010 - External Restricted](https://data.gov.au/data/dataset/47312aee-722e-4c6e-bef8-9e439480503e)

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

* **Derived From** [EIS Gloucester Coal 2010](https://data.gov.au/data/dataset/04c22c59-2f7c-4ba6-a192-7bfb89f6b98d)

* **Derived From** [Report for Director Generals Requirement Rocky Hill Project 2012](https://data.gov.au/data/dataset/d8837d3d-91bb-4496-814e-e707cf65fbb2)

* **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** [Asset database for the Gloucester subregion on 28 May 2015](https://data.gov.au/data/dataset/5815842e-d271-4f73-9d1a-d15c90571330)

* **Derived From** [NSW Office of Water GW licence extract linked to spatial locations GLOv3 12032014](https://data.gov.au/data/dataset/587c6834-09aa-4cd8-8972-5632880f5ae5)

* **Derived From** [EIS for Rocky Hill Coal Project 2013](https://data.gov.au/data/dataset/ebc1abb5-8b0e-43fa-95e3-2c49dd3343d7)

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

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

* **Derived From** [Gloucester - Additional assets from local councils](https://data.gov.au/data/dataset/47e9540a-dd75-4e04-bddb-574de1b89ecb)

* **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 Gloucester subregion on 29 August 2014](https://data.gov.au/data/dataset/7000a82c-85f2-461a-ba35-9d7d1ba6d339)

* **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** [Groundwater Modelling Report for Stratford Coal Mine](https://data.gov.au/data/dataset/4a9d9e6c-8d12-4d9c-837f-5c63fa03472a)

* **Derived From** [Groundwater Economic Assets GLO 20150326](https://data.gov.au/data/dataset/2e314212-0677-40b8-86ff-c5166c6906bd)

* **Derived From** [NSW Office of Water Groundwater Licence Extract Gloucester - Oct 2013](https://data.gov.au/data/dataset/56a49393-abaa-43f2-8b7d-97c5d414c1cf)

* **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** [Freshwater Fish Biodiversity Hotspots](https://data.gov.au/data/dataset/6093bd55-a978-4fcc-a8fa-6881fa015329)

* **Derived From** [NSW Office of Water Groundwater licence extract linked to spatial locations GLOv2 19022014](https://data.gov.au/data/dataset/38c9e2c9-02ac-45a8-a188-936f91a58391)

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

* **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** [Asset database for the Gloucester subregion on 8 April 2015](https://data.gov.au/data/dataset/d559e708-089a-46bc-bad2-dc5068993574)

* **Derived From** [GLO Receptors 20150828](https://data.gov.au/data/dataset/acdd94a6-5201-4026-8177-035f25077587)

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

* **Derived From** [Asset database for the Gloucester subregion on 12 September 2014](https://data.gov.au/data/dataset/d0c21c5c-1b30-4aae-933a-71145b935cc6)