[wdmmg-discuss] portugal data

Fri Sep 2 09:20:32 UTC 2011

Hi Nick, Mark, everyone

Glad to report data is available for Portugal in 
http://sandbox.openspending.org/dataset/pt-contract

Some (more) questions:

1 - I managed to load the 157k lines of data. It's a bit on the slow 
side. What can be expected when we go live?

2 - How should incremental data be treated? Theoretically everyday this 
database is updated.

3 - How can I have views with percentages and trends as in 
http://openspending.org/dataset/italyregionalaccounts

4 - How could a UI with maps as in wheredoesmymoneygo.org be set up?

5 - I have set up (2 drilldown dimensions, region with 3 levels and 
institutions, but I am struggling with the namings and the hierarchy 
itself). I am also considering and planning 2 additional dimensions, one 
by themes (education, health, military...) and another by economic 
activity (agriculture, industry, services). Does anyone have procedures 
on any of these 4 dimensions. I guess the obvious path to go for regions 
would be the NUTS regions. What about the others, are there any 
standards we can adopt.

I know it's a lot to deal with and I don't expect definite answers, but 
I wanted to share these ideas and doubts.

Cheers,

Carlos