NSW Office of Water SW licences - Gloucester PAE v2 21022014

## **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 aim of this dataset was to be able to map each surface water works with the volumetric entitlement without double counting the volume and to aggregate/ disaggregate the data depending on the final use.



This has been clipped to the Gloucester PAE.

## **Dataset History** 

1.	Joe Bell (GA) has clipped the surface water licences to the Gloucester PAE. This clip contains the works associated with the sharecomponent/ entitlement. This can be a many to many relationship. . A work is a surface water extraction point.

SW_licences_GloucesterPAE_Clip.dbf

2.	Share component/ entitlement information was stored in the     SW_Gloucester_COMBINED_v4.csv worksheet

3.	Total volume of share component/ entitlement is 10,786ML 

4.	The works and share/component information was joined using Access, linking the CWlicence to the WAorCA_link. This links the volumetric entitlement to the works location.

5.	This link also created share components that had a 0 entitlement which are licences that have been converted to unbundled licences in the new Water Act

6.	By filtering out the 0 entitlement, the number of works linked to a share/component or entitlement with a specified  volume was 212 with a total of 10,786ML.   Worksheet FilteredIndividualSWLicences

7.	Where there was more than one works per licence, an additional column was add COUNT_CWLICENSE. This shows where the share component/ entitlement is double counted as it is matched to each work with the full allocation.

8.	An additional column was added SHARE_PER_WORKS which divides the share component/ entitlement by the number of works to give an allocation per works.

9.	The SHARE_PER_WORKS column allows you to  plot the works with the share component in ArcGIS without double counting the allocation.

10. A glossary of terms used ini the water licensing is included here:    http://registers.water.nsw.gov.au/wma/Glossary.jsp

11.	An additional worksheet was added to aggregate the data into Water Sources and Management Zones. The Water Sources and Management Zones were provided by NSW Office of Water

CombinedWSP_WSOURCES_31July2013.gdb\Geographic_GDA94\WSP_COMBINED_31July2013

12.	The Avon River does not have management zones. Therefore data can only be viewed for the water source.

13.	All other works can be aggregated to the Water Source, or the management zone depending on how you want to aggregate or disaggregate the data.



relevant fields:

CWLICENSE: works licence number

COUNT_CWLICENSE: Where there was more than one works per licence

SHARE_PER_WORKS: Share component divided by number of works to ensure no double counting

STATUS_DES: Status description as active, current, cancelled

LICENCE_iS: licensed issued date

LICENCE_LO: licence lodged date

LICENCE_P: Licence purpose eg. stock and domestic, town supply, irrigation

WORK_TYPE: pump, excavation etc

WORK_TYPE_: diversion or storage

MAJOR_CATC: major surface water catchement

NAME_OF_TH: water sharing plan the licence belongs to

WATER_SHAR: water sharing plan the licence belongs to

WATER_SOUR: water source 

MANAGEMENT: management zone

WSP_STATUS: Status of the water sharing plan

START_DATE: Start date of the water sharing plan

END_DATE: end date of the water sharing plan

LICENSEorAPPROVAL: licence or approval number

Status: Cancelled or current (or blank)

ShareC: Share component attached to the licence

WAorCAlink:a combined water supply works / water use approval

LINKED_TO_AL:This is the identification number for an access licence which is shown on the licence certificate or on a search printout of the licence obtained from the access licence register run by Land and Property Information.

## **Dataset Citation** 

Bioregional Assessment Programme (XXXX) NSW Office of Water SW licences - Gloucester PAE v2 21022014. Bioregional Assessment Derived Dataset. Viewed 14 June 2016, http://data.bioregionalassessments.gov.au/dataset/f0a75a2b-233f-40a4-82cb-1929f2bee8c6.

## **Dataset Ancestors** 

* **Derived From** [Subcatchment boundaries within and nearby the Gloucester subregion](https://data.gov.au/data/dataset/71a9e120-fc7c-4f51-983f-99a2b10c65b9)

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

* **Derived From** [Australian Coal Basins](https://data.gov.au/data/dataset/9d5a8d74-a201-42bd-9d49-3c392244be16)

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

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

* **Derived From** [BILO Gridded Climate Data: Daily Climate Data for each year from 1900 to 2012.](https://data.gov.au/data/dataset/7aaf0621-a0e5-4b01-9333-53ebcb1f1c14)

* **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** [BA ALL mean annual flow for NSW - Choudhury implementation of Budyko runoff v01](https://data.gov.au/data/dataset/b20d185f-3d22-4b5d-be87-89ce13505ce7)

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

* **Derived From** [Geofabric Hydrology Reporting Catchments - V2.1](https://data.gov.au/data/dataset/ce066e36-49ad-4f77-b505-b1d2a4fe9c6a)

* **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** [NSW Office of Water SurfaceWater licences in the Gloucester PAE](https://data.gov.au/data/dataset/5eafdb2a-f756-4a92-8ebd-37e6ea711b67)

* **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** [Gloucester Coal Basin](https://data.gov.au/data/dataset/a451ad06-e6a9-48bd-ba83-c0a4d191a1f4)

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

* **Derived From** [GLO Preliminary Assessment Extent](https://data.gov.au/data/dataset/c0dba74a-feee-440f-a53a-ea31be8479a5)

* **Derived From** [Mean Annual Climate Data of Australia 1981 to 2012](https://data.gov.au/data/dataset/02418c67-f8bb-48a8-88a3-2a5c6b485f78)



Tags: Gloucester subregion, New South Wales, inlandWaters
Organization: Bioregional Assessment Program