search

ReeemProject / reeem_db

Code of the reeem_db
GNU Affero General Public License v3.0
6 stars 4 forks source link

adapted table structure and metadata #7 #34

Closed doroschmid closed 6 years ago

doroschmid commented 6 years ago

Hej Ludwig,

I changed the table structure for impacts based on TIMES PanEU data as EcoSense output, icluding adding all metadata (at least I hope so). Instead of re-uploading TIMES PanEU emission data as EcoSense input, I referenced this under 'source' in the metadata.

I included an additional column 'region_2' which contains the country in which the impacts occur (while region is the country responsible for the impacts). Hope this is okay and the description in the metadata captures this. Costs are not separated for region_2 (because they are attributable to the responsible country). Here I just left the column empty.

I also tried to change the EcoSense adapter accordingly, hope it is correct.

Please review both reem_db_setup_ecosense.sql and reeem_adapter_ecosense.py If you give your okay (and set up the table with the new structure) I'll upload the data to the database (it is already on sharepoint).

Ludee commented 6 years ago

sorry for the late reply. I will review and test the changes today.

doroschmid commented 6 years ago

Thank you!