Dataset landingpage: ClimateBasis Zackenberg - Air temperature - Air temperature, 200cm - 30min average (°C)

Dataset specification

  • Title: ClimateBasis Zackenberg - Air temperature - Air temperature, 200cm - 30min average (°C)
  • Description: Incorrect syntax near '°'. Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. create view View_ClimateBasis_Zackenberg_Data_Air_Temperature_Air_temperature_200cm__30min_average_°C as WITH CUST_CTE(id,[Columnname],Data,RID) AS ( SELECT id,[Columnname],Data , ROW_NUMBER() OVER (PARTITION BY ([Columnname])ORDER BY Row_id,ID) AS RID FROM climateBasis_zackenberg_Data where program_id=4 and programGroup_id=17 and Groupelement_id=689 ) SELECT [Date], [Time], [AT (°C)] FROM (SELECT [Columnname],Data,RID FROM CUST_CTE)C PIVOT ( max(Data) For ColumnName in ([Date], [Time], [AT (°C)]) ) as PivotTable; create view View_ClimateBasis_Zackenberg_Data_Air_Temperature_Air_temperature_200cm__30min_average_°C as WITH CUST_CTE(id,[Columnname],Data,RID) AS ( S Air temperature:Air temperature ClimateBasis Zackenberg:The ClimateBasis programme monitors climate and hydrology in Zackenberg, Kobbefjord and Disko (Qeqertarsuaq) and is run by Asiaq - Greenland Survey. The collected data build base-line information on climate variability and trends for all the other sub-programmes within GEM and serve as a trustworthy foundation for adaptation strategies for the Greenlandic society. The stations are embedded in Asiaq’s extensive climate and hydrology monitoring network. Furthermore, the run-off data is delivered to the World Hydrological Cycle Observing System (WHYCOS) and the Global Runoff Data Centre (GRDC) networks.
  • DOI: 10.17897/G5WS-0W04 - https://doi.org/10.17897/G5WS-0W04
  • Location/site: Climate Stations - -20.55208333, 74.47191667 (lon-lat wgs84)
  • Date span of the dataset: 2009-06-22 - 2019-12-31

Data originator, license and how to download the dataset

The dataset is a product of the Greenland Ecosystem Monitoring program (GEM): https://grid.ac/institutes/grid.507580.f. It is free and open data, licensed with terms of use under the Creative Commons CC-BY-SA license: https://creativecommons.org/licenses/by-sa/4.0/ When downloading you will automatically get a terms of use document, describing how to cite the data and other important information.

Download the dataset via this link (registration needed): http://data.g-e-m.dk/log-in/data-tables?doi=10.17897/G5WS-0W04

Variables measured / columns in dataset

ID Name Unit Data Type Description
http://data.g-e-m.dk/datasets?doi=10.17897/G5WS-0W04&column=Date Date YYYY-MM-DD Date Date of observation
http://data.g-e-m.dk/datasets?doi=10.17897/G5WS-0W04&column=Time Time HH:MM Time Time of observation (UTC)
http://data.g-e-m.dk/datasets?doi=10.17897/G5WS-0W04&column=AT+(%c2%b0C) AT (°C) °C Number Air temperature, 200cm - 30min average (°C)