Difference between revisions of "Location Table for Points"

From Earth Science Information Partners (ESIP)
Line 1: Line 1:
 
{{WCS Glossary
 
{{WCS Glossary
|TermDesc=The location table describes the location dimension for point data.
+
|TermDesc=Station Point Data is collected from stationary locations. The location table describes these locations in detail, which then become the location dimension for point data. The data tables only need the loc_code to identify where the data came from. WFS GetFeature Query returns this location table.  
|Links=[http://128.252.202.19:8080/CIRA?service=WFS&version=1.0.0&request=GetFeature&typename=SO4f&outputformat=text/csv CIRA/VIEWS location table]
+
|Links=[[Location_Configuration_for_Points|Location Configuration for Points]] [[SQL_Database_for_Points|SQL Database for Points]] [[WFS_GetFeature_Query|WFS GetFeature Query]]
 
}}
 
}}
  
Line 31: Line 31:
 
     WIMO1, Wichita Mountains, 34.7323, -98.713, 509
 
     WIMO1, Wichita Mountains, 34.7323, -98.713, 509
 
     YELL2, Yellowstone NP 2, 44.5653, -110.4002, 2425
 
     YELL2, Yellowstone NP 2, 44.5653, -110.4002, 2425
 +
 +
[http://128.252.202.19:8080/CIRA?service=WFS&version=1.0.0&request=GetFeature&typename=SO4f&outputformat=text/csv CIRA/VIEWS location table]
 +
 
[[category:Mediator]]
 
[[category:Mediator]]

Revision as of 12:17, September 3, 2010

< Back to Glossary | Edit with Form

Location_Table_for_Points Description: Station Point Data is collected from stationary locations. The location table describes these locations in detail, which then become the location dimension for point data. The data tables only need the loc_code to identify where the data came from. WFS GetFeature Query returns this 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::Location Configuration for Points SQL Database for Points WFS GetFeature Query]]

Contributors

No Contributors

History

No History Available

Term Details


The fields that datafed uses are:

  • Mandatory fields:
    • loc_code: A unique text field, used to identify a location.
    • lat: Latitude of the location in degrees_north
    • Lon: Elevation of the location in degrees_east
  • Optional datafed fields:
    • loc_name: Reasonably short text describing location.
    • elev: elevation in meters.
  • data specific fields:
    • Any field with any name

Good loc_codes are short abbreviations like ACAD and YOSE for Acadia and Yosemite National Parks. Completely numeric loc codes are possible, but more difficult to recognize and since leading zeros are significant, tools like excel may think they're numbers and cut them off.

If the loc_codes are long, like 9 characters, it's useful to generate a numeric 16-bit primary key for the location table and use it for joining the data tables with the location table. This may help in indexing and speed things up quite a bit.

Part of the CIRA/VIEWS location CSV:

   loc_code, loc_name, lat, lon, elev
   WHRI1, White River NF, 39.1536, -106.8209, 3413.5
   WICA1, Wind Cave, 43.5576, -103.4838, 1296
   WIMO1, Wichita Mountains, 34.7323, -98.713, 509
   YELL2, Yellowstone NP 2, 44.5653, -110.4002, 2425

CIRA/VIEWS location table