Read realtime data from IOOS Sensor Map via ERDDAP

In [1]:

    

%matplotlib inline
import pandas as pd


    

In [2]:

    

url='http://erddap.axiomdatascience.com/erddap/tabledap/sensor_service.csv?time,depth,station,parameter,unit,value&time>=2016-11-02T09:45:00Z&station=%22urn:ioos:station:nerrs:wqbchmet%22&parameter=%22Wind%20Speed%22&unit=%22knot%22'
print(url)
df = pd.read_csv(url,index_col='time',parse_dates=True,skiprows=[1])  # skip the units row


    

    




http://erddap.axiomdatascience.com/erddap/tabledap/sensor_service.csv?time,depth,station,parameter,unit,value&time>=2016-11-02T09:45:00Z&station=%22urn:ioos:station:nerrs:wqbchmet%22&parameter=%22Wind%20Speed%22&unit=%22knot%22

In [3]:

    

df['value'].plot(figsize=(12,4),title=df['parameter'][0]);


    

In [4]:

    

df.head()


    

    
Out[4]:






  

    

      

      
depth
      
station
      
parameter
      
unit
      
value
    
    

      
time
      

      

      

      

      

    
  
  

    

      
2016-11-30 18:45:00
      
0.0
      
urn:ioos:station:nerrs:wqbchmet
      
Wind Speed
      
knot
      
2.5270
    
    

      
2016-11-30 18:30:00
      
0.0
      
urn:ioos:station:nerrs:wqbchmet
      
Wind Speed
      
knot
      
2.7214
    
    

      
2016-11-30 18:15:00
      
0.0
      
urn:ioos:station:nerrs:wqbchmet
      
Wind Speed
      
knot
      
2.5270
    
    

      
2016-11-30 18:00:00
      
0.0
      
urn:ioos:station:nerrs:wqbchmet
      
Wind Speed
      
knot
      
1.7495
    
    

      
2016-11-30 17:45:00
      
0.0
      
urn:ioos:station:nerrs:wqbchmet
      
Wind Speed
      
knot
      
2.3326
    
  

In [5]:

    

# Use ERDDAP's built-in relative time functionality to get last 48 hours:
start='now-7days'
stop='now'
# or specify a specific period:
#start = '2016-09-06T00:00:00Z'
#stop =  '2016-11-07T00:00:00Z'


    

In [6]:

    

url='http://erddap.axiomdatascience.com/erddap/tabledap/sensor_service.csv?time,depth,station,parameter,unit,value&\
station=%22urn:ioos:station:nerrs:wqbchmet%22&parameter=%22Wind%20Speed%22&unit=%22knot%22\
&time>={}&time<={}'.format(start,stop)
print(url)


    

    




http://erddap.axiomdatascience.com/erddap/tabledap/sensor_service.csv?time,depth,station,parameter,unit,value&station=%22urn:ioos:station:nerrs:wqbchmet%22&parameter=%22Wind%20Speed%22&unit=%22knot%22&time>=now-7days&time<=now

In [7]:

    

df = pd.read_csv(url,index_col='time',parse_dates=True,skiprows=[1])  # skip the units row


    

In [8]:

    

df['value'].plot(figsize=(12,4),title=df['parameter'][0]);