Dataset: NSW Office of Water Groundwater licence extract linked to spatial locations GLOv2 19022014



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 Gloucester PAE, therefore the number of economic assets/ relevant licences will drastically reduce once this occurs.

The Worksheet titled 2.1 links the individual licence to a works and a volumetric entitlement. For about 50% of sites, this can be linked to a bore which can be found in the NGIS through the HydroID. . This will allow analysis of depths, lithology and hydrostratigraphy where the data exists.

Data can be aggregated based on water source and water management zone.

Dataset History


Aim: To get a one to one ratio of licences numbers to bore IDs.

  1. NSW Office of Water Groundwater Licence Extract Gloucester- Oct 2013 datasets have mulitple licence instances if there are more than one WA/CA number. This means that there probably one works or permit to the licence. The aim is to only have one licence instance.

  2. Using the pivot results, the individual licence numbers were combined into one colume in the 2.1 Linked Licence Number spreadsheet.

  3. Using the new column of licence numbers, several vlookups were created to bring in other data. This includes the bore number from 1.1 From_Arc Spreadsheet and the original data from the 1.2 From_Spreadsheet_WALS and 1.3 From_Spreadsheet_OLD spreadsheets. (Please note, columns of the two spreadsheets 1.2 From_Spreadsheet_WALS and 1.3 From_Spreadsheet_OLD spreadsheets overlap. Where they do they are combined. The only ones that dont are the Share/Entitlement/allocation, these mean different things.

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

  5. A quality check "3.4 QA Check Arc and Spreadsheet" was to make sure that all the shape file licences are reperesented in the WALs and Old spreadsheets, which they are.

Please Note

The share componant/entitlement/ allocation is per licence AND per bore. Any licence that had more than one bore had no volumetric amount attached so it can be assumed that the licenced has only one bore and the volume is from licence and bore.

Dataset Citation

Bioregional Assessment Programme (2014) NSW Office of Water Groundwater licence extract linked to spatial locations GLOv2 19022014. Bioregional Assessment Derived Dataset. Viewed 18 July 2018,

Dataset Ancestors

General Information