How to Extract Time-series Information

ACME Groundwater Works Systems

(See:  Groundwater Glossary of terms if you have questions)

NOTE:  All links in this document are not active.

Purpose

To extract time series information in test, csv or Excel format.  The data may include telemetered and data-logger information on water level, water pressure, water flow and the water temperature of bores and include information from multiple bores.  

The ultimate purpose is to extract data that can be used to produce a hydrograph for analysis.

You can use this to extract historic usage of readings by point, day and hourly.  GWCSV will satisfy most queries.  Only use HYCSV if you require more granular details.

•         GWCSV – typical, most used by Hydrogeologists to extract information required (in depth below measuring point and needs to be converted to depth below ground level (BGL).

•         HYCSV – presents the same information, but in a more granular form (used infrequently).

Introduction (Background, preparation)

A list of groundwater numbers of interest.

Procedure for GWCSV

Enter Hydstra (if you have not been authorised to access Hydstra, contact your Supervisor).  Also refer to QRG – ‘Introduction to WaterNSW Groundwater Systems’ (link to QRG)

1.       Click on the Link:  Citrix link to water tables

2.       Enter your Username and Password

3.       Click on ACME icon on the desktop

4.       Navigate the first screen to GWCSV

5.       Enter GW#(s) - groundwater numbers into ‘Site List’ field

CAUTION:  If you click OK, you must allow the program to complete the report.  DO NOT CLICK CANCEL once the report is running.

Procedure for HYCSV

Use HYCSV if you need pressure level data and/ or surface level water.  It will extract time series data in a much more granular report than GWCSV and let you know if there is a data logger installed.

NOTE:  some data loggers must be meter read by a CFO, while some send back information electronically. 

Search for HYCSV under ‘Most Used Programs”. 

1.       The ‘TS data Source = A = Archive

2.       Hole if you select 0 = all

3.       Pipe if you select all

4.       Select a date range with/start and date required

5.       Click output and choose the way you want the data to be presented

6.       The default is Excel change if required

Find HYCSV under 'Most Used Programs'.  Double click on HYCSV:

HYCSV gives you many more options – it has many more details (but not used much), however, it does tell you when a datalogger has been installed in a bore.  Use Point and the others only if it is a MONITORED bore

•         Daily – more granulated

•         Hourly – even more granulated

•         If there’s only one

•         You can tell if they’ve put in a datalogger. 

HYCSV – when you hit ‘run’ another window opens.  Once it opens, let it run.  Do not hit cancel.

Once the data is ported to Excel, it appears like this:

Label the file and it will be available for further analysis.

Procedure for Telemetered Data

Telemetered data is live information that can only be extracted if the data logger is manual. 

Go to:  www.acmerealtimewatertables.com

It is a quick way to extract real-time data but is only used for bores connected to the WaterNSW network.  To use the online live data on the website:

•         Select the period/ output to receive the latest readings. 

•         Quality code 5 = 130

This database is ultimately used to support the customer’s experience when they have a specific inquiry about one of their bores.  It provides an historic usage of readings point/ day/ hour

WAS – Water usage is used to ascertain if a customer has used any water – water usage data confirmation list of extractions.  There’s no water usage data in Acme Water System

yWAS is only used by customers – they can only see their own details regarding their own water usage.