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



This dataset contains v8 of the Asset database (GLO_asset_database_20150916.mdb), a Geodatabase version for GIS mapping purposes (GLO_asset_database_20150916_GISOnly.gdb), the draft Receptor Register spreadsheet (BA-NSB-GLO-140-ReceptorRegister-v20150916.xlsx), a data dictionary (GLO_asset_database_doc_20150916.doc) and a folder (NRM_DOC) containing documentation associated with the WAIT process as outlined below.



The Gloucester Asset database v8 supersedes the previous version of the GLO Asset database in Receptor relevant tables/ feature class  only (i.e.  ReceptorList,  tbl_Receptors_GDE, tbl_Receptors_GW,  tbl_Receptors_SW,  tbl_Receptors_SW_Catchment_Ref_Only and  GM_GLO_ReceptorList_pt). The location of Receptor is from GDA 94 datum.



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. 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_20150916.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_0150916.doc" located in the zip file. Some of the source data used in the compilation of this dataset is restricted.

## **Dataset History** 

VersionID	Date	Notes

1.0	17/03/2014	Initial database

1.01	19/03/2014	Update classification using latest one

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

3.0	9/07/2014	        Updated to include new assets and elements identified by community.

4.0	29/08/2014	Updated assets and elements from WSP

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

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

7.0	27/05/2015	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	21/08/2015	(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	16/09/2015	(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"

## **Dataset Citation** 

Bioregional Assessment Programme (2014) Asset database for the Gloucester subregion on 16 September 2015. Bioregional Assessment Derived Dataset. Viewed 18 July 2018, http://data.bioregionalassessments.gov.au/dataset/480d6775-35eb-4eb2-9e2b-d27f0798d4bc.

## **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** [Groundwater Economic Assets GLO 20150326](https://data.gov.au/data/dataset/2e314212-0677-40b8-86ff-c5166c6906bd)

* **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 12 September 2014](https://data.gov.au/data/dataset/d0c21c5c-1b30-4aae-933a-71145b935cc6)

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

* **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** [Asset database for the Gloucester subregion on 21 August 2015](https://data.gov.au/data/dataset/0811c5c0-ddd3-41ac-9328-9fd321fd6124)

* **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** [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 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** [NSW Office of Water Groundwater Entitlements Spatial Locations](https://data.gov.au/data/dataset/0f4da0d0-9e82-42f3-84da-1148e0b730c1)

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

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

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



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