[wdmmg-dev] Translating #opendata film: Greek

Wed May 25 10:32:42 UTC 2011

Trying again - spelling the address correctly this time!

On Wed, May 25, 2011 at 11:31 AM, Lucy Chambers <lucy.chambers at okfn.org> wrote:
> Hi Teo,
>
> Thank you for your email. Sorry for the delay in getting back to you!
>
> I am Cc'ing our development list to look into the problems you
> mention. The rest of my answers are inline!
>
> On Mon, May 16, 2011 at 7:03 PM, Thodoris Papadopoulos
> <thodoris at thodoris.net> wrote:
>> Hi Lucy ,
>>
>> First of all , I would like to let you know that i have added the details
>> about Greece on the wiki page.
>>
>> Now regarding the registration of the dataset.
>> I would like to register the Greek decisions dataset on http://ckan.net/ ,
>> but i face the following problem.
>> The total amount of decisions since the program's initiation are almost
>> 1.000.000.
>> All the decisions are available via the API but for performance reasons, the
>> number of results returned by the API is limited to 500 decisions, with
>> additional information about the number of total results being available in
>> the queryInfo element. One may use the from and count parameters to retrieve
>> additional results.
>>
>> So for Instance if someone want to retrieve the decisions of a specific day
>> he will
>>
>> 1. call :
>> http://opendata.diavgeia.gov.gr/api/decisions?datefrom=21-10-2010&dateto=22-10-2010&output=full
>>
>> This will return the first 500 decisions for 21/10/2010 , and will also
>> contain the following queryinfo
>>
>> <queryInfo><count>500</count><from>1</from><order>desc</order><total>854</total></queryInfo>
>> which indicates that the total number of decisions for this date are 854 ,
>> so next he will have to call the api using the from parameter
>>
>> 2.
>> http://opendata.diavgeia.gov.gr/api/decisions?datefrom=21-10-2010&dateto=22-10-2010&output=full
>> &from=500
>> Which will return the rest 354 decisions of that date.
>>
>>
>> As you can see this is dynamic and depends on the number of decisions.
>> I can;t figure out any way to register this kind of dataset on ckan.net.
>> But if any member of your supporting team , has any idea that can help
>> ,please let me know.
>
> @Dev - is there any way round Teo's problem?
>
>> Meanwhile , i am still trying to find a way to
>> 1) Get all the Greek Budget Data
>> 2) to transform them to COFOG format.
>>
>> in order to implement WDMMG.
>>
>> Also , i would like to suggest an idea for your next meeting.
>> In my opinion it would be very helpful to provide a Virtual PC image (e.g
>> VMWare , VirtualPC ,VirtualBox) preloaded and configured with the software
>> that is necessary to run WDMMG.
>> This way , it would be easier for people to test and prepare local
>> implementations.
>
> This is an excellent idea and similar to what we are actually
> contemplating. We are currently trialling a 'sandpit' where people can
> upload their data into a test database and play around with it.
> Perhaps - when we sort the above problem, we can ask you to trial your
> data in the system using the documentation we provide (we can be there
> to offer support too!)?
>
>
> Thank you for this, we'll look to get your question answered asap!
>
> Lucy
>
>
>> Nice to speak with you too , and i will be in contact.
>>
>> Teo
>>
>> On Wed, May 11, 2011 at 12:42 PM, Lucy Chambers <lucy.chambers at okfn.org>
>> wrote:
>>>
>>> Dear Teo,
>>>
>>> This is really interesting! Answers inline...
>>>
>>> On Fri, May 6, 2011 at 1:44 PM, Thodoris Papadopoulos
>>> <thodoris at thodoris.net> wrote:
>>> > Hi Lucy ,
>>> >
>>> > Following up from the last meeting ,
>>> > i send you some details regarding data availability for Greece.
>>> >
>>> >> Beginning October 1st  2010, Cl at rity Program legislation is on effect
>>> >> (http://diavgeia.gov.gr/en)
>>> >> Cl at rity program requires each public organization (ministry ,
>>> >> municipalities , public services etc...) to publish every single
>>> >> decision
>>> >> they take on a specific governmental website.
>>> >> Henceforth, the decisions of the public entities can not be implemented
>>> >> if
>>> >> they are not uploaded on the Clarity websites, each document is
>>> >> digitally
>>> >> singed and assigned a transaction unique number automatically by the
>>> >> system.
>>> >>
>>> >> The decisions published , contain meta-data which differ depending on
>>> >> the
>>> >> type of the decision (e.g Expenses , Budgets , Laws , Decrees etc...).
>>> >> The whole program is suportes by an API
>>> >> (http://opendata.diavgeia.gov.gr/?lang=en)  , which is publicly
>>> >> available
>>> >> and allows the retrieval of the underlying datasets. This API grants
>>> >> access
>>> >> to all decisions and decrees issued by the Greek public authorities
>>> >> according to the Transparency law. All data is available under a
>>> >> Creative
>>> >> Commons - Attribution license.The API uses RESTful-like calls and
>>> >> returns
>>> >> the data in XML , Json , rss and atom  format.
>>>
>>>> This is very interesting indeed. Could I ask you to register this
>>>> package on http://ckan.net/? This is our data hub which allows users
>>>> to register interesting datasets that they find so that it is easier
>>>> for the public to find them. This would be really useful!
>>>
>>> >> Using this API  one can retrieve all the expenses of all public
>>> >> organizations , for a specific day :
>>> >>
>>> >> http://opendata.diavgeia.gov.gr/api/decisions?type=27&datefrom=05-05-2011&dateto=06-05-2011
>>> >>
>>> >>
>>> >
>>> > If you think those information are interesting  , please feel free to
>>> > publish them on http://wiki.openspending.org/Countries , or let me know
>>> > how
>>> > i can do that.
>>>
>>> Please do go ahead and add the information to the Wiki for Greece:
>>>
>>> http://wiki.openspending.org/Countries#Greece (simply click edit next
>>> to Greece and copy and paste straight in)
>>>
>>> > Thank you again for the last meeting. I know i didn't spoke a lot but my
>>> > sound was very bad (Half of the words were coming broken to me) and my
>>> > English is not so good.
>>>
>>> Not at all - it was great to speak to you, I hope it was useful.
>>> Please stay in contact and give me a shout if there is anything you
>>> need!
>>>
>>> Best wishes,
>>>
>>> Lucy
>>>
>>>
>>> >
>>> >
>>> > On Wed, May 4, 2011 at 12:07 PM, Lucy Chambers <lucy.chambers at okfn.org>
>>> > wrote:
>>> >>
>>> >> Dear Thodoris,
>>> >> Fantastic - and English is not a problem at all, I speak not a word of
>>> >> Greek so I cannot complain and we will write notes on the pad as we go
>>> >> along
>>> >> so you can both read and listen ;)
>>> >>
>>> >> Really looking forward to speaking to you,
>>> >> Lucy
>>> >> On Wed, May 4, 2011 at 8:28 AM, Thodoris Papadopoulos
>>> >> <thodoris at thodoris.net> wrote:
>>> >>>
>>> >>> Hi Lucy ,
>>> >>>
>>> >>> Indeed I still face some problems with Greek bureaucracy. The
>>> >>> decisions
>>> >>> take too long to be taken
>>> >>> Even though, I think it will be very useful to participate in tomorrow
>>> >>> meeting.
>>> >>> I have already added my user name and full name to the pad.
>>> >>>
>>> >>>
>>> >>> I apologize in advanced , for me English ,
>>> >>> and I am looking forward to speak with you.
>>> >>>
>>> >>> Thank you again for your help
>>> >>>
>>> >>> Thodoris
>>> >>>
>>> >>>
>>> >>>
>>> >>>
>>> >>> On Tue, May 3, 2011 at 4:53 PM, Lucy Chambers <lucy.chambers at okfn.org>
>>> >>> wrote:
>>> >>>>
>>> >>>> Hi Thodoris,
>>> >>>>
>>> >>>> Just following up from our conversation a couple of weeks ago. We are
>>> >>>> holding another OpenSpending meeting on (this) Thursday, 5th May at
>>> >>>> 7pm UK (6pm UTC) / 8pm CEST and you are very welcome to join.
>>> >>>>
>>> >>>> Even if you have not had any luck with finding out whether you are
>>> >>>> allowed to use the Greek Data - it may be helpful for you to come
>>> >>>> along to see what you would need in order to produce a visualisation.
>>> >>>> Often, people first just provide a sample, and more information can
>>> >>>> be
>>> >>>> added later ))
>>> >>>>
>>> >>>>
>>> >>>> If you would like to join the call, please simply add your name and
>>> >>>> Skype ID to the pad below so that I can pull you into the call!
>>> >>>>
>>> >>>> http://wdmmg.okfnpad.org/meeting-2011-05-05
>>> >>>>
>>> >>>> If this isn't convenient, please let me know and we will work to find
>>> >>>> a date and time that works for you,
>>> >>>>
>>> >>>> Have a lovely day and hope to speak to you soon!
>>> >>>>
>>> >>>> Lucy
>>> >>>>
>>> >>>> On Wed, Apr 20, 2011 at 11:58 PM, Thodoris Papadopoulos
>>> >>>> <thodoris at thodoris.net> wrote:
>>> >>>> > Dear Lucy,
>>> >>>> >
>>> >>>> > Thank you very much for your response and your interest.
>>> >>>> > It΄s really encouraging to know that there are people with
>>> >>>> > expertise
>>> >>>> > who
>>> >>>> > already have develop something so intersting and are willing to
>>> >>>> > help.
>>> >>>> > Unfortunatelly , i will not be able to participate in tomorrow's
>>> >>>> > meeting ,
>>> >>>> > cause i will be out of Athens (and office) till Monday.
>>> >>>> > Although , it would be great for me to attend the next one on 5th
>>> >>>> > of
>>> >>>> > May.
>>> >>>> > Meanwhile i will have time to finilize some details for the greek
>>> >>>> > implementation , and make sure that we can  have access to the raw
>>> >>>> > datasets
>>> >>>> > of the Greek Governement.
>>> >>>> >
>>> >>>> > Thank you again ,
>>> >>>> > Regards
>>> >>>> >
>>> >>>> > Thodoris
>>> >>>> >
>>> >>>> > On Wed, Apr 20, 2011 at 8:17 PM, Lucy Chambers
>>> >>>> > <lucy.chambers at okfn.org>
>>> >>>> > wrote:
>>> >>>> >>
>>> >>>> >> Dear Thodoris,
>>> >>>> >>
>>> >>>> >> Thank you very much - we are also very excited about Where Does My
>>> >>>> >> Money Go and how we can help people spread it internationally!
>>> >>>> >>
>>> >>>> >> In case you are interested, we regularly hold online community
>>> >>>> >> meetings specifically for people interested in developing a
>>> >>>> >> similar
>>> >>>> >> platform so they can ask their questions directly to the people
>>> >>>> >> behind
>>> >>>> >> the projects. The next one is actually tomorrow, Thursday 21st
>>> >>>> >> April
>>> >>>> >> at 7pm UK (6pm UTC) / 2pm EST / 8pm CEST - would you be interested
>>> >>>> >> in
>>> >>>> >> attending?
>>> >>>> >>
>>> >>>> >> If you would be interested in coming along, please simply add your
>>> >>>> >> name and Skype ID to the pad below.
>>> >>>> >>
>>> >>>> >> <http://wdmmg.okfnpad.org/meeting-2011-04-21>
>>> >>>> >>
>>> >>>> >> Please also feel free to add any items to the agenda that you
>>> >>>> >> would
>>> >>>> >> like to discuss.
>>> >>>> >>
>>> >>>> >> These are bi-weekly, so if you can't make this one at such short
>>> >>>> >> notice - please don't worry, the next one is due to take place on
>>> >>>> >> 5th
>>> >>>> >> May at the same time or we can schedule a meeting at your
>>> >>>> >> convenience.
>>> >>>> >>
>>> >>>> >> You may also be interested in joining the mailing list for this
>>> >>>> >> project if you are not already on it (link below). Often - it
>>> >>>> >> works
>>> >>>> >> quite well to write a brief introductory email to the list to say
>>> >>>> >> what
>>> >>>> >> you are interested in and see if there is anyone on the list who
>>> >>>> >> is
>>> >>>> >> interested in similar things or would be looking to participate
>>> >>>> >> with
>>> >>>> >> you.
>>> >>>> >>
>>> >>>> >> <http://lists.okfn.org/mailman/listinfo/wdmmg-discuss>
>>> >>>> >>
>>> >>>> >> Either way - I look forward to hearing from you in the near future
>>> >>>> >> and
>>> >>>> >> wish you the best of luck with your project!
>>> >>>> >>
>>> >>>> >> Kind regards,
>>> >>>> >>
>>> >>>> >> Lucy
>>> >>>> >>
>>> >>>> >> On Wed, Apr 20, 2011 at 2:05 PM, Thodoris Papadopoulos
>>> >>>> >> <thodoris at thodoris.net> wrote:
>>> >>>> >> > Hello and thank you ,
>>> >>>> >> > My full name is Thodoris Papadopoulos
>>> >>>> >> > I am 34 years old , coming from the IT industry with over 12
>>> >>>> >> > years
>>> >>>> >> > of
>>> >>>> >> > experience.
>>> >>>> >> > I currently work for the Greek Government.
>>> >>>> >> > My personal weblog is http://www.thodoris.net/weblog (in greek
>>> >>>> >> > language
>>> >>>> >> >  and
>>> >>>> >> > currently under heavy redesign)
>>> >>>> >> > I will stay in touch cause the next few months i am going to
>>> >>>> >> > work
>>> >>>> >> > on the
>>> >>>> >> > "Where Does my Money Go" Project for Greece.
>>> >>>> >> > Congratulations again , for your initiative and projects
>>> >>>> >> > Thodoris Papadopoulos
>>> >>>> >> > On Wed, Apr 20, 2011 at 1:43 PM, Lucy Chambers
>>> >>>> >> > <lucy.chambers at okfn.org>
>>> >>>> >> > wrote:
>>> >>>> >> >>
>>> >>>> >> >> Dear Thodoris,
>>> >>>> >> >>
>>> >>>> >> >> Amazingly - a Greek translation of the #opendata film has
>>> >>>> >> >> appeared
>>> >>>> >> >> online in the last couple of days - thank you! Please could you
>>> >>>> >> >> send
>>> >>>> >> >> me your full name and details of any affiliations and URLs you
>>> >>>> >> >> would
>>> >>>> >> >> like me to mention in the credits so that we can give you
>>> >>>> >> >> appropriate
>>> >>>> >> >> thanks )))
>>> >>>> >> >>
>>> >>>> >> >> Thank you once again for all your hard work and stay in touch,
>>> >>>> >> >> we
>>> >>>> >> >> would be very interested in hearing from you in the future!
>>> >>>> >> >>
>>> >>>> >> >> Best wishes,
>>> >>>> >> >>
>>> >>>> >> >> Lucy
>>> >>>> >> >>
>>> >>>> >> >> --
>>> >>>> >> >> Lucy Chambers
>>> >>>> >> >> Community Coordinator
>>> >>>> >> >> Open Knowledge Foundation
>>> >>>> >> >> http://okfn.org/
>>> >>>> >> >> Skype: lucyfediachambers
>>> >>>> >> >
>>> >>>> >> >
>>> >>>> >>
>>> >>>> >>
>>> >>>> >>
>>> >>>> >> --
>>> >>>> >> Lucy Chambers
>>> >>>> >> Community Coordinator
>>> >>>> >> Open Knowledge Foundation
>>> >>>> >> http://okfn.org/
>>> >>>> >> Skype: lucyfediachambers
>>> >>>> >
>>> >>>> >
>>> >>>>
>>> >>>>
>>> >>>>
>>> >>>> --
>>> >>>> Lucy Chambers
>>> >>>> Community Coordinator
>>> >>>> Open Knowledge Foundation
>>> >>>> http://okfn.org/
>>> >>>> Skype: lucyfediachambers
>>> >>>
>>> >>
>>> >>
>>> >>
>>> >> --
>>> >> Lucy Chambers
>>> >> Community Coordinator
>>> >> Open Knowledge Foundation
>>> >> http://okfn.org/
>>> >> Skype: lucyfediachambers
>>> >
>>> >
>>>
>>>
>>>
>>> --
>>> Lucy Chambers
>>> Community Coordinator
>>> Open Knowledge Foundation
>>> http://okfn.org/
>>> Skype: lucyfediachambers
>>
>>
>
>
>
> --
> Lucy Chambers
> Community Coordinator
> Open Knowledge Foundation
> http://okfn.org/
> Skype: lucyfediachambers
>

-- 
Lucy Chambers
Community Coordinator
Open Knowledge Foundation
http://okfn.org/
Skype: lucyfediachambers