GW Element Bores with Unknown FTYPE Hunter NSW Office of Water 20150514

## **Abstract** \n\nThis dataset was supplied to the Bioregional Assessment Programme by a third party and is presented here as originally supplied. The metadata was not provided by the data supplier and has been compiled by the programme based on known details at the time of acquisition.\n\n\n\nThis dataset was supplied as an outcome of the Hunter Asset Workshop by NSW Office of Water. \n\n\n\nStatus and FType fields were updated based on the GDS (groundwater database) data extraction. \n\nSuggestions of what Asset type should be were added under 'Comments'.\n\n\n\nThere are 694 bores with Unknown Ftype (listed in 'Unknown' sheet). \n\nAnother data extraction using Brio Query to get the Work Comments info managed to get the work purpose for 600+ bores. \n\n67 remaining bores or 1% of the bore data with Unknown purpose and status remained. Data provider suggests remaining 67 bores should be 'NULL' asset.\n\n\n\nThis dataset has been provided to the BA Programme for use within the programme only. Third parties may request a copy of the data from DPI Water (previously known as the NSW Office of Water) at http://www.water.nsw.gov.au/.\n\n## **Purpose** \n\nThis dataset was created to populate missing values for FTYPE in the initial creation of the GW Economic Elements for Hunter (GUID). The NSW Office of water was supplied with records where FTYPE was unknown and they subsequently queried their database for these records.\n\n## **Dataset History** \n\nStatus and FType fields were updated based on the GDS (groundwater database) data extraction. \n\nSuggestions of what Asset type should be were added under 'Comments' \n\n\n\nThere are 694 bores with Unknown Ftype (listed in 'Unknown' sheet). \n\nAnother data extraction using Brio Query to get the Work Comments info managed to get the work purpose for 600+ bores. \n\n67 remaining bores or 1% of the bore data with Unknown purpose and status remained. Data provider suggests remaining 67 bores should be 'NULL' asset.\n\n\n\nNote: Source file includes Surface Water records (ones without 'GW' at beginning of BOREID Field need to be excluded if only performing GW analysis)\n\n\n\nOnly first 2 worksheets are Outputs (Praveen & Unknowns). Others are working spreadsheets for the purpose of extracting the data\n\n## **Dataset Citation** \n\nNSW Office of Water (2015) GW Element Bores with Unknown FTYPE Hunter NSW Office of Water 20150514. Bioregional Assessment Source Dataset. Viewed 13 March 2019, http://data.bioregionalassessments.gov.au/dataset/e8b6a2f3-2951-4cdd-9570-871441120e02.