Difference between revisions of "Example SQL for Stations"
From Earth Science Information Partners (ESIP)
(Created page with "Document One real Point dataset here.") |
|||
Line 1: | Line 1: | ||
− | + | Back to [[WCS Access to netCDF Files]] | |
+ | |||
+ | A Real life example how to download and serve station timeseries point data. | ||
+ | |||
+ | == AIRNOW == | ||
+ | |||
+ | [http://airnow.gov/ AIRNOW] is an EPA site. | ||
+ | |||
+ | PM 2.5, PM 10 and ozone data can be downloaded from [http://www.epa.gov/airnow/2011/ 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 using python dictionaries |
Revision as of 13:58, 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 using python dictionaries