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 |