Difference between revisions of "Example SQL for Stations"

From Earth Science Information Partners (ESIP)
Line 20: Line 20:
  
 
calculating statistics to filter the location table
 
calculating statistics to filter the location table
 +
 +
== Registering the WCS and WFS for point data ==
 +
 +
WFS for locations
 +
 +
WCS for data
  
 
registering using python dictionaries
 
registering using python dictionaries

Revision as of 13:59, July 7, 2011

Back to WCS Access to netCDF Files

A Real life example how to download and serve station timeseries point data.

AIRNOW

AIRNOW is an EPA site.

PM 2.5, PM 10 and ozone data can be downloaded from yearly folders in text form.

The Design of the Database

Location table

parameter tables

the importance of views, flexibility of SQL, snapshot views

creating data views

calculating statistics to filter the location table

Registering the WCS and WFS for point data

WFS for locations

WCS for data

registering using python dictionaries