After more than a month spent casually fooling around with PgRouting, a network analysis extension for PostGIS, I finally have all the dependencies sorted out and the program successfully installed! Basically, this will enable calculations like finding the shortest path between two points, solving traveling salesman problems, and most interestingly for us, calculating the minimum cost/distance to any other point in the network. What all that means is that I can now make really cool maps like this that use actual street network topology rather than distance as-the-crow-flies to calculate travel times/distances.
I promise you’ll have some very neat things to look at in the near future! I’d like to use this tool to finally get a solid idea of what areas around here are really accessible by convenient transit and not just seemingly adjacent to a line that’s either low-frequency or inaccessible by foot.