Ok, this is a bit of a niche thing to post up onto my website…but if you are interested in XML time-series data, you may be interested to use this handy tool.
Download the TSX_Analyser (here) – notice that this is a macro-enabled, Excel workbook. It has been used extensively for the last 10 years so it should be safe. However, please note that I can offer no liability for any loss or damage from its use.
The nattily titled “EA time-series data exchange format” is something I helped to design in 2006. It is the data standard that we use to exchange river levels, flows, rainfall totals, groundwater levels, etc… between our telemetry systems, hydrometric archive, various hydrological models, and with some of our key customers.
Note that in the TSX Analyser zip file is also a subfolder called XMLSchemas. This contains the schema and is in a handy location for the TSX Analyser to find.
- This is a old school information page, with a bunch of stylesheets and XML information: http://websites.chrisbeales.net/TSX/tsx_Information.html. Notice that there is an old version of the TSX Analyser – ignore it because the newer one is better!
- The TSX schema and Plain English document are officially held here: http://www.environment-agency.gov.uk/xmlschemas/