CLM16swo NSW Office of Water Surface Water Offtakes processed for Clarence Moreton v3 12032014

## **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.



The difference between NSW Office of Water SW licences - CLM v2 and v3 is that an additional column has been added, 'Asset Class' that aggregates the purpose of the licence into the set classes for the Asset Database.



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 not been been clipped to the Clarence Moreton PAE.

## **Dataset History** 

The difference between NSW Office of Water SW licences - CLM PAE v2 and v3 is that an additional column has been added, 'Asset Class' that aggregates the purpose of the licence into the set classes for the Asset Database.

Where purpose = domestic; or domestic & stock; or stock then it was classed as 'basic water right'. Where it is listed as both a domestic/stock and a licensed use such as irrigation, it was classed as a 'water access right.' All other take and use were classed as a  'water access right'. 



1	This dataset has not been clipped to the PAE					

2	Share component/ entitlement information was stored in the     SW_Clarence_Moreton_WLS-EXTRACT_Wals_volume.xls and SW_Clarence_Moreton_WLS-EXTRACT.xls					

3	These datasets were combined in access by linking the 'LICENSE/APPROVAL' in 'SW_Clarence_Moreton_WLS-EXTRACT.xls' with the 'Linked with WA/CA' in 'SW_Clarence_Moreton_WLS-EXTRACT_Wals_volume.xls'					

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

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

6	For licences that have been unbundled, 'counts_works_per_licence_unbundled'					

7	An additional column was added 'VOLUME_PER_WORKS' which divides the allocation component by the number of works to give an allocation per works_for bundled licences.					

8	An additional column was added 'SHARE_PER_WORKS' which divides the share component by the number of works to give an share per works_for unbundled licences.					

9	The'VOLUME_PER_WORKS' and '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 Final_process_ClarenceMoreton highlights the most appropriate columns in regards to the purpose of the licence, the location, and volume per works and the status of the licence					

12	cancelled licences have been removed from the final worksheet					

						

relevant fields:						

CWLICENSE: works licence number (unbundled)						

COUNT_Works_per_licence: Where there was more than one works per licence for unbundled						

Status - status description such as active, cancelled						

Commencement: licence commencment date						

Licence Issue Date						

Licence lodgement date:						

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

WORK_TYPE: pump, excavation etc						

WORK_TYPE_Group: diversion or storage						

MAJOR_CATC: major surface water catchement						

Comments						

lat	latitute					

Long	longitude					

Entitlement: entitlement for unbundled licences						

Allocation: Allocation limit for unbundled licenced						

VolumePerWorks: allocation per works for unbundled licences						

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						

SharePerWorks: share per works for bundled licences						

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 (2014) CLM16swo NSW Office of Water Surface Water Offtakes processed for Clarence Moreton v3 12032014. Bioregional Assessment Derived Dataset. Viewed 10 July 2017, http://data.bioregionalassessments.gov.au/dataset/715a405b-dc50-46ca-9704-1f698e5b66fc.

## **Dataset Ancestors** 

* **Derived From** [CLM16swo NSW Office of Water Surface Water Offtakes processed for Clarence Moreton v2 06032014](https://data.gov.au/data/dataset/e63cc5fd-b3f7-4dad-a9a7-d93ac361beb8)

* **Derived From** [CLM - 16swo NSW Office of Water Surface Water Offtakes - Clarence Moreton v1 24102013](https://data.gov.au/data/dataset/2b672f0a-9ca1-455d-b96f-9fe3d2d97bdb)

* **Derived From** [NSW Office of Water Surface Water Entitlements Locations v1_Oct2013](https://data.gov.au/data/dataset/fc872710-998e-4c76-8b98-1df383c53de6)



Tags: Clarence-Moreton bioregion, New South Wales, inlandWaters
Organization: Bioregional Assessment Program