[openspending-dev] Storing Geodata on Openspending - is this even a good idea?

Rufus Pollock rufus.pollock at okfn.org
Wed Sep 24 16:24:41 UTC 2014

On 23 September 2014 17:47, Michael Bauer <michael.bauer at okfn.org> wrote:

> Hi there,
> I've realized there is no easy way to turn geographically based budget data
> (e.g. projects in different regions of a country) into a map (e.g.
> choropleth).
> I've thought about creating a mapping visualization for openspendingjs.
> There seem to be two ways to do this:
> A) The user supplies a topojson/geojson file with the visualization and
> which parameters to join the data together.
> B) We store geodata (shapes, points) on Openspending in a dataset.

> ad A)
> Seems to be quite easy to do -

I'd go for this. I assume you'd store the region info on each transaction
and then link that up with the geojson in the viz.

> ad B)
> While it might be weird to add a geometry attribute to dimensions this
> could be a lot more flexible.

I don't think this would be great (at least without a lot of thought). You
definitely want to store the region / province info but not the geometry
itself (IMO).


> e.g. you have geo-references on three levels: Think about projects budgeted
> for in regions and provinces. All three, the project, the region and the
> province have a geographical component. Why not add geometries to all of
> them and have the map determine which level of detail to show based on zoom
> levels?
> Any thoughts are appreciated!
> Michael
> --
> Data Diva | skype: mihi_tr | @mihi_tr
> Open Knowledge | School of Data
> http://okfn.org | http://schoolofdata.org
> GPG/PGP key: http://tentacleriot.eu/mihi.asc
> _______________________________________________
> openspending-dev mailing list
> openspending-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/openspending-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/openspending-dev


*Rufus PollockFounder and President | skype: rufuspollock | @rufuspollock
<https://twitter.com/rufuspollock>Open Knowledge <http://okfn.org/> - see
how data can change the world**http://okfn.org/ <http://okfn.org/> | @okfn
<http://twitter.com/OKFN> | Open Knowledge on Facebook
<https://www.facebook.com/OKFNetwork> |  Blog <http://blog.okfn.org/>*

The Open Knowledge Foundation is a not-for-profit organisation.  It is
incorporated in England & Wales as a company limited by guarantee, with
company number 05133759.  VAT Registration № GB 984404989. Registered
office address: Open Knowledge Foundation, St John’s Innovation Centre,
Cowley Road, Cambridge, CB4 0WS, UK.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/openspending-dev/attachments/20140924/a37bb83d/attachment-0002.html>

More information about the openspending-dev mailing list