Summary Analysis of QLD DNRM Licence Locations Linked to Cadastre Plan - Clipped to GAL PAE v01

## **Abstract** 

This dataset was derived by the Bioregional Assessment Programme. The parent 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 data file contains surface water allocation information for the different catchments in the Galilee subregion preliminary assessment extent (PAE). It describes permit types, location and owner of individual permit.

## **Purpose** 

It has been designed to extract water accounts (permit type and total allocation) in different river catchments within the Galilee subregion.

## **Dataset History** 

The Australia's River Basins 1997 dataset (GUID: d4561e86-2d13-4dcb-bf9e-aae75ba4850c) was spatially joined to the QLD DNRM Licence Locations Linked to Cadastre Plan - Clipped to GAL PAE dataset (GUID: da3fe07d-99f6-4efa-970a-6f445ebd16cc) and attribute table exported as an Excel worksheet: 'GAL_DNRM_SWLic_LinkedToLocation'



A pivot table was exported as a summary ('Summary') showing the volume (ML) and number of entitlements per water year for each 'Purpose'.



A pivot table (PivotT) was created from the output worksheet to summarise the count and volume (ML) of nominal water entitlements per catchment, per year.

Field List - Authorised (Purpose), NominalEntitlementPerWaterYearML

Column Labels - Values

Row Labels - Authorised

Values - Sum of NominalEntitlementPerWaterYearML, Count of NominalEntitlementPerWaterYearML



A second pivot table was created ('PivotT') and exported as a summary ('Summary II") showing the number and volume (ML) of entitlements per water year for each catchment.



Field List - NominalEntitlementPerWaterYearML, AssetName, BNAME

Colum Labels - Values

Row Label - BNAME, AssetName

Values - Count of NominalEntitlementPerWaterYearML, Sum of NominalEntitlementPerWaterYearML

## **Dataset Citation** 

Bioregional Assessment Programme (XXXX) Summary Analysis of QLD DNRM Licence Locations Linked to Cadastre Plan - Clipped to GAL PAE v01. Bioregional Assessment Derived Dataset. Viewed 11 April 2016, http://data.bioregionalassessments.gov.au/dataset/edd21ff8-0e42-49d9-a5f1-c619757860ac.

## **Dataset Ancestors** 

* **Derived From** [SA Petroleum Exploration Licence/Permit Applications](https://data.gov.au/data/dataset/d5667303-96c8-473f-af05-d3f53ac7753c)

* **Derived From** [QLD Mining Claim 6/3/2013](https://data.gov.au/data/dataset/ed3cb0ee-58c1-45ca-b86c-4a6f04f04834)

* **Derived From** [South Australia Mineral Leases Production, 6 March 2013](https://data.gov.au/data/dataset/d7bf21ef-7b7f-40e0-a1a7-8be895a5842e)

* **Derived From** [SA Petroleum Production License Applications](https://data.gov.au/data/dataset/ecf1a9b6-44ca-4403-9648-828537652a54)

* **Derived From** [Galilee Subregion whole potential assessment extent v02](https://data.gov.au/data/dataset/7d48db4e-d4fc-431e-89c5-a36b97073656)

* **Derived From** [Natural Resource Management (NRM) Regions 2010](https://data.gov.au/data/dataset/1d54e38f-4051-4f0c-a350-c7dbd8eba65b)

* **Derived From** [SA Mineral and/or Opal Exploration Licenses](https://data.gov.au/data/dataset/f54faf14-213f-4eb0-ad65-eecb0d68a8e2)

* **Derived From** [QLD Current Exploration Permits for Coal 6/3/2013](https://data.gov.au/data/dataset/1aea02ad-4a47-4a4c-8fe6-e8e5c7fd9cb4)

* **Derived From** [QLD Current Authorities to Prospect for Petroleum (ATP), 6/3/2013](https://data.gov.au/data/dataset/038c169b-606f-4478-99db-e3125319b321)

* **Derived From** [Lake Eyre Basin Groundwater Potential Assessment Extents (PAE) v01](https://data.gov.au/data/dataset/3d59fd39-8d26-49d4-b6de-2e1fba315ddb)

* **Derived From** [QLD Mining Lease 6/3/2013](https://data.gov.au/data/dataset/fa634295-8514-4a5c-928c-afdb2408e338)

* **Derived From** [GEODATA TOPO 250K Series 3, File Geodatabase format (.gdb)](https://data.gov.au/data/dataset/96ebf889-f726-4967-9964-714fb57d679b)

* **Derived From** [GEODATA TOPO 250K Series 3](https://data.gov.au/data/dataset/a0650f18-518a-4b99-a553-44f82f28bb5f)

* **Derived From** [Australian Geological Provinces, v02](https://data.gov.au/data/dataset/13ad6933-ee80-4c51-a97b-bac1e8bef16d)

* **Derived From** [NSW Catchment Management Authority Boundaries   20130917](https://data.gov.au/data/dataset/0dc4272e-c081-4ed4-9645-aa336ffacd85)

* **Derived From** [SA Mineral and/or Opal Exploration Licence Applications](https://data.gov.au/data/dataset/064b4ce1-cbf9-4cd3-ad2e-4d1a677c70b8)

* **Derived From** [South Australia Mineral Production Claims, 6 March 2013](https://data.gov.au/data/dataset/a8dd189f-2886-47fa-9293-6449a0c54d15)

* **Derived From** [SA Mining and Production Tenement Applications](https://data.gov.au/data/dataset/f87ed672-cde6-4526-a79f-8e048183dbd5)

* **Derived From** [QLD Petroleum Leases 6/3/2013](https://data.gov.au/data/dataset/10837caf-8c17-4aa8-8cbc-62fd55a02509)

* **Derived From** [SA Petroleum Exploration Licences/Permits](https://data.gov.au/data/dataset/f17f76af-fdad-4bdb-b8b2-c87d1a9d482e)

* **Derived From** [QLD DNRM Licence Locations Linked to Cadastre Plan - v1 - 20140307](https://data.gov.au/data/dataset/bf1085d8-9752-4533-a65a-820a020907db)

* **Derived From** [South Australia Petroleum Production Licenses](https://data.gov.au/data/dataset/13dc0f31-6eae-44d7-85be-dcba662623ff)

* **Derived From** [Galilee Surface Water Preliminary Assessment Extent (PAE) v02](https://data.gov.au/data/dataset/ff45f897-f5b9-4f0f-b4b1-41fa2d337dc7)

* **Derived From** [Lake Eyre Basin Surface water Potential Assessment Extents v01](https://data.gov.au/data/dataset/58be9173-4f37-4a0e-96cd-c35f9ce35e18)

* **Derived From** [Geological Provinces - Full Extent](https://data.gov.au/data/dataset/0a064b3b-2a1e-4672-80d9-03333be67aad)

* **Derived From** [Australia's River Basins 1997](https://data.gov.au/data/dataset/d4561e86-2d13-4dcb-bf9e-aae75ba4850c)

* **Derived From** [QLD Mineral Development License 6/3/2013](https://data.gov.au/data/dataset/2a46b5c2-5d80-4d4a-a2c8-9423a7ad8d9e)

* **Derived From** [Bioregional Assessment areas v01](https://data.gov.au/data/dataset/0fd0d820-30b3-451f-a126-a50040426999)

* **Derived From** [Bioregional Assessment areas v02](https://data.gov.au/data/dataset/e414b1b3-c42e-42e9-9cc4-2093054aa35f)

* **Derived From** [QLD Current Exploration Permits for Minerals (EPM) in Queensland 6/3/2013](https://data.gov.au/data/dataset/5d8c8f5c-7ace-40ce-87ce-0b311b028c10)

* **Derived From** [QLD DNRM Licence Locations Linked to Cadastre Plan - Clipped to GAL PAE](https://data.gov.au/data/dataset/da3fe07d-99f6-4efa-970a-6f445ebd16cc)

* **Derived From** [Galilee Groundwater Preliminary Assessment Extent (PAE) v02](https://data.gov.au/data/dataset/bec18bf8-fedc-4290-8008-68b97a76247f)



Tags: Galilee subregion, Queensland, inlandWaters
Organization: Bioregional Assessment Program