OpenEnergyPlatform / oedatamodel

A common open energy data model (oedatamodel) and datapackage format for energy and scenario data

Creative Commons Zero v1.0 Universal

7 stars 3 forks source link

Include open_MODEX project meeting feedback #37

Open jh-RLI opened 3 years ago

jh-RLI commented 3 years ago

Changes in oedatamodel-concrete and -normalization:

scenario.year to postgis data type tstzrange, updated description field
scenario.region to json data type, updated description field
sclar.region updated description field
[ ] Tested table creation with oem2orm
[ ] Tested data upload

Known Issues:

The tstzrange type is not supported by the oedialect

jh-RLI commented 3 years ago

Tried to create the tables with oem2orm using the OEDataModel-concrete-datapackage.json. It seems like the oedialect does not support the TSTZRANGE type.

oem2orm.create_tables(db, tables_orm) Exeption: ConnectionException: HTTP 400 (Bad Request): Unknown type (tstzrange).

jh-RLI commented 3 years ago

See: https://github.com/OpenEnergyPlatform/oem2orm/pull/9