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


Description

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

General Information

Distributions