[open-government] Portuguese database of contracts

Wed Jan 22 10:56:43 UTC 2014

Hi Jorge,

Brilliant work! And rather massive! Thank you for this!

There's a working group busy with open data work in Portugal, 
Transparência Hackday Portugal (www.transparenciahackday.org).
Please join our (portuguese-speaking) mailing list over there, there's 
already a small but significant community talking and hacking around 
these subjects. I'm forwarding your e-mail over there, it's really 
exciting stuff.

[Any portuguese lurkers on the list are more than free to join too!]

Really excited with this. Hope we can discuss more and see where things 
can go from here.

Cheers,
:r

On 01/21/2014 09:07 PM, Jorge Cardoso Leitão 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