ERSA Congress Demo
|Datum:||30 augustus 2017|
|Auteur:||Leon van der Meulen, Daniella Vos|
Geodienst is also present during the ERSA 2017 Congress, one of the main Regional Science conferences. We have several demo's available at our stand with out interactive touchscreens. You can find more info and links to these demo's below.
For the northwestern part of Fryslân, the Netherlands, we made several maps analyzing the future distribution of education services in the region. The analysis is based on estimations of the number of pupils per primary school in the area in 2030 made by scientists from the faculty of Spatial Sciences.
The current threshold for a primary school to stay open is 23 pupils. When a the number of pupils in a school drops below this threshold it usually has to be closed. According to predictions the number of young people will decrease in this area. As a consequence, some schools might have to close or merge. How can we anticipate this change?
One of the possibilities is to increase the threshold to 60 pupils and see which schools remain in danger of closing.
The map we made in ArcGIS Online shows two situations: the left hand side shows the current threshold of 23 pupils per school. The right hand side shows a threshold of 60 pupils. A service area of 3 kilometer is calculated for every school that reaches the threshold.
Energieopwek is a web application that provides an insight into sustainable energy production in the 12 provinces of the Netherlands. The Geodienst was a partner in developing the application, which was based upon the expert knowledge of researchers from the Hanzehogeschool Groningen (Entrance).
Energieopwek shows how many households are powered by sustainable energy produced by wind-, solar- and biogas installations at any time of day. The site also gives an idea of the total production in megawatts, regional differences in production and the share of energy production from each sustainable source.
The website is the result of the partnership between the Geodienst of the University of Groningen, TenneT, Netbeheer Nederland, Gasunie New Energy and Entrance. The Geodienst is responsible for the technical realisation of the interface, for which we combined the models made by Entrance with weather data provided by the Royal Netherlands Meteorological Institute (KNMI). This application was optimized for both web and mobile devices.
The municipality of Groningen is changing the center of town to become more bike and pedestrian friendly. In order to do this, they have changed the public transportation system, leading buses around the city center rather than straight through it. This means that a number of bus stops will disappear in the near future. The change led to a discussion about the accessibility of the city center for citizens and visitors.
In order to determine the effects these changing bus routes will have on the accessibility of shops and facilities in the center of town we did a couple of things. First we needed data regarding the facilities in the city center. In order to get this data, we spent several days mapping all of the facilities in the city center using OpenStreetMap.
After collecting the data, we used pgRouting, a network analysis tool in PostGIS to analyze walking distance from public transportation stops towards facilities in both the old and the new public transportation situation, which happened in a matter of minutes. The results of these analyses were then gathered and visualized in an interactive dashboard using Microsoft Power BI.
The Dutch OV-fiets (bicycle) is a popular method of transportation in urban areas. The bikes can be hired at almost every station in the Netherlands and are a fast and efficient way to travel from/to the station. However, their increasing popularity has led to shortages at several stations, meaning that some travelers are unable to rent these bikes during certain hours.
The amount of bicycles present at any station is available through the website of the NS (Dutch Railways). In an effort to collect and enhance the quality of this data, we used Esri web-tools to create a web application which automatically gathers bicycle counts at every station and generates a map providing information about bike availability at all train stations in the Netherlands. The data gathered from this website is stored in a database, which enables us to do carry out some interesting analyses.
In order to determine which stations have structural shortages of bicycles, we used R to create a dashboard environment that visualizes the amount of available bikes at each station throughout the day. This dashboard provides travelers with information about the availability of an OV-fiets, and researchers with interesting data about the use of these bicycles.
The service area of a hospital can be an important factor in life threatening situations. How far do people in the Netherlands live from a hospital? In order to determine that we made a web-map where you can see the service area of hospitals in the Netherlands.
This web-map is powered by d3js. Using this library enables an interactive web-map where clicking on a point automatically loads the data for that point. The network analysis was done by using pgRouting, a network analysis tool in PostGIS. Together these two tools enable us to see the postal areas that are serviced by a certain hospital, either by clicking on the map or searching for a hospital in the search bar.
Municipalities share the locations of their polling stations on their websites, each in their own way. In order to create a clearer overview of where the polling stations are located and how to get to them, we developed the Stemwegwijzer. We gathered data from the websites of municipalities and created a dataset containing all of the polling station locations in the Netherlands.
To quickly create a visualization for every single municipality, like the one you can see on the back of this card, we used the QGIS Atlas functionality. This plugin allows you to run the same visualization style on as many maps as you like.
Finding the shortest path to a polling station is easy (by default Stemwegwijzer picks the nearest polling station), you simply have to fill in an address or drag and drop your location marker. The routes are calculated using OSRM and the road network from OpenStreetMap.
Municipalities can charge precario taxes on underground water, gas and electricity pipelines. Water companies can apply this charge directly to their customers in the municipalities charging these costs. However, electricity companies should distribute the costs across all customers, including those in municipalities not applying these taxes. As a result, many people pay taxes to municipalities where they may never have set foot in, without being aware of it. The precario interactive viewer shows which municipalities are on the charging side, and which pay the tax to others.
This web-map is powered by d3js. Using this library enables an interactive viewer where clicking on an area automatically loads the data for that municipality. By clicking on a municipality you can see if it received precario tax from residents of other municipalities or if it pays taxes to other municipalities.