header_table¶
element_name | kind | external_table | description |
---|---|---|---|
report_id | varchar (pk) | Unique ID for report (unique ID given by combination of report_id and observation_id) | |
region | int | region:region | Region (WMO region / Ocean basin) |
sub_region | int | sub_region:sub_region | Country / regional sea |
application_area | int[] | application_area:application_area | WMO application area(s) |
observing_programme | int[] | observing_programme:observing_programme | Observing programme, e.g. VOS |
report_type | int | report_type:type | e.g. SYNOP, TEMP, CLIMAT, etc |
station_name | varchar | e.g. GRUAN station name, ship name, site name etc | |
station_type | int | station_type:type | Type of station, e.g. land station, sea station etc |
platform_type | int | platform_type:type | Structure upon which sensor is mounted, e.g. ship, drifting buoy, tower etc |
platform_sub_type | int | platform_sub_type:sub_type | Sub-type for platform, e.g. 3m discuss buoy |
primary_station_id | varchar | station_configuration:primary_id | Primary station identifier, e.g. WIGOS ID |
station_record_number | int | station_configuration:record_number | Together with primary_station_id this forms a link to the station configuration table. |
primary_station_id_scheme | int | id_scheme:scheme | Scheme used for station ID |
longitude | numeric | Longitude of station, -180.0 to 180.0 (or other as defined by station_crs) | |
latitude | numeric | Latitude of station, -90 to 90 (or other as defined by station_crs) | |
location_accuracy | numeric | Accuracy to which station location recorded (radius in km) | |
location_method | int | location_method:method | Method by which location determined |
location_quality | int | location_quality:quality | Quality flag for station location |
crs | int | crs:crs | Coordinate reference scheme for station location |
station_speed | numeric | Station speed over ground if mobile (m/s) | |
station_course | numeric | Station course over ground if mobile (degree true) | |
station_heading | numeric | Station heading if mobile | |
height_of_station_above_local_ground | numeric | Height of station above local ground (m) | |
height_of_station_above_sea_level | numeric | Height of station above mean sea level (m), negative values for below sea level. | |
height_of_station_above_sea_level_accuracy | numeric | Accuracy to which height of station known (m) | |
sea_level_datum | int | sea_level_datum:datum | Datum used for sea level |
report_meaning_of_timestamp | int | meaning_of_time_stamp:meaning | Report time - beginning, middle or end of reporting period |
report_timestamp | timestamp with timezone | e.g. 1991-01-01 12:00:0.0+0 | |
report_duration | int | duration:duration | Report duration |
report_time_accuracy | numeric | Precision to which time was recorded (s) | |
report_time_quality | int | time_quality:quality | Quality flag for report_timestamp |
report_time_reference | int | time_reference:reference | Reference Time (e.g. referenced to time server, atomic clock, radio clock etc) |
profile_id | varchar | profile_configuration:profile_id | Information on profile (atmospheric / oceanographic) configuration. Set to Record ID for profile data or missing (NULL) otherwise. |
events_at_station | int[]* | events_at_station:event | e.g. ship hove to, crop burning etc. |
report_quality | int | quality_flag:flag | Overall quality of report |
duplicate_status | int | duplicate_status:status | E.g. no duplicates, best duplicate, duplicate, not checked. |
duplicates | varchar[]* | header_table:report_id | Array of report_id’s for duplicates |
record_timestamp | timestamp with timezone | Timestamp of revision for this record | |
history | varchar | Sequence of processing steps. Free text with timestamp 1 : history 1; timestamp 2 : history 2 etc. | |
processing_level | int | report_processing_level:level | Level of processing applied to this report |
processing_codes | int[]* | report_processing_codes:code | Processing applied to this report |
source_id | varchar | source_configuration:source_id | Original source of data, link to external table |
source_record_id | varchar | Record ID in source data, e.g. ID of event from GRUAN meta database |