review/openfred_weatherdata

[Ludee]

Tables:
Note: metadata just differs at the "resources" key.

• openfred_flags -> review metadata
• openfred_locations -> review metadata
• openfred_series -> review metadata
• openfred_timespans -> review metadata
• openfred_variables -> review metadata

Additional tables:

• supply.openfred_timeseries_ch -> metadata
• supply.openfred_feedin_wind_2016 -> metadata

Keep these tables?:

• tables are in schema model_draft
  

ToDo:

• Create metadata @jh-RLI
• Update metadata to v1.4.1 @jh-RLI
• Check license info @ronny
• Create UML @gnn -> @jh-RLI will provide a simple ERM diagram
• Move into climate schema @Ludee
• Update and release FRED-WAM @christian-rli
• validate metadata using omi @jh-RLI
  - set "alignment": "horizontal" to "alignment": null to avoid omi validation error.
• Add metadata to OEP openfred tables @jh-RLI

[jh-RLI]

@Ludee I think the openfred_powerplants is missing?

[jh-RLI]

Spoke to @Ludee the powerplants table is not part of the weatherdata set and is not to be considered here.

[jh-RLI]

The metadata-strings are created for all listed tables and linked in the issue description. The license information and a short description are still missing.

[rpnaut]

Regarding the openFRED weather data:

They have already an entry in the WDCC:

https://cera-www.dkrz.de/WDCC/ui/cerasearch/entry?acronym=coastDat3_COSMO-CLM_MERRA2

The description and key-words are defined already there:

Name: coastDat3_COSMO-CLM_MERRA2

Project: openFRED (open feed-in time series based on a Renewable Energy Database)

Summary: This is an atmospheric hindcast for Western Europe and the North Atlantic using COSMO-CLM version 5.0 with spectral nudging from 2002-2017. MERRA2 reanalysis data are used as forcing. Additionally transient and monthly aerosol data of the MACv2 climatology are prescribed. The model uses a rotated grid with 566 x 481 grid points and a grid point distance of 0.0625 degrees, the rotated North pole is located at 162.0 W, 39.25 N.
The published data excludes the sponge zone and have 526 x 441 grid points. In rotated coordinates the published simulation data extends from 22.64 W to 10.18 E, 11.2 S to 16.3 N, in geographical coordinates this corresponds to about 12 W to 30 E, 39 N to 60 N.

institution: Helmholtz-Zentrum Geesthacht, Institute of Coastal Research, Germany

source: int2lm_131101_2.00_clm4, COSMO-CLM5.0_clm14_aerosol_gust (available at DKRZ's LTA WDCC service)

contact: http://coastmod.hzg.de

originator: Ronny Petrik

crs: EPSG:4326 ContactDr. Ronny Petrik (✉ ronny.petrik@hzg.de )

Keyword(s): COSMO-CLM, hindcast, MERRA2, openSource, regional modelling, renewable energy