[open-government] Portuguese database of contracts

Wed Jan 22 10:39:25 UTC 2014

Hi Jorge,

This sounds great. I note that there is already some work tracking
Portuguese contracts in OpenSpending, see:

http://community.openspending.org/2013/12/processing-data-for-open-spending/
https://openspending.org/pt_ajustes-diretos

Given your interest in this specific topic around public financial
information can I suggest joining the OpenSpending list and sending your
update there:

https://lists.okfn.org/mailman/listinfo/openspending

And to get involved with the community and start contributing please see:

http://community.openspending.org/contribute/

Regards,

Rufus

Rufus

On 21 January 2014 21:07, Jorge Cardoso Leitão <jorgecarleitao at gmail.com>wrote:

> Hi.
>
> I'm a portuguese doing my PhD in Dresden (on physics) and on my free time
> I do some analysis to the portuguese public procurements. I recently found
> the open knowledge foundation.
>
> In concrete, I have a website and API using Django ORM (github<https://github.com/jorgecarleitao/public-contracts>)
> that daily crawls* the official portuguese database<https://index.okfn.org/country/Portugal/spending> of
> public procurements and I provide open sql access to a remote mysql
> database I designed and populated (see readme<http://public-contracts.readthedocs.org/en/latest/tools/database.html>).
> I'm now asking questions to the data like "When do portuguese
> municipalities contract most?<http://contratos.publicos.pt/quando-e-que-os-municipios-mais-contratam>
> "
>
> It seems that you are already doing this kind of stuff for some time, and,
> in particular, I'm doing what the international transparency in Slovakia
> is doing <http://tender.sme.sk/en/reports?cut=contract_date:2014,01>.
>
> What I've done so far is of a very limited scope: only now I'm finding
> that there is an actual community very interested in this kind of stuff,
> which I'm thrilled to find!
>
> So, with this e-mail I'm trying to introduce myself and this little
> project to this community, in the hope of receiving some feedback. I'm a
> little overwhelmed by the amount of information the foundation has on the
> website, and some guidance would be great. E.g., does this database and/or
> project fits in the foundation in any way?
>
> In the meanwhile, how can I help you?
>
> I like this subject a lot and I agree with the vision of the foundation.
> I'm not an expert in database or web development, thus I'm more into posing
> scientific questions. Nevertheless, I'm also capable of designing and
> querying a database, git, etc.
>
> Cheers,
> Jorge
>
>
> *The crawling was made posterior to confirmation with the official
> database provider that I'm allowed to do so ;-)
>
> _______________________________________________
> open-government mailing list
> open-government at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/open-government
> Unsubscribe: https://lists.okfn.org/mailman/options/open-government
>
>

-- 

*Rufus PollockFounder and Executive Director | skype: rufuspollock |
@rufuspollock <https://twitter.com/rufuspollock>The Open Knowledge
Foundation <http://okfn.org/>Empowering through Open
Knowledgehttp://okfn.org/ <http://okfn.org/> | @okfn
<http://twitter.com/OKFN> | OKF on Facebook
<https://www.facebook.com/OKFNetwork> |  Blog <http://blog.okfn.org/>  |
 Newsletter <http://okfn.org/about/newsletter>*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/open-government/attachments/20140122/93c50b8b/attachment-0003.html>