[ddj] data-driven-journalism Digest, Vol 51, Issue 3
Peter Borbely
pborbely at fairfaxmedia.com.au
Thu Jun 4 22:24:07 UTC 2015
recent versions of QGIS made it super easy to merge datasets
you need a column of matching values in both dataset, then load both your
shape and your csv in QGIS, then
1. select your shapefile > properties
2. join
3. select columns to join by
4. optional additional settings
5. join + apply
6. save as (geojson)
7. done, happy mapping
hope this helps
On Friday, 5 June 2015, <data-driven-journalism-request at lists.okfn.org>
wrote:
> Send data-driven-journalism mailing list submissions to
> data-driven-journalism at lists.okfn.org <javascript:;>
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> or, via email, send a message with subject or body 'help' to
> data-driven-journalism-request at lists.okfn.org <javascript:;>
>
> You can reach the person managing the list at
> data-driven-journalism-owner at lists.okfn.org <javascript:;>
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of data-driven-journalism digest..."
>
>
> Today's Topics:
>
> 1. Re: Visualizing data on a map of Germany (county-level)
> (Matthew Fullerton)
> 2. Visualizing data on a map of Germany (county-level)
> (Bastian Benrath)
> 3. Re: Visualizing data on a map of Germany (county-level)
> (Daniel Drepper ? CORRECT!V)
> 4. Visualizing data on a map of Germany (county-level)
> (Bastian Benrath)
> 5. Re: Visualizing data on a map of Germany (county-level)
> (Randy Wright)
> 6. Re: Visualizing data on a map of Germany (county-level)
> (Maurizio Napolitano)
> 7. Re: Visualizing data on a map of Germany (county-level)
> (Friedrich Lindenberg)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 4 Jun 2015 14:13:00 +0200
> From: Matthew Fullerton <matt.fullerton at gmail.com <javascript:;>>
> To: "List about Data Driven Journalism and Open Data in Journalism."
> <data-driven-journalism at lists.okfn.org <javascript:;>>
> Subject: Re: [ddj] Visualizing data on a map of Germany (county-level)
> Message-ID:
> <
> CAAm+7TZSQcppk9akGXtXjY0vfz-hnF73Z3Zf5Z-s9NUjeiXDjA at mail.gmail.com
> <javascript:;>>
> Content-Type: text/plain; charset="utf-8"
>
> In case its any help there's a great source of all the Landkreise as
> geojson here:
> https://github.com/isellsoap/deutschlandGeoJSON/tree/master/4_kreise
>
> There are probably various approaches for matching these to the data but in
> terms of coloring things differently according to data, cartoDB is quite
> good (www.cartodb.com).
>
> best,
> Matt
>
> --
> Matt Fullerton
> +49 (0)176 5789 6501
> +44 (0)78 1197 2555
> Freelance Software Developer and EXIST Stipend holder (Project "Tapestry"/
> http://www.smartlane.de/)
>
>
> On 4 June 2015 at 13:40, Bastian Benrath <bbenrath at web.de <javascript:;>>
> wrote:
>
> > Dear list,
> >
> > I?m currently working on visualizing data on a map of Germany and am
> > looking for some advice.
> >
> > My aim is to build something like this:
> > http://live0.zeit.de/infografik/keimkarten/index.html. I got my data as
> > CSV and also the boundaries of the counties (?Landkreise? in German) as
> > shapefiles. I?m trying to bring the two together using Mapbox studio,
> > however I?m not finding the option to color the polygons differently,
> based
> > on the data. Can anybody help me with this? Or recommend another tool
> with
> > which it is easier to visualize the data?
> >
> > Thanks a lot in advance!
> > Bastian
> > (Munich, Germany)
> >
> > _______________________________________________
> > data-driven-journalism mailing list
> > data-driven-journalism at lists.okfn.org <javascript:;>
> > https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> > Unsubscribe:
> https://lists.okfn.org/mailman/options/data-driven-journalism
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20150604/7aad4454/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 2
> Date: Thu, 4 Jun 2015 14:54:07 +0200
> From: Bastian Benrath <bbenrath at web.de <javascript:;>>
> To: data-driven-journalism at lists.okfn.org <javascript:;>
> Subject: [ddj] Visualizing data on a map of Germany (county-level)
> Message-ID: <BB6AFFFC-08B7-46DD-8F2F-E1A04D9F4222 at web.de <javascript:;>>
> Content-Type: text/plain; charset=utf-8
>
> Thanks a lot, Matt! I?ll check that out.
>
> For everybody else: The link broke. I?m planning something like this:
> http://live0.zeit.de/infografik/keimkarten/index.html
>
> Best,
> Bastian
>
>
>
> ------------------------------
>
> Message: 3
> Date: Thu, 04 Jun 2015 15:00:21 +0200
> From: "Daniel Drepper ? CORRECT!V" <daniel.drepper at correctiv.org
> <javascript:;>>
> To: data-driven-journalism at lists.okfn.org <javascript:;>
> Subject: Re: [ddj] Visualizing data on a map of Germany (county-level)
> Message-ID: <55704BE5.7000509 at correctiv.org <javascript:;>>
> Content-Type: text/plain; charset=utf-8
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA512
>
> Hey Bastian:
>
> We worked on this project together with ZEIT. My colleague Stefan
> Wehrmeyer produced a map as well. Here is some background on Github:
>
> https://github.com/correctiv/keimkarte
>
> All best
> Daniel
>
> Am 04/06/15 um 14:54 schrieb Bastian Benrath:
> > Thanks a lot, Matt! I?ll check that out.
> >
> > For everybody else: The link broke. I?m planning something like
> > this: http://live0.zeit.de/infografik/keimkarten/index.html
> >
> > Best, Bastian
> >
> > _______________________________________________
> > data-driven-journalism mailing list
> > data-driven-journalism at lists.okfn.org <javascript:;>
> > https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> > Unsubscribe:
> > https://lists.okfn.org/mailman/options/data-driven-journalism
> >
>
> - --
>
> +49 151 407 95 370
> daniel.drepper at correctiv.org <javascript:;>
>
> @danieldrepper
> @correctiv_org
> @fussballdoping
>
> correctiv.org
> fussballdoping.de
>
> Jede und jeder kann Mitglied der CORRECT!V-Community werden:
> http://community.correctiv.org
>
> Unterst?tzt gemeinn?tzigen Recherche-Journalismus in Deutschland
>
> CORRECTIV - Recherchen f?r die Gesellschaft gemeinn?tzige GmbH
> Huyssenallee 11
> 45128 Essen
>
> Handelsregister Essen
> HRB 25135
>
> Gesch?ftsf?hrer: Dr. Christian Humborg, David Schraven
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG/MacGPG2 v2.0.22 (Darwin)
> Comment: GPGTools - https://gpgtools.org
>
> iQIcBAEBCgAGBQJVcEvlAAoJECJhFyNu8mQFb7UQAN3QLpL/hZ3CLX1sd+yVZ8hT
> gu6Ata66nF2Ld5ufmI0t6rs2xGS4skEJ/Ovxs3cw95R27fxPBYJSAypGE0n5ZHws
> 0BONgxCA+oA5tNF+TU2u1m1vfcwpTmGQOzICVsQZ9k9d2iTxrc5VtLuErzVNY95W
> fFhymKIl6fXdGUiMc3JHxwzedJIEqHj1L9WnbkU0NI9rStiUFyFTE6uN1Qk30aLq
> TTSJv9PsBQT9EEahgZJEIp3Ksi23xKYhCwgfU7R3Bu0TW0CFyyempQ63Jdg2gmKD
> 30aGKg1mAoHlxuYwz8oX2nJiZFfQsO9XqdNhYsLJlafz3MImQD5EcHQosG6NXjrw
> TB/cqKw4t8o12XiplJn6VeFAfOH6KMHgl0DMIyLggy7nbtho5XquVVU2RReMf1KQ
> aPGx1tzNmGMKPglwwhdQjwej9CeBj5FCUiYn/T5l2plBJoN2jBbK+zMhHtPbN/so
> tRUT0CO5n0Hu1E62leY0Y6DywPDwHERFLNYyRiETHLd2LeAzV62Otj2eU+xfVV04
> TPRKJVsIngYzbi8CoqAwMMHGBXOoru2gwG0LX6cux3dr9tRUIY/vw6HlN2dWsUjP
> +/xmPo0GGGpMqn9o9MajryZvLxj8qK+szamuvbuSICgVpUy8gy/Bv/tFoI2qHUFE
> bz25wxfsVCzltilIwJgG
> =uCnd
> -----END PGP SIGNATURE-----
>
>
> ------------------------------
>
> Message: 4
> Date: Thu, 4 Jun 2015 14:53:14 +0200
> From: Bastian Benrath <bastian.benrath at posteo.de <javascript:;>>
> To: data-driven-journalism at lists.okfn.org <javascript:;>
> Subject: [ddj] Visualizing data on a map of Germany (county-level)
> Message-ID: <623240A9-6B68-4137-936D-8EAD0FA07BF9 at posteo.de <javascript:;>
> >
> Content-Type: text/plain; charset=utf-8
>
> Thanks a lot, Matt! I?ll check that out.
>
> For everybody else: The link broke. I?m planning something like this:
> http://live0.zeit.de/infografik/keimkarten/index.html
>
> Best,
> Bastian
>
> ------------------------------
>
> Message: 5
> Date: Thu, 04 Jun 2015 10:42:51 -0400
> From: Randy Wright <rw26 at lrw.net <javascript:;>>
> To: data-driven-journalism at lists.okfn.org <javascript:;>
> Subject: Re: [ddj] Visualizing data on a map of Germany (county-level)
> Message-ID: <557063EB.7010802 at lrw.net <javascript:;>>
> Content-Type: text/plain; charset="windows-1252"; Format="flowed"
>
> I do this kid of work with leaflet by converting the shapefile to
> geojson. When the geojson is loaded,
> you get to set the fill color of each polygon and the properties are
> exposed so you can can select a color based on a property in the geojson
> file. The conversion of shapefile to geojson can be done with a ogr2ogr
> in the gdal package (http://gdal.org). You can probably also do that
> with qgis. (http://www.qgis.org/en/site/). I usually use custom node.js
> scripts to put together geojson with related csv data.
>
> Here are a couple of links:
> http://triblive.com/news/healthnews/7694037-74/county-measles-percent
> (bottom of page)
> and
>
> http://triblive.com/neighborhoods/yournorthhills/yournorthhillsmore/7851465-74/exempt-property-tax
>
> These maps are both taken from government supplied shapefiles.
>
> Randy
>
>
> On 06/04/2015 07:40 AM, Bastian Benrath wrote:
> > Dear list,
> >
> > I?m currently working on visualizing data on a map of Germany and am
> > looking for some advice.
> >
> > My aim is to build something like this:
> > http://live0.zeit.de/infografik/keimkarten/index.html. I got my data
> > as CSV and also the boundaries of the counties (?Landkreise? in
> > German) as shapefiles. I?m trying to bring the two together using
> > Mapbox studio, however I?m not finding the option to color the
> > polygons differently, based on the data. Can anybody help me with
> > this? Or recommend another tool with which it is easier to visualize
> > the data?
> >
> > Thanks a lot in advance!
> > Bastian
> > (Munich, Germany)
> >
> >
> > _______________________________________________
> > data-driven-journalism mailing list
> > data-driven-journalism at lists.okfn.org <javascript:;>
> > https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> > Unsubscribe:
> https://lists.okfn.org/mailman/options/data-driven-journalism
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20150604/e68851aa/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 6
> Date: Thu, 4 Jun 2015 17:06:50 +0200
> From: Maurizio Napolitano <napo at fbk.eu <javascript:;>>
> To: "List about Data Driven Journalism and Open Data in Journalism."
> <data-driven-journalism at lists.okfn.org <javascript:;>>
> Subject: Re: [ddj] Visualizing data on a map of Germany (county-level)
> Message-ID:
> <CAFbYU0sWCjikdbfpJ8VfJ-pmrFJP=
> Na+NSTyODWLi1xWP1dctg at mail.gmail.com <javascript:;>>
> Content-Type: text/plain; charset=UTF-8
>
> On Thu, Jun 4, 2015 at 2:13 PM, Matthew Fullerton
> <matt.fullerton at gmail.com <javascript:;>> wrote:
> > In case its any help there's a great source of all the Landkreise as
> geojson
> > here:
> https://github.com/isellsoap/deutschlandGeoJSON/tree/master/4_kreise
> >
> > There are probably various approaches for matching these to the data but
> in
> > terms of coloring things differently according to data, cartoDB is quite
> > good (www.cartodb.com).
>
> You can also try with topojson and d3 -
> http://bl.ocks.org/mbostock/5925375
> or leaftlet and geojsoncss -
> https://github.com/albburtsev/Leaflet.geojsonCSS
>
>
> ------------------------------
>
> Message: 7
> Date: Thu, 4 Jun 2015 17:25:25 +0200
> From: Friedrich Lindenberg <friedrich.lindenberg at okfn.org <javascript:;>>
> To: "List about Data Driven Journalism and Open Data in Journalism."
> <data-driven-journalism at lists.okfn.org <javascript:;>>
> Subject: Re: [ddj] Visualizing data on a map of Germany (county-level)
> Message-ID:
> <
> CABGw_BujNP72AW3rr87LOFo12-aH_WganonfEywMSvuUr3rydw at mail.gmail.com
> <javascript:;>>
> Content-Type: text/plain; charset="utf-8"
>
> For Germany, check out:
>
> *
>
> http://blog.opendatalab.de/hack/2013/07/15/heilbronn-regionalstatistik-visualisierung/
> * http://checkgermany.de/
> *
>
> http://www.bkg.bund.de/nn_147352/DE/Bundesamt/Geoinformation/Geoinformation-Produktion/Verwaltungsgrenzen/Verwaltungsgrenzen__node.html__nnn=true
>
> The most common issue with German municipal ("Kreis") level data is the
> fact that the regional delimitations (and hence their AGS ids) change
> surprisingly often, the last major reform was in 2009 and affected most of
> Mecklenburg-Vorpommern and Aachen. If the municipal AGS in your data and
> your map files don't match up, the first thing to do is to make sure that
> both refer to the same year. This makes comparisons across different years
> (or even decades) an incredibly tough thing to pull off.
>
> In terms of tools: QGIS, and the tools mentioned here around topojson and
> geojson ;)
>
> Cheers,
>
> - Friedrich
>
> On Thu, Jun 4, 2015 at 5:06 PM, Maurizio Napolitano <napo at fbk.eu
> <javascript:;>> wrote:
>
> > On Thu, Jun 4, 2015 at 2:13 PM, Matthew Fullerton
> > <matt.fullerton at gmail.com <javascript:;>> wrote:
> > > In case its any help there's a great source of all the Landkreise as
> > geojson
> > > here:
> > https://github.com/isellsoap/deutschlandGeoJSON/tree/master/4_kreise
> > >
> > > There are probably various approaches for matching these to the data
> but
> > in
> > > terms of coloring things differently according to data, cartoDB is
> quite
> > > good (www.cartodb.com).
> >
> > You can also try with topojson and d3 -
> > http://bl.ocks.org/mbostock/5925375
> > or leaftlet and geojsoncss -
> > https://github.com/albburtsev/Leaflet.geojsonCSS
> > _______________________________________________
> > data-driven-journalism mailing list
> > data-driven-journalism at lists.okfn.org <javascript:;>
> > https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> > Unsubscribe:
> https://lists.okfn.org/mailman/options/data-driven-journalism
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20150604/04f522e7/attachment.html
> >
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> data-driven-journalism mailing list
> data-driven-journalism at lists.okfn.org <javascript:;>
> https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> Unsubscribe: https://lists.okfn.org/mailman/options/data-driven-journalism
>
>
> ------------------------------
>
> End of data-driven-journalism Digest, Vol 51, Issue 3
> *****************************************************
>
--
Peter Borbély
<myemail at fairfaxmedia.com.au>
Interactivista
Fairfax Media
1 Darling Island Road, Pyrmont 2009
+61 2 8596 4745
pborbely at fairfaxmedia.com.au | @datafunk <http://twitter.com/datafunk>
--
The information contained in this e-mail message and any accompanying files
is or may be confidential. If you are not the intended recipient, any use,
dissemination, reliance, forwarding, printing or copying of this e-mail or
any attached files is unauthorised. This e-mail is subject to copyright. No
part of it should be reproduced, adapted or communicated without the
written consent of the copyright owner. If you have received this e-mail in
error please advise the sender immediately by return e-mail or telephone
and delete all copies. Fairfax Media does not guarantee the accuracy or
completeness of any information contained in this e-mail or attached files.
Internet communications are not secure, therefore Fairfax Media does not
accept legal responsibility for the contents of this message or attached
files.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20150605/2e67bad9/attachment-0002.html>
More information about the data-driven-journalism
mailing list