Asset database for the Pedirka subregion on 27 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. 



The asset database for the Pedirka subregion (v3) supersedes previous version (v2) of the Pedirka Asset database (Asset database for the Arckaringa subregion on 07 August 2015, 3c976085-ff75-44c7-a3b1-9608f6a6a994).  The M2_Reason in the Assetlist table and DecisionBrief in the AssetDecisions table have been updated with short descriptions (<255 characters) provided by project team 21/8, and the draft  "water-dependent asset register and asset list" (BA-LEB-PED-130-WaterDependentAssetRegister-AssetList-V20150827) also updated accordingly. This change was made to avoid truncation in the brief reasons fields of the database and asset register. There have been no changes to assets or asset numbers.

 

This dataset contains a combination of spatial and non-spatial (attribute) components of the Pedirka 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 an update of the draft "Water-dependent asset register and asset list" spreadsheet (BA-NIC-PED-130-WaterDependentAssetRegister-AssetList-V20150827.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, "PED_asset_database_doc20150827.doc" located within this dataset.

## **Dataset History** 

VersionID	Date	Notes

1.0	13/03/2015	Initial database



1.1	19/03/2015	Add SA point Eco data (2 assets and 28 Elements) and fixed Note field value in table AssetDecisions



2	7/08/2015	"(1) Updated the database for M2 test results provided from PED assessment team and created the draft BA-LEB-PED-130-WaterDependentAssetRegister-AssetList-V20150807.xlsx 

(2) Updated the group, subgroup, class and depth for (up to) 67 NRM WAIT assets to cooperate the feedback to OWS from relevant SA NRM office (whose staff missed the asset workshop). The AIDs and names of those assets are listed in table LUT_changed_asset_class_20150807 in PED_asset_database_20150807.mdb

(3) Appendix C in PED_asset_database_doc_201500807.doc is about total elements/assets in current Group and subgroup

(4) Four SQL queries (Find_All_Used_Assets, Find_All_WD_Assets, Find_Amount_Asset_in_Class  and Find_Amount_Elements_in_Class) in PED_asset_database_20150807.mdb can be used for total assets and total numbers

(5)There are 1 asset (in PED subregion), which is same as 1 asset in MBC subregion. Its AID, Asset Name, Group, SubGroup, Depth, Source and ListDate is using values from MBC asset. This asset is listed in table LUT_DUP_PED_MBC in PED_asset_database_20150807.mdb

(6)The databases, especially spatial   database (PED_asset_database_20150807Only.gdb), were changed such as duplicated attribute fields in spatial data were removed and only ID field is kept. The user needs to join the Table Assetlist or Elementlist  to the relevant spatial data."



3. 27/08/2015     M2_Reason in the Assetlist table and DecisionBrief in the AssetDecisions table have been updated with short descriptions (<255 characters) provided by project team 21/8, and the draft  "water-dependent asset register and asset list" (BA-LEB-PED-130-WaterDependentAssetRegister-AssetList-V20150827) also updated accordingly. No changes to asset numbers.

## **Dataset Citation** 

Bioregional Assessment Programme (2014) Asset database for the Pedirka subregion on 27 August 2015. Bioregional Assessment Derived Dataset. Viewed 05 July 2017, http://data.bioregionalassessments.gov.au/dataset/62dc178f-65ae-4e6a-b5d4-12895b37d04c.

## **Dataset Ancestors** 

* **Derived From** [QLD Dept of Natural Resources and Mines, Groundwater Entitlements 20131204](https://data.gov.au/data/dataset/fd59894f-06b0-4c6f-9029-488934cfa7ba)

* **Derived From** [Queensland QLD - Regional - NRM - Water Asset Information Tool - WAIT - databases](https://data.gov.au/data/dataset/675afffd-5f42-49f0-9e24-9d6cca41621e)

* **Derived From** [Northern Territory Groundwater Elements v120141202](https://data.gov.au/data/dataset/0e10271d-0582-4b9a-a098-b014a9ccd28b)

* **Derived From** [Matters of State environmental significance (version 4.1), Queensland](https://data.gov.au/data/dataset/ef6b54d9-6a1f-44cc-bf8c-ca3de4818a0f)

* **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** [South Australia SA - Regional - NRM Board - Water Asset Information Tool - WAIT - databases](https://data.gov.au/data/dataset/bb5a044a-889c-40a0-bf65-e4826ae72e43)

* **Derived From** [National Groundwater Dependent Ecosystems (GDE) Atlas](https://data.gov.au/data/dataset/e358e0c8-7b83-4179-b321-3b4b70df857d)

* **Derived From** [PED AssetList  V1 20150313](https://data.gov.au/data/dataset/84251560-5af2-490e-a4d8-6208ef91ae62)

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

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

* **Derived From** [Queensland  QLD Regional CMA Water Asset Information WAIT tool databases RESTRICTED Includes ALL Reports](https://data.gov.au/data/dataset/aad90a9c-0101-4a44-af07-9eb458cb5e37)

* **Derived From** [Queensland wetland data version 3 - wetland areas.](https://data.gov.au/data/dataset/2a187a00-b01e-4097-9ca4-c9683e7f4786)

* **Derived From** [Asset database for the Pedirka subregion on 07 August 2015](https://data.gov.au/data/dataset/3c976085-ff75-44c7-a3b1-9608f6a6a994)

* **Derived From** [SA Department of Environment, Water and Natural Resources (DEWNR) Water Management Areas 141007](https://data.gov.au/data/dataset/d0730582-5225-4293-8da6-43ab3ec3b20d)

* **Derived From** [South Australian Wetlands - Groundwater Dependent Ecosystems (GDE) Classification](https://data.gov.au/data/dataset/fc35d75a-f12e-494b-a7d3-0f27e7159b05)

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

* **Derived From** [QLD Dept of Natural Resources and Mines, Groundwater Entitlements linked to bores v3 03122014](https://data.gov.au/data/dataset/68bbd3fb-6e2a-4088-a3dd-55cc44c2f0d6)

* **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** [Permanent and Semi-Permanent Waterbodies of the Lake Eyre Basin (Queensland and South Australia) (DRAFT)](https://data.gov.au/data/dataset/7d46c916-926f-41e8-b6ee-6a48b878d9d3)

* **Derived From** [Queensland wetland data version 3 - wetland lines.](https://data.gov.au/data/dataset/53af31e0-c363-421d-a148-3808bf9c45ff)

* **Derived From** [SA EconomicElements v1 20141201](https://data.gov.au/data/dataset/fe5b60af-67a4-4062-b5d1-80b9ea001776)

* **Derived From** [QLD Dept of Natural Resources and Mines, Groundwater Entitlements linked to bores and NGIS v4 28072014](https://data.gov.au/data/dataset/b1ba5370-2c60-485f-9620-ddad39498999)

* **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** [Northern Territory Groundwater Management Units 20140630](https://data.gov.au/data/dataset/01c48600-f9d3-42b6-8449-d2c5f40ef26f)

* **Derived From** [Northern Territory - Lake Eyre Basin - Wetlands Mapping - METADATA ONLY](https://data.gov.au/data/dataset/41d2ecc8-7700-4cc5-b80c-2092596d6f7e)

* **Derived From** [SA Department of Environment, Water and Natural Resources (DEWNR) Groundwater Licences 141007](https://data.gov.au/data/dataset/ce98b07d-1aea-44f6-8900-482ee49565b0)

* **Derived From** [Northern Territory Groundwater Licence Extract 20140130](https://data.gov.au/data/dataset/80bd9912-5500-4f6f-a899-c299fb998518)

* **Derived From** [Lake Eyre Basin (LEB) Aquatic Ecosystems Mapping and Classification](https://data.gov.au/data/dataset/9be10819-0e71-4d8d-aae5-f179012b6906)

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

* **Derived From** [Asset database for the Pedirka subregion on 19 March 2015](https://data.gov.au/data/dataset/e7fe53b6-e044-48bc-9969-454afb4f9586)

* **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** [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: Pedirka subregion, economy, environment
Organization: Bioregional Assessment Program