JSON   RDF   ISO19115/ISO19139 XML

NSW Office of Water SW Offtakes Processed - North & South Sydney, v2 07032014


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 not been been clipped to North and South Sydney PAEs.

Dataset History

1 This dataset has not been clipped to the PAE

2 Share component/ entitlement information was stored in the source dataset file (GUID= 4d69c8af-07cd-4dd0-b090-40060e09b35d) SW_NorthandSouth_Sydney_WLS-EXTRACT_Wals_volume.xls and SW_NorthandSouth_Sydney_WLS-EXTRACT.xls

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

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

5 This is included in the Processed_NorthSouthSydney worksheet

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

7 For licences that have been unbundled, 'counts_works_per_licence_unbundled'

8 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.

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

  1. 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 Processed_NorthSouthSydney 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


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 can be found in - \wron\Project\BA\BA_all\Hydrology\OffTakes_CombinedWSP_WSOURCES_31July2013.gdb

MANAGEMENT: management zone can be found in - \wron\Project\BA\BA_all\Hydrology\OffTakes_CombinedWSP_WSOURCES_31July2013.gdb

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) NSW Office of Water SW Offtakes Processed - North & South Sydney, v2 07032014. Bioregional Assessment Derived Dataset. Viewed 18 June 2018, http://data.bioregionalassessments.gov.au/dataset/b1990b00-fb24-4ea1-87e9-1644addbae37.

Dataset Ancestors

Data and Resources

This dataset has no data

Additional Info

Field Value
Title NSW Office of Water SW Offtakes Processed - North & South Sydney, v2 07032014
Type Dataset
Language eng
Licence Restricted access. This dataset is not available for public distribution.
Data Status completed
Update Frequency NONE
Landing Page https://data.gov.au/data/dataset/434db019-962b-47cb-b023-e18c65aef0b6
Date Published 2016-09-15
Date Updated 2019-11-20
Contact Point
Bioregional Assessment Program
Temporal Coverage N/A - N/A
Geospatial Coverage NONE
Jurisdiction New South Wales
Data Portal data.gov.au
Publisher/Agency Bioregional Assessment Program