Difference between revisions of "Example SQL for Stations"
From Earth Science Information Partners (ESIP)
Line 1: | Line 1: | ||
Back to [[WCS Access to netCDF Files]] | Back to [[WCS Access to netCDF Files]] | ||
− | A Real life example how to | + | A Real life example how to serve station timeseries point data through WCS data access protocol. |
== AIRNOW == | == AIRNOW == | ||
− | [http://airnow.gov/ AIRNOW] is an EPA site. | + | [http://airnow.gov/ AIRNOW] is an EPA site. ----------- is this the site URL?? |
PM 2.5, PM 10 and ozone data can be downloaded from [http://www.epa.gov/airnow/2011/ yearly folders] in text form. | 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 == | + | == The Design of the SQL Database == |
− | Location table | + | ===Location table=== |
− | + | === Parameter tables === | |
− | the importance of views, flexibility of SQL, snapshot views | + | === Fact - Data Table === |
+ | |||
+ | === Data Views in SQL === | ||
+ | |||
+ | the importance of views, flexibility of SQL, snapshot views | ||
creating data views | creating data views | ||
Line 21: | Line 25: | ||
calculating statistics to filter the location table | calculating statistics to filter the location table | ||
− | == Registering the WCS and WFS for point data == | + | == Registering the WCS and WFS for point data ??? what is in this section ?== |
WFS for locations | WFS for locations | ||
Line 27: | Line 31: | ||
WCS for data | WCS for data | ||
− | registering using python dictionaries | + | registering using python dictionaries ?? |
Revision as of 14:06, July 7, 2011
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
Registering the WCS and WFS for point data ??? what is in this section ?
WFS for locations
WCS for data
registering using python dictionaries ??