I’m sorry if this is a dumb question, but I’m trying to get started converting some data to the new OS Data Package format. Yes, of course the format is still being defined but I thought it might be a useful concrete step.
Anyway, I can’t see either in the current OSDP spec or the previous Budget Data Package format an explicit description of how to implement links between various levels of aggregation.
I can think of a couple of ways:
- A single CSV with the levels of hierarchy as different columns: “Department”, “Programme”, “Project” for instance. Downsides: lots of repeated values, and no easy way to see the aggregated numbers. (Perhaps not so important since the analytics platform will do that…?)
- As above, but with additional CSV files for the higher levels: department,csv, programme.csv, project.csv.
But is there then a way to make this hierarchy explicit in the datapackage.json?
Maybe it’s too early to be getting into these specifics?