This web application shows the commuter movments for the region Ostwestfalen-Lippe in north-rhine-westfalia. To load commuter movements per municipality hover over it. The app uses data from Landesdatenbank NRW (commuters, population), Basis-DLM250 and OpenStreetMap. The commuter data (2014) is based on an export from Landesdatenbank NRW and was created by an employee from IT.NRW on special request by the researchgroup nextPlace*. The red lines show outgoing movement, the green lines ingoing. Transparency and number of points per line represent the commuter count. The chart visualizes the commuting parts (red/green) on the municipalities population (gray).
The commuter data was given as csv than reformatted and importet into PostgreSQL for further processing. The ingoing und outgoing commuter from the Landesdatenbank NRW where joined to the municipalities centroids to visualize the commuter flow. The municipal IDs called AGS where used to join the commuter data to municipal geometries. To create the polylines centroids for ingoing and outgoing cummutement where processed for each municipal via PostGIS functions (ST_MakeLine, ST_Centroid,...). To animate the movements CSS3 animations and stroke styling is used.
*part of the university of applied sciences ostwesfalen-lippe
#bielefake intentionally not included