JSON Time Series

[Ramage, Dan]

 

Greetings all. I’m working on a project for a local citizen science group that has collected water quality data at anumber of sites.  The data is in an Excel file which is easy enough to Python/Pandas to get the data. I’m wanting to then put it up on a webpage for them.

I was wondering if there is a widely used JSON schema for time series data.  I’ve written it out in a JSON Time Series schema(https://docs.eagle.io/en/latest/reference/historic/jts.html). However I really am not sure if that’s a widely used standard or not, or if it really even is a standard.

 

Just wanting to see what others might be doing.

 

 

 

Thanks,

 

Dan

 

 

[Mathew Biddle - NOAA Federal]

Hi Dan,

I'm curious about the answer to this question as well. ERDDAP offers a couple different json download options https://erddap.ioos.us/erddap/tabledap/documentation.html#fileType, maybe one of those has been used for this use case?

Matt

--
You received this message because you are subscribed to the Google Groups "ioos_tech" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ioos_tech+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ioos_tech/SJ0PR19MB541470A72AA688767DB2B4759B062%40SJ0PR19MB5414.namprd19.prod.outlook.com.

--

Mathew Biddle, Physical Scientist
NOAA/NOS
US Integrated Ocean Observing System Office
1315 East-West Highway
Silver Spring MD 20910

240-533-9470

ORCiD: 0000-0003-4897-1669

http://www.ioos.noaa.gov/

[Ramage, Dan]

I’m experimenting with the Python package json-timeseries. It’s easy enough to use, however I’ve discovered that there is no JavaScript library that will handle this format. I guess that answers my question about whether or not the schema here: https://docs.eagle.io/en/latest/reference/historic/jts.html is a widely or even narrowly adopted format.

 

Dan

 

To view this discussion on the web visit https://groups.google.com/d/msgid/ioos_tech/CA%2BRW_cv9qus7RU3%2BhDQ--6HJB7fF4a1zeQp929wUt4YmBONpVg%40mail.gmail.com.

[Formel, Stephen K]

Dan,

I'm not sure how much your situation overlaps with that of the METS-RCN folks, but it sounds suspiciously similar. (I started working with them at OSM, so I'm still learning my way around the project).  A goal of METS-RCN is to standardize metadata schema for time-series data, and that's related to SPOTS.  See Nico Lange's repo: https://github.com/NicoGEOMAR/METS-RCN for example JSON.

I don't think there is a silver bullet in there, but Nico and others might be able to provide some guidance.  Would you like me to connect y'all?

Best,

Steve

---

From: ioos...@googlegroups.com <ioos...@googlegroups.com> on behalf of Ramage, Dan <RAM...@mailbox.sc.edu>
Sent: Monday, April 15, 2024 2:12 PM
To: ioos...@googlegroups.com <ioos...@googlegroups.com>
Subject: [EXTERNAL] Re: [ioos_tech] JSON Time Series

 

 

This email has been received from outside of DOI - Use caution before clicking on links, opening attachments, or responding.

To view this discussion on the web visit https://groups.google.com/d/msgid/ioos_tech/SJ0PR19MB5414EE449BA0D07B019685569B092%40SJ0PR19MB5414.namprd19.prod.outlook.com.

[Ramage, Dan]

Steve,

 

Thanks for the info, I’ll poke around those links and see if they are applicable for me.

 

 

Thanks,

 

Dan

 

To view this discussion on the web visit https://groups.google.com/d/msgid/ioos_tech/PH8PR09MB9278CE82F0002DCFEB8285EFD4092%40PH8PR09MB9278.namprd09.prod.outlook.com.