NSW Office of Water - GW licence extract linked to spatial locations for North and South Sydney v2 20140228

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 groundwater 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 clipped to the North and South Sydney PAEs, therefore the number of economic assets/ relevant licences will drastically reduce once this occurs.

The North and South Sydney groundwater licences includes an extract of all licences that fell within the data management acquisition area as provided by BA to NSW Office of Water.

Dataset History

Procedure: refer to Bioregional assessment data conversion script.docx

The following general steps were undertaken:

1) Original spread sheets have mulitple licence instances if there are more than one WA/CA number. This means that there are more than one works or permit to the licence. The aim is to only have one licence instance.

2) Using the new column of licence numbers, several vlookups were created to bring in other data. Where the columns are identical in the original spreadsheets, they are combined. The only ones that dont are the Share/Entitlement/allocation, these mean different things.

3) A hydro ID column was created, this is a code that links this NSW to the NGIS, which is basically a ".1.1" at the end of the bore code.

4) All 'cancelled' licences were removed

5) A count of the number of works per licence and number of bores were included in the spreadsheet.

6) Where the ShareComponent = NA, the Entitlement = 0, Allocation = 0 and there was more than one instance of the same bore, this means that the original licence assigned to the bore has been replaced by a new licence with a share component. Where these criteria were met, the instances were removed

7) a volume per works ensures that the volume of the licence is not repeated for each works, but is divided by the number of works

Dataset Citation

Bioregional Assessment Programme (2014) NSW Office of Water - GW licence extract linked to spatial locations for North and South Sydney v2 20140228. Bioregional Assessment Derived Dataset. Viewed 13 March 2019, http://data.bioregionalassessments.gov.au/dataset/0e6034bc-7a91-46c9-80e0-0e3330a0b7da.

Dataset Ancestors

• Derived From NSW Office of Water Groundwater Entitlements Spatial Locations

• Derived From NSW Office of Water Groundwater Licence Extract, North and South Sydney - Oct 2013