In my last blog post I loaded some Irish datasets
into a spatially aware database
Postgres + Postgis within RDS Aurora Serverless and introduced
some spatial functions within Postgis. In this short post we’ll use that data to answer some questions about the
number of people living near the Luas in Dublin. (Note: Luas is a light rail
network in Dublin, Ireland).
The number of people who live within 500 metres (5-8min walk) from a Luas stop in Dublin is close to 227,000 (based on
Small Area Census 2016). I’m
assuming every household in a small area is equidistance to each Luas stops.
The full outer join with the luas_stops table allows us to plot the small area polygons and the luas stop locations
creating the dual axis chart.
The dashboard below describes how the Luas developed over time from its initial launch in 2004 to its last extension
in 2017 (the table below describes the quantity of people been able to access the luas by walking increase since
2004 albeit using census 2016 data). Using the data slider on the RHS allows you to see the progression over time. The
small areas within walking distance of the stops update as you move the slider in addition to the population metric on