Difference between revisions of "Location Configuration for Points"
From Earth Science Information Partners (ESIP)
(New page: {{WCS Glossary |TermDesc=From file [http://128.252.202.19:8080/static/point/point_config.py point_config.py] In it's simplest case, SQL views are used to create required location table, s...) |
|||
| Line 1: | Line 1: | ||
{{WCS Glossary | {{WCS Glossary | ||
| − | |TermDesc= | + | |TermDesc=System expose one table and it's columns as the location table. |
| + | |Links=[http://128.252.202.19:8080/static/point/point_config.py point_config.py] [http://128.252.202.19:8080/static/CIRA/CIRA_config.py CIRA_config.py] | ||
| + | |||
| + | }} | ||
In it's simplest case, SQL views are used to create required location table, so no aliasing is needed. | In it's simplest case, SQL views are used to create required location table, so no aliasing is needed. | ||
| Line 36: | Line 39: | ||
* The location table is called "Site" | * The location table is called "Site" | ||
* "SiteCode", "Latitude" and "Longitude" are aliased to "loc_code", "lat" and "lon". | * "SiteCode", "Latitude" and "Longitude" are aliased to "loc_code", "lat" and "lon". | ||
| − | |||
| − | |||
Revision as of 15:36, September 2, 2010
< Back to Glossary | Edit with Form
Location_Configuration_for_Points Description: System expose one table and it's columns as the location table.
Glossary Domain: {{{Glossary Domain}}}"{{{Glossary Domain}}}" is not in the list (WCS, HTAP, AQInfrastructure) of allowed values for the "Glossary Domain" property.
Related Links
Links to this page
[[Links::point_config.py CIRA_config.py]]
Contributors
No Contributors
History
No History Available
Term Details
In it's simplest case, SQL views are used to create required location table, so no aliasing is needed.
location_info = {
'location':{
'service':'WFS',
'version':'1.0.0',
},
}
These are the standard names that datafed uses:
- The dimension name is "location".
- No aliasing is needed, since the DB table/view and column names are standard.
- The view/table name in the DB is "location".
- The columns are lat", "lon" and "loc_code" and loc_code is a text type, not an integer.
In the CIRA/VIEWS case, table and fields are alised:
VIEWS_location_info = {
'location':{
'service':'WFS',
'version':'1.0.0',
'table_alias':'Site',
'columns':{
'loc_code':{'column_alias':'SiteCode'},
'lat':{'column_alias':'Latitude'},
'lon':{'column_alias':'Longitude'},
}
},
}
- The dimension name is still "location"
- The location table is called "Site"
- "SiteCode", "Latitude" and "Longitude" are aliased to "loc_code", "lat" and "lon".
