Skip to content

Fix amalgamation for international aviation and navigation fuels #623

@kaskranenburgQ

Description

@kaskranenburgQ

Problem
The international navigation and aviation fuel datapoints use sum for amalgamation. This breaks when aggregating municipalities into provinces/RES-regions.
Right now, we align these values with the national dataset at municipality level (so we can model Schiphol properly). But when you sum up 18 municipalities into a province, you get 18x the national value, which is obviously wrong.

Solutions
Quick fix: Change amalgamation method to average. This stops the multiplication issue.
Proper fix: Map international transport demand to where it actually happens. Schiphol's aviation demand should only be in Haarlemmermeer, not spread across every municipality. Same for navigation and ports.
The proper fix lets us keep sum as the method and gives accurate data, but requires mapping work. Quick fix can be implemented now.

Metadata

Metadata

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions