[wdmmg-dev] [wdmmg-discuss] portugal data

Wed Sep 14 15:48:10 UTC 2011

I have everything ready to load, I'm just waiting for the openspending 
sandbox server to respond and I will load the data.

Cheers,

Carlos

On 14-09-2011 10:35, Carlos FIgueiredo wrote:
> 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
>>>
>>
>>
>