Visualizing Transitland data using Python and GeoPandas
by Kuan Butts
Recently, I posted the above image on Twitter. It generated some positive responses, so I went ahead and generated a few more, one for each continent as well as a few “special requests.” Also included was a script that would allow someone to recreate the same scenes themselves. This post will provide more context around the steps listed out in that notebook, as well as some notes about how tools such as GeoPandas and Shapely can help make the process of exploring Transitland’s API more visual and, perhaps, easier to peruse.
Before I continue, I should note that the Transitland website already has solid documentation. In particular, the API page has a nice table that explains what each of the possible endpoints are and how the requisite parameter must be formatted. It also includes an example for each. Also, the Mapzen Mobility Explorer is a web app that allows easy querying and mapping of much (but not all) of the data in Transitland.
Setting up a search environment
The focus of this post is to show how one can visually explore the API’s offering by location. In order to do this, let’s find a place with Nominatim. Nominatim is a places dataset that is based on OpenStreetMap data. What we will do is design a simple function to query for a particular place and visualize it on the map. Before we continue, we will should also pull down a shapefile for the continents in the world so that we can plot that as well to see where our target area lies on the map. This will help us sanity check where we are working and make sure that our data is what we think it is.
A simple function (below) will allow us to make queries against the Nominatim API. The parameters passed in will allow us to receive a GeoJSON in response. We can then take that JSON and convert it into a Shapely shape object.
With the resulting shape, we have the opportunity to easily pass this through to the Transitland query.
In the above image we can see what the result of running such a query would look like, in this case for Oakland, California.
Preparing the Query into Subcomponents
Using that same helper function we created from the last section, we can now query for the United States the shape of the country. We can pull out the mainland as it is the largest geometry in the MultiPolygon, like so:
Now that we have the “mainland” area, if you will, we can use Shapely’s API to interact with the shape. To query against Transitland’s data, we will need a bounding box. We can get this from the object representing the US mainland:
mainland.bounds. The result of this is the following:
(-125.0840939, 24.2520071, -66.8854162, 49.3844901).
We can now query Transitland for this entire area. In order to ensure that we don’t time out the requests, we’ll need to break this up into a series of numerous, small query. We can design a function to accomplish this recursively as setting limits on the response length in Transitland comes with the ability to “pick up where you left off” and query the next
n features after the ones you just received. This can be useful for downloading queries from larger areas in small chunks.
Below is a sketch of what such a method might look like:
As we can see in the above code, we check if the response JSON contains the
key that would indicate that there are more results to be retrieved from the query. We can also see how we introduce the
bbox (bounding box) as a query parameter. Simply including that and the per page limit allows us to create a simply function that pulls all results for operators that intersect that area in incremental 50-unit chunks. Only on the final return that exits the top level function do we convert the operator shapes to the meter based projection that we are also going to be using for the continents.
As of the time of this post, there were 606 operators that were returned using the above query. If we plot the resulting GeoDataFrame, we can see that our results include a number of operators that are national in scale. These large operators also include some placeholder shapes that wrap the length or height of the entire projection plane. We should drop these out.
Let’s just go with something arbitrary and check out the results. Let’s say that we want to keep anything that is about 200 by 200 miles. This would be 40,000 square miles. Converting that to square meters (the projection the operators are presently in) would look like this:
Go ahead and plot that result.
What should be visible should look similar to the above. As you can see, results should appear to roughly correlate to the shape of the portion of the United States we are working with. At this point, it would be helpful to have some context. In this case, we can use that “mainland” USA shape from earlier.
The following script should produce the above image. By passing the
ax axis object from one plot operation to the next, we are able to layer plots on top of one another in Matplotlib, such that the resulting image from the two plot operations is a single
As you can see, the shapes are fairly abstract. There shapes correspond to the convex hull, representing an approximate area of coverage for all routes and stops within that transit feed.
Getting to squares helps make the coverage map more visually clear. To generate this image instead, we simply need to replace each geometry with its corresponding bounds. This can be retrieved via the Shapely class’s
In the next section, let’s work on pulling down some context layers to use with our operator shapes.
Generating a base layer
When plotting the results, it will be helpful to have a base layer. A base layer in this case might best be the continents of the world. While we did have the “mainland” layer that we used in the prior section, it would be helpful to include the entire world, particularly if we are floating around the map making queries and don’t want to worry whether or not we have the appropriate part of the world already loaded up.
The below function will pull a GeoJSON that is hosted on Github down via the
requests library. It loads the response text as a JSON and then pulls out the GeoJSON component. It takes that and loads it in as a GeoDataFrame. You’ll also note that the projection is explicitly stated and updated within the function. It starts being pulled down as EPSG 4326. This is a common, degrees-based projection. We convert it to EPSG 3857, which is a common meter based projection that has coverage over the whole plant. This allows us to think of area and shape perimeter in terms of meters, which will be handy when thinking about the shapes and area of coverage more intuitively.
Once we execute this function, we can plot the results to view the countries. The resulting GeoPandas GeoDataFrame behaves similarly to a Pandas DataFrame. In fact, all methods that can be performed on a Pandas DataFrame can be performed on a GeoPandas GeoDataFrame. A GeoPandas GeoDataFrame simply requires a column that holds within it Shapely geometry objects. GeoPandas GeoDataFrames offer a set of methods that allow row-wise operations to be performed on each of those Shapely geometry objects held in the geometry column. In addition to geometry manipulation, there are added plotting capacities on top of Pandas’s that will enable plotting of spatial information.
The below code uses the GeoDataFrame’s plotting functionality and will plot all continents (save for Antarctica, which is queried out). The output of this function is visible in the above image. If working in a Jupyter Notebook, make sure that the inline plotting setting is added by including
%matplotlib inline at the top of your notebook.
Using the base layer we generated, we can easily move to new parts of the world. We can generate plots on subsets of total continents by breaking down the MultiPolygons of each continent. We can do so by iterating through each, so that we only deal with single Polygons at a time, like so:
Exploring new areas
With out broken down continents layer, we can now draw new subsets of the world on a map. Let’s go to GeoJSON.io, for example, and draw a rough border around New Zealand and Australia. Using the draw functionality on this page, it should be easy to draw a rough polygon around these two countries. Once we have that, go ahead and cut and paste that shape from the right hand side GeoJSON string. It should look like this:
With this result, we should be able to intersect that cleaned continents layer and keep only the areas that we want that are relevant to the countries of interest. With this subset, we can perform the recursive Transitland search to get all Transitland operators that lie within those bounds as well.
Merging the two should result in the above image.
Above, another plot, this time of Europe and western Russia. As you can see, this pattern is easily reproducible anywhere.
At this point you should be free to explore the feeds available on Transitland — there’s a ton of them! Need ideas for what to explore next? How about choosing a more refined base layer if you’d like to work at a “closer” scale and explore and work with transit bounds data at, for example, the county and census tract scale in the United States. For example, here are the number of transit operators provided by Transitland within each U.S. Census combined statistical area:
Alternatively, download a copy of original GTFS zip file from Transitland using the feed versions API endpoint or the Feed Registry user interface. Once you have downloaded the zip file, there’s plenty of tools out there to parse and explore a single GTFS feed on your computer. If you enjoy working with Pandas DataFrames and find this data structure convenient when working with ordered datasets such as GTFS (I do!), then you may enjoy Partridge. This is a new but promising library that proposes a standard for how one might organize transit schedule data across a series of Pandas DataFrames.
If you create any interesting visualizations of Transitland data using these recipes, don’t forget to share them!