Asset database for the Sydney Basin bioregion on 29 March 2016

## **Abstract** 

The dataset was derived by the Bioregional Assessment Programme. This dataset was derived from multiple datasets. You can find a link to the parent datasets in the Lineage Field in this metadata statement. The History Field in this metadata statement describes how this dataset was derived.

Asset database for the Sydney Basin bioregion on 29 March 2016(V3) supersedes the previous version of the SSB Asset database V2 (Asset database for the Sydney Basin bioregion on 26 February 2016, GUID: ec85b2e8-b424-4b5a-aabd-ba3e5ac5f425). It contains the Asset database (SSB_asset_database_20160329.mdb), a Geodatabase version for GIS mapping purposes (SSB_asset_database_20160329_GISOnly.gdb), the draft Water Dependent Asset Register spreadsheet (BA-SYD-SSB-130-WaterDependentAssetRegister-AssetList-v20160329.xlsx), a data dictionary (SSB_asset_database_doc_20160329.doc), and a folder (NRM_DOC) containing documentation associated with the Water Asset Information Tool (WAIT) process as outlined below. This version should be used for Materiality Test (M2) test.

The user needs to join the Table Assetlist  or Elementlist  to the spatial data.

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 Sydney regions 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 bioregion'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 Sydney bioregion 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 "SSB_asset_database_doc_20160329.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 " SSB_asset_database_doc_20160329.doc" located in the zip file. Some of the source data used in the compilation of this dataset is restricted. 

The public version of this asset database can be accessed via the following dataset:  Asset database for the Sydney Basin bioregion on 29 March 2016 Public (https://data.gov.au/data/dataset/b9ae0cb1-c58b-49be-8035-00b2a28efc47).

## **Dataset History** 

VersionID	Date_	              Notes

1.0	               3/08/2015	        Initial database.

1.1	               18/12/2015	         "(1) Added 93 assets/9897elements from 18 datasets required by SSB asset workshop.

                                                           (2) Fixed 22 AIDs in spatial data, which can not directly join  to relevant table in asset database"

2	              26/02/2016             "1) Updating for 

                                                              (a) Updated Group/SubGroup/Class of Platypus elements and assets to Ecological/ Vegetation/ Habitat (potential species distribution)

                                                              (b)Turned off all economic elements/assets from GWMP (11), SW BWR area (40) and SW WAR area (40)

                                                              (c)Add one point Economic assets from Water access licence 10CA117220 (WAL) 

                                                              (d)Turned off 382 GW point elements and reprocess GW point assets

                                                              (e)Turned off five assets (AID: 63163,63162,63161,63160,63159)  from  GMA data  

                                                              (f)Updated asset name and name rule for previous SCA assets by replacing "(SCA Water Supply Dams)" using "(Sydney water supply dams)" 

                                                              (g) Turn off all four assets of SCA water source areas(AID:  63567, 63568, 63569, 63570)

                                                              (h) Turn off 12 assets of SCA dams.

                                                         (2)Updated for M2 test results from SSB assessment team and create the draft Water Dependent Asset Register file 

                                                              (BA-SYD-SSB-130-WaterDependentAssetRegister-AssetList-v20160226.xlsx)"



3	29/03/2016	" (a) Turn off two assets of ERIN processed NSW WSP (AIDs: 62891 and 62895) using M0 test

(b) Turn of five SW economic point assets grouped by ERIN processed NSW WSP data

(c)Added 12 SW economic point assets grouped by the water rights and water sources from original NSW WSP data

(d) Added 2 NSW GW GMA assets from original NSW GW Macro Plan data using polygons intersected with SSB PAE only.

(e)Resigned GMA titles from original NSW GW Macro Plan data to NSW GW point data and got same result as the current one. The NSW GW point assets do not need regrouping."

## **Dataset Citation** 

Bioregional Assessment Programme (2015) Asset database for the Sydney Basin bioregion on 29 March 2016. Bioregional Assessment Derived Dataset. Viewed 18 June 2018, http://data.bioregionalassessments.gov.au/dataset/ae283994-5f14-4442-af0d-8f8c81eb657e.

## **Dataset Ancestors** 

* **Derived From** [Asset database for the Sydney Basin bioregion on 18 December 2015](https://data.gov.au/data/dataset/d7dd32e7-a0cc-4537-a280-c71f4be87e01)

* **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** [State Environmental Planning Policy no. 26 - Littoral Rainforest  19860101](https://data.gov.au/data/dataset/c6c20dcc-8f14-44b5-a018-b8865c4193e5)

* **Derived From** [Surface Water Entitlements in Sydney sliver between different PAEs NSW Office of Water 20150717](https://data.gov.au/data/dataset/25b3c587-7342-411b-a4a2-296efdaf8099)

* **Derived From** [Geofabric Surface Network - V2.1](https://data.gov.au/data/dataset/ed3acf9b-888c-4d53-b376-ecab89781651)

* **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** [NSW Wild Rivers Office of Environment and Heritage (OEH) 20091001](https://data.gov.au/data/dataset/817b89f1-36dd-4725-b849-d60fb45d6f31)

* **Derived From** [NSW Wetlands](https://data.gov.au/data/dataset/90476e12-77a2-4970-a0be-942eeb84e95e)

* **Derived From** [Estuarine Macrophytes of Hunter Subregion NSW DPI Hunter 2004](https://data.gov.au/data/dataset/fb7bf5a0-f0e3-429b-9b54-0d4b58fb49c2)

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

* **Derived From** [Key Environmental Assets - KEA - of the Murray Darling Basin](https://data.gov.au/data/dataset/9948195e-3d3b-49dc-96d2-ea7765297308)

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

* **Derived From** [Threatened migratory shorebird habitat mapping DECCW May 2006](https://data.gov.au/data/dataset/cc0b62a0-ded7-4c14-b954-1552337b395e)

* **Derived From** [Sydney Catchment Authority Water Licences and Approvals Package May 2012](https://data.gov.au/data/dataset/a3da31b4-1fca-4d55-addb-05d295c31427)

* **Derived From** [GW Economic Elements Sydney Basin 20150730](https://data.gov.au/data/dataset/59c19a78-ee89-4555-a57d-d57bc3c80c28)

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

* **Derived From** [NSW Office of Water SW Offtakes Processed - North & South Sydney, v3 12032014](https://data.gov.au/data/dataset/7dc3a047-19a2-46ed-b519-b5e4f393aea1)

* **Derived From** [Groundwater Entitlement NSW Office of Water 20150526  PersCom removed](https://data.gov.au/data/dataset/acca40d9-054e-4fcf-aea4-d9aad4348942)

* **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** [Native Vegetation Management (NVM) - Manage Benefits](https://data.gov.au/data/dataset/b299e256-1d37-4f89-8c51-93567ebf3753)

* **Derived From** [Illawarra Region BIO Map - Core Areas 20150430](https://data.gov.au/data/dataset/523facf7-eacd-42b8-92b3-a01a842b9b75)

* **Derived From** [Commonwealth Heritage List Spatial Database (CHL)](https://data.gov.au/data/dataset/57720684-4948-45db-a2c8-37259d531d87)

* **Derived From** [Cumberland Subregion BIO Map Biodiversity Corridors of Regional Significance 20150804](https://data.gov.au/data/dataset/223e1f69-2da8-40e3-bdb5-433df6de650c)

* **Derived From** [NSW SW Share Components NSW Office of Water 20150717](https://data.gov.au/data/dataset/0bee1a26-9072-4451-b92d-e3c3899a1a9e)

* **Derived From** [An Estuarine Inventory for New South Wales, Australia VIS_ID 2224 20100723](https://data.gov.au/data/dataset/e7d763eb-d6b8-480a-8d9e-3d6e9e0b9bc1)

* **Derived From** [Atlas of Living Australia NSW ALA Portal 20140613](https://data.gov.au/data/dataset/cb420b33-b828-40fe-a844-7fdbe828d4d6)

* **Derived From** [Purple Spotted Gudgeon NSW DPI Fisheries 20150317](https://data.gov.au/data/dataset/8e6e7bce-fce0-4dd0-b5ec-dcf513cf2213)

* **Derived From** [Identification of Culturally Significant Groundwater Dependent Ecosystems CSIRO 2010](https://data.gov.au/data/dataset/4d0bc9d9-7675-4e57-b0fd-750b323fde95)

* **Derived From** [Southeast NSW Native Vegetation Classification and Mapping - SCIVI VIS_ID 2230 20030101](https://data.gov.au/data/dataset/0f1aeb33-1b49-4839-88fa-8b635cf9d3ab)

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

* **Derived From** [State Environmental Planning Policy no. 14 - Coastal Wetlands 19891027](https://data.gov.au/data/dataset/d2ec27ef-026b-4cb8-ad12-bd1d638240d0)

* **Derived From** [NSW Office of Water Surface Water Offtakes - North & South Sydney v1 24102013](https://data.gov.au/data/dataset/4d69c8af-07cd-4dd0-b090-40060e09b35d)

* **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** [SW Economic Elements Sydney Basin 20150730](https://data.gov.au/data/dataset/4240553d-702c-4fae-b64b-074d611f2a34)

* **Derived From** [Australia World Heritage Areas](https://data.gov.au/data/dataset/4927789b-7ba7-4a77-b6fc-be1b29b6590c)

* **Derived From** [Asset database for the Sydney Basin bioregion on 26 February 2016](https://data.gov.au/data/dataset/ec85b2e8-b424-4b5a-aabd-ba3e5ac5f425)

* **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** [Macquarie Perch NSW DPI Fisheries 20150313](https://data.gov.au/data/dataset/cd5b1500-f56b-47b0-beff-5f3349493054)

* **Derived From** [Old Growth Forest Mapping Broad, Central, 1996. VIS_ID 4122 2015 20150116](https://data.gov.au/data/dataset/85a296b9-0c03-4dec-a0c1-cb22debbdbd1)

* **Derived From** [NSW Office of Water identified GDEs](https://data.gov.au/data/dataset/b6df5934-c978-471c-83a0-c55b5031f79b)

* **Derived From** [National Groundwater Management Zones BOM 20150730](https://data.gov.au/data/dataset/1004e325-f94b-44f5-89e2-9402e8f4ad67)

* **Derived From** [Illawarra Region BIO Map Corridors 20150430](https://data.gov.au/data/dataset/edd25bee-de70-47ba-a3af-b6f08846fdfa)

* **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** [Cumberland subregion BIO Map Core Areas 20150804](https://data.gov.au/data/dataset/14bda271-f0e8-4bfb-91dd-865f8b311d29)

* **Derived From** [NSW Office of Water SW Offtakes Processed - North & South Sydney, v2 07032014](https://data.gov.au/data/dataset/b1990b00-fb24-4ea1-87e9-1644addbae37)

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

* **Derived From** [Fitzroy Falls Spiny Crayfish NSW DPI Fisheries 20150316](https://data.gov.au/data/dataset/fe9241ad-79d6-43bb-922b-cb2fe86fff68)

* **Derived From** [Map of Critically Endangered Ecological Communities NSW Version 3 20150925](https://data.gov.au/data/dataset/cd7fdee5-1dec-4778-91f7-ddd43eabe8dc)

* **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 Sydney Basin bioregion on 03 August 2015](https://data.gov.au/data/dataset/e453be86-2ddc-488b-9490-2e7c9ee130b7)

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



Tags: Sydney Basin bioregion, biota, economy, environment, society
Organization: Bioregional Assessment Program