Example SQL for Stations
From Earth Science Information Partners (ESIP)
Revision as of 14:11, July 7, 2011 by Hoijarvi (talk | contribs) (→Registering the WCS and WFS for point data ??? what is in this section ?)
Back to WCS Access to netCDF Files
A Real life example how to serve station timeseries point data through WCS data access protocol.
AIRNOW
AIRNOW is an EPA site. ----------- is this the site URL??
PM 2.5, PM 10 and ozone data can be downloaded from yearly folders in text form.
The Design of the SQL Database
Location table
Parameter tables
Fact - Data Table
Data Views in SQL
the importance of views, flexibility of SQL, snapshot views
creating data views
calculating statistics to filter the location table
Configuring the WCS Service and WFS Service for point data
WFS for locations
WCS for data
using python dictionaries ??