[wdmmg-discuss] portugal data

Wed Sep 14 09:35:13 UTC 2011

Hi everyone,

I am now looking to the argentina dataset.

It looks simple enough:
1 - I'll clean up a bit the csv file (the names of the columns are 
terrible, we should avoid spaces, dots, and characters like º.
2 - I'll create a simple model and load the data so you can look at it. 
It's now 10:33 and I'm off to a meeting. I hope I can deliver by 15h00.

Cheers,

Carlos

On 13-09-2011 17:54, Lucy Chambers wrote:
> Hi All,
>
> I'm afraid, due to my colleague's illness, I will be leaving the
> country tomorrow to cover a workshop.
>
> Martin, however is able to be online at 6pm UK time to help out if
> both parties can make the meeting.
>
> @All - could you please confirm that you can make the meeting (and add
> Martin on Skype if you don't have him already (his name is: mk270_)
> @Angelica - could you confirm whether you have had a look at the
> documentation and your data is as up to date as possible?
>
> http://wiki.openspending.org/Data_Format
>
> Sorry I won't be on the call, but look forward to seeing what becomes of it!
>
> Lucy
>
> On Mon, Sep 12, 2011 at 4:33 PM, Lucy Chambers<lucy.chambers at okfn.org>  wrote:
>> Dear Angelica,
>>
>> Great, I wouldn't worry too much about being able to programme, that
>> is the reason why we are training people like Carlos, although we are
>> trying to eliminate more and more of the technical aspect to make it
>> easier for anyone to do!
>>
>> @Carlos, Argentina team - would you be able to make a call at some
>> point on Wednesday to talk this over further? What times are good for
>> you? I presume evening European time for Carlos will be best?
>>
>> Best,
>>
>> Lucy
>>
>> On Mon, Sep 12, 2011 at 4:03 PM, Peralta Ramos Momi (Gerente de
>> Desarrollo Multimedia)<APERALTA at lanacion.com.ar>  wrote:
>>> Thanks Lucy! Let´s find some time for a call this week because next week I´m travelling for ten days. I´ll copy Ricardo in our team, but please take in consideration we are not Phyton programmers, Ricardo is IT Manager, but not Pyhton programmer!
>>>
>>> Do you suggest we go on or find some phytonist and then make our call ?
>>>
>>> :)
>>>
>>> -----Mensaje original-----
>>> De: okfn.lucy.chambers at gmail.com [mailto:okfn.lucy.chambers at gmail.com] En nombre de Lucy Chambers
>>> Enviado el: Lunes, 12 de Septiembre de 2011 09:48
>>> Para: Peralta Ramos Momi (Gerente de Desarrollo Multimedia)
>>> CC: Carlos FIgueiredo; JeanBrice TETKA; wdmmg-discuss at lists.okfn.org
>>> Asunto: Re: [wdmmg-discuss] portugal data
>>>
>>> Dear Angelica,
>>>
>>> Thanks very much for your email, I'm sorry it's taken so long to
>>> respond, I've been running workshops.
>>>
>>> Since we last spoke, we have had some exciting progress on
>>> OpenSpending, we've been training the data wranglers such as Carlos to
>>> be able to get the data in with a lot less input from us!
>>>
>>> We have also fixed a lot of the infrastructure so good news!, we
>>> should now be in a position to get your data into OpenSpending.
>>>
>>> @Carlos, would you be available at some point this week to help the
>>> guys in Argentina out with the initial part of their load, i.e. the
>>> part you are familiar with? I know you still have some questions so
>>> when you have done as much as you can, perhaps all of us can arrange a
>>> call to kill two birds with one stone and answer some of your
>>> question, while at the same time working with a live dataset.
>>>
>>> @Angelica - could you make sure the data on
>>> http://ckan.net/package/budget-argentinia is up to date and follows
>>> the guidelines set out here: http://wiki.openspending.org/Data_Format
>>> (this is slightly overhauled documentation, to make it easier for
>>> people to use!)
>>>
>>> Then if you could suggest a time when it would be convenient for you
>>> to talk, we will see when we can fit around you!
>>>
>>> All the best,
>>>
>>> Lucy
>>>
>>> On Fri, Sep 2, 2011 at 4:33 PM, Peralta Ramos Momi (Gerente de
>>> Desarrollo Multimedia)<APERALTA at lanacion.com.ar>  wrote:
>>>> Carlos: I´m Angelica from LA NACION in Argentina (http://www.lanacion.com.ar
>>>> ), if you get that data in a visualization form like WDMMG please tell me
>>>> how, as we´ve uploaded our budget data thanks to Fredrich but I have never
>>>> seen the viz.
>>>>
>>>>
>>>>
>>>> Perhaps you can help us, we have no Phython or Php developers for this
>>>> available but we have the best source of Data in Argentina, and we can
>>>> update with running budget.
>>>>
>>>>
>>>>
>>>> Tks
>>>>
>>>> Angelica
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> De: wdmmg-discuss-bounces at lists.okfn.org
>>>> [mailto:wdmmg-discuss-bounces at lists.okfn.org] En nombre de Carlos FIgueiredo
>>>> Enviado el: Viernes, 02 de Septiembre de 2011 11:59
>>>> Para: JeanBrice TETKA; wdmmg-discuss at lists.okfn.org
>>>> Asunto: Re: [wdmmg-discuss] portugal data
>>>>
>>>>
>>>>
>>>> Jean Brice,
>>>>
>>>> I am quite new as you can see from my postings!
>>>> But I would recommend the following:
>>>>
>>>> 1 - Look for a good source of (official) spending data.
>>>> 2 - Take a look at some examples posted on the wiki.openspending.org (See
>>>> countries / Portugal for my case) and in ckan.net
>>>> (ckan.net/package/public_administration_contracts_for_portugal for example)
>>>> 3 - Take a look at the model requirements in the wiki as well see my model
>>>> for example in https://github.com/csfigu/portugal-budget-visualization
>>>> 4 - if you follow this path then it should be "easy" to be able to show
>>>> something like this.
>>>> 5 - Register on the wiki and on ckan and post/upload your data/models
>>>> progress, questions, errors, to make it easier for anyone to help you when
>>>> help is needed.
>>>>
>>>> Look I started this project not even a month ago, I'll try to help but I
>>>> guess the list is the right place to post.
>>>>
>>>> Cheers,
>>>>
>>>> Carlos
>>>>
>>>> then come back to the list and post whatever questions you got.
>>>>
>>>> On 02-09-2011 11:22, JeanBrice TETKA wrote:
>>>>
>>>> Hello,
>>>> I'm starting a budget tracking project for my country Cameroon, and i want
>>>> to use Wdmmg. Can you help me to reach your level? what can i do to get this
>>>> tools on line and enter data?
>>>>
>>>> Cheers,
>>>>
>>>> Jean brice
>>>>
>>>> 2011/9/2 Carlos FIgueiredo<carlosmiguelfigueiredo at gmail.com>
>>>>
>>>> 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
>>>>
>>>> _______________________________________________
>>>> wdmmg-discuss mailing list
>>>> wdmmg-discuss at lists.okfn.org
>>>> http://lists.okfn.org/mailman/listinfo/wdmmg-discuss
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> wdmmg-discuss mailing list
>>>> wdmmg-discuss at lists.okfn.org
>>>> http://lists.okfn.org/mailman/listinfo/wdmmg-discuss
>>>>
>>>>
>>>
>>>
>>> --
>>> Lucy Chambers
>>> Community Coordinator
>>> Open Knowledge Foundation
>>> http://okfn.org/
>>> Skype: lucyfediachambers
>>>
>>
>>
>> --
>> Lucy Chambers
>> Community Coordinator
>> Open Knowledge Foundation
>> http://okfn.org/
>> Skype: lucyfediachambers
>>
>
>