Category: Transportation

Show expansion of transit networks over the decades using Transit Explorer

Yonah Freemark just launched the biggest expansion of transit network mapping on Transit Explorer and I built a new feature for TE that allows users to visualize the size of a network by decade from 1970 to today.

When looking at a region of the world, change the era of transit network that you’re seeing by selecting a decade from the dropdown menu under the “Change the era” heading. In a moment, the map will automatically refresh.

I’ll show you three cities:

  • Salt Lake City
  • Hong Kong
  • São Paulo

Salt Lake City

The Utah Transit Authority opened its first modern light rail line in 1999 from Salt Lake City to the southern suburb of Sandy. It opened the second line, from downtown Salt Lake City to the University of Utah, in 2001, in time for the 2002 Winter Olympics. Some games and ceremonies were held at the university. FrontRunner commuter rail opened in 2008, and the third light rail line, to the airport, opened in 2011 and various line extensions opened in 2013. A BRT route that opened in 2018 in Provo is also mapped but not shown while a BRT route in Salt Lake City is shown under construction in 2024.

View Salt Lake City on Transit Explorer

Hong Kong

In 1970, the only rail transit that Hong Kong had were a tramway on Hong Kong Island and the East Rail Line, which opened in 1910 and was electrified in 1983. Every decade since there was a new line or two on the Hong Kong MTR network, culminating in the ten lines you see in 2024.

View Hong Kong on Transit Explorer

São Paulo

In 1970, São Paulo’s metropolitan network, Metrô, didn’t exist, but it had six regional train lines operated by three railroads – these kinds of trains are shown in brown on Transit Explorer. The metro, shown in blue, began in 1974, and now has six lines (including one monorail line) while the regional train network was modified to five lines. São Paulo saw its first bus rapid transit (BRT) line added in 1988, but added four more BRT lines since then – just five of the over 900 bus routes operated by EMTU.

View São Paulo on Transit Explorer

Biking around Texel Island

Saturday, May 13, 2023, in the Netherlands on day 3 (day 12 of my trip).

Day 12

I had discussed with my friend that I wanted to go somewhere new and do something significant, likely distant from Rotterdam. I had long wanted to visit one of the Dutch islands that curves the country’s border in the North Sea from the area north of Amsterdam to Germany. The largest and easiest to visit one is Texel Island.

We left the house at around 8 AM to cycle to Rotterdam Centraal and ride the Intercity Direct train, with our bicycles, to Amsterdam Centraal station, where we changed to an Intercity train to Den Helder, a city at the tip of the Dutch mainland north of Amsterdam. The train arrived in Den Helder at 11 AM, where we picked up some snacks and cold sandwiches at Albert Heijn (the largest supermarket chain in the country), and rode over to the TESO ferry’s terminal.

Like many other ferries in the world, tickets are purchased only in one direction because of the assumption that you’re going to use the ferry to return (and Texel Island has no road crossings so a boat is the main way on and off). Another neat thing about this ferry is that pedestrians and bicycles are able to disembark and board simultaneously because outgoing bicycles are parked only on the right side of the boat and there is a one-way on and one-way off system for pedestrians and bicycles.

On the ferry

I wasn’t prepared to board this ferry. After we parked our bicycles in the designated area and went upstairs to the cabin I was floored at the cruise ship-like appearance. There was a self-service café, enormous bathrooms, a children’s play area, artificial trees, and a variety of seating options – single seats, seats with tables, couches to look out the side and couches to look out the front.

After inspecting the map of cycle routes on the island my friend and I decided to ride around the whole island clockwise. (An advantage of riding clockwise that day was to have a tailwind in the second half of the journey, when we would be tired.)

On the island

…we saw everything.

  • sheep
  • dunes
  • polders
  • Scottish Highlander cattle
  • forests
  • farms
  • tons and tons of e-bikes – I think that acoustic bikes were in the minority!
  • a lighthouse
  • beach cabanas
  • tulips
  • sea protection walls
  • passed through the towns of De Koog and De Cocksdorp

According to the tracking I did on Strava we rode 37.6 miles.

Heading home

On the return ferry my friend consulted the NS Travel Planner app to figure out the best itinerary of trains back to Rotterdam, as well as to figure out the time between the ferry’s arrival and the next train’s departure. It would be close, he said. We would need to exceed the Google Maps estimate of cycling time between the terminal and the station. And, he said, it’s likely that other people with bikes on this ferry also want to take the train and Dutch trains have a very small amount of space for bikes.

We cycled fast, and we made it onto the train about two minutes before departure. At Zaandam we changed to a Sprinter to Hoofddorp via Amsterdam Schiphol airport and at the airport station we changed to an (older) Intercity Direct train to Rotterdam. (The Intercity Direct train we took from Rotterdam in the morning was the new ICNG – next generation – set, and these trains have space for more bikes.)

How to map where I traveled when I went to Gorinchem, NL

On Monday, December 4, 2023, I wanted to ride a line in the Netherlands that I hadn’t yet, which is called the “MerwedeLingelijn” and goes between Dordrecht and Geldermalsen. In the NS journey planner database it’s called “Stoptrein” which distinguishes it from “Sprinter” and “Intercity”. Those names distinguish the service types on the Dutch railway network. (This particular Stoptrein is also a diesel-electric trainset.)

From Rotterdam, where I was staying, it would require at least one transfer to get to Gorinchem. But I wanted to stop in Utrecht to say hi to a friend during his work break – this meant there would be two transfers.

Here’s the itinerary I traveled on Monday

  • Rotterdam Centraal to Utrecht Centraal via Gouda, Intercity (half-hourly service) – 55 km
  • Utrecht Centraal to Geldermalsen, Sprinter (10-20 minute service) – 26 km
  • Geldermalsen to Gorinchem, Stoptrein (half-hourly service) – 27 km
  • [lunch and walk in Gorinchem, distance not recorded]
  • Gorinchem to Dordrecht, Stoptrein (quarter-hourly service) – 24 km
  • Dordrecht to Rotterdam, Waterbus (hourly service) – 21 km

How I drew the map

I wasn’t about to draw the routes by hand (although I did record the Waterbus ride on Strava as a “sail”) so I grabbed the data from OpenStreetMap.

If you want data in bulk from OpenStreetMap a common way to get it is from the HotOSM export tool. But I wanted specific transit routes, for which I could find the “way” IDs and export only those. For that I used Overpass Turbo and wrote the following query:

[out:json][timeout:25];
// gather results
rel(id:324888,13060594,5301520,2785504);
way(r);
// print results
out geom;

Notes

Frequencies refer to the pattern in the hour I used the service. The itinerary doesn’t include a Rotterdam Metro ride or the roundtrip bike ride from the Schiebroek neighborhood to Rotterdam Centraal).

Starting on December 10, the NS (Dutch national railway operator) is adding over 1,800 train services each week.

Traffic calming around Chicago schools and parks

Reducing the number and speed of automobiles near schools and parks is a proven way to reduce the number of traffic crashes involving children, part of a practice known as “traffic calming”. In Chicago a key way to do that has been to “cul-de-sac” (which I’m using as a verb) a street to prevent through traffic (reducing the number) and preventing speeding (reducing the speed).

My study of this was inspired by the above tweet, where the person is accurate when they say, “it works with any street”. Indeed: Full access to the school or park and to every property on the block is maintained, but drivers are not able to go through while pedestrians and bicyclists can (another practice called “modal filtering“).

My favorite example in Chicago is Hadiya Pendleton Park, at 4345 S Calumet Ave. This project created two mid-block cul-de-sacs and a park in the middle of a block, using vacant city-owned land on both sides. Creating new open space is a common corresponding outcome of the cul-de-sac application, which is what occurred at Funston Elementary School (see the before and after aerial photos below).

two black and white aerial photos taken of Funston Elementary School, one in 1998 showing a 4-way intersection of McLean Ave and Central Park Ave and one in 2003 showing a cul-de-sac on McLean Ave west of the school and landscaped area between the cul-de-sac and the three-way intersection of McLean and Central Park.

Through Twitter I solicited additional examples of where the city has created traffic calming near schools and parks using cul-de-sacs. Examples were submitted by RolandEmily (who mentioned Funston), Matt, Steven, and another tweeter.

Using OpenStreetMap, Overpass Query Language, and Overpass Turbo, we can find all of the schools and parks that are within a specified distance of a cul-de-sac. It turns out there are 153 schools and parks in Chicago that are within 150 feet of a cul-de-sac. (This considers only schools, parks, and cul-de-sacs, tagged as “turning circles”, currently mapped in OSM, and I have not verified each of the 153 instances.)

Map showing parks, schools, and adjacent cul-de-sacs, the results of the Overpass Turbo query.
Map showing parks, schools, and adjacent cul-de-sacs, the results of the Overpass Turbo query. An inset map shows a zoomed in portion of the map to illustrate the different types of features captured in the Overpass Turbo query (specifically it shows Graham Elementary School and McInerney Park).

The query below will find all of the cul-de-sacs (mapped as “turning circles” in OSM parlance) that are in Chicago, all of the schools and parks in Chicago, and then all of the two categories of features that are within 45 meters of each other. (Run the query and show the map, which will always grab the latest data.)

/*
example from OSM wiki: https://wiki.openstreetmap.org/wiki/Overpass_API/Overpass_API_by_Example
*/
[out:json][timeout:25];
// fetch area “Chicago” to search in
{{geocodeArea:Chicago}}->.searchArea;

// get cul-de-sacs
(
  node["highway"="turning_circle"](area.searchArea);
)->.turning_circles;

// get parks and schools
(
  way["amenity"="school"](area.searchArea);
  way["leisure"="park"](area.searchArea);
)->.schoolsParks;

// find parks and schools near cul-de-sacs
(
  way.schoolsParks(around.turning_circles:45);
)->.matchingSchoolsParks;

// find cul-de-sacs near parks and schools
(
  node.turning_circles(around.schoolsParks:45);
)->.matchingTurningCircles;

// output results to the map
(.matchingSchoolsParks; .matchingTurningCircles;);
out geom;

Read the three other blog posts I’ve written about using Overpass Turbo to quickly sift through and extract desired mapping data from OpenStreetMap.

England, days 5 and 6

Day 5 (Saturday)

  • Saturday, May 6, 2023, was Coronation day, and a day for me to sleep in.
  • A friend of a friend of a friend hosted a coronation watch party, where for nearly three hours I watched the live BBC broadcast of establishing Prince Charles as the King of the United Kingdom – because that’s still a thing democratic countries do. The party had great drinks, coronation chicken and coronation quiche, and dessert, accompanied by hilarious commentary from those assembled, myself included.
  • Note: The word “coronation” dominates the city right now. It’s in the window at every shop, at every train station, on flags hanging outside small hotels, and even on decorative arches over pedestrian streets.
  • My old friend and a new friend left the party and went on a long walk in Soho, first to Bar Termini for negronis. We then hit up the Liberty department store, where one of the Kingsman movies was filmed, ate dinner at Paradiso Burgers in Kingly Court, and had a nightcap at The White Horse.
  • I also picked up deluxe millionaire’s shortbread at M&S (a department store with a grocery department); I bake them using this caramel slice recipe; a key difference is that the recipe, created by an Aussie, calls for coconut in the shortbread base, which I follow and I love compared to the UK version.

Day 6 (Sunday)

  • This morning I moved from the hotel I was staying at near Euston Station to my friend’s friends’ flat in Covent Garden, and then another friend joined us (to keep the story straight, we are the same group of three friends traveling around London today as on Friday and Saturday). We grabbed coffee and pastries at Arôme Bakery and headed over to London Bridge station via Charing Cross station.
  • London Bridge station is connected to The Shard, a skinny glass pyramid hotel and office building. It’s also next to Borough Market where we went to get delicious spicy jam from Pimento Hill.
  • After visiting Pimento Hill we had jamon iberico sandwiches from Brindisa Spanish Foods and oysters and rosé from Wright Brothers Oyster & Porter House.
  • From there we took some combinations of trains to Shoreditch High Street station on the Overground network. Read more about Overground in “Transportation” below.
  • I attended the weekly, 30-minutes-long organ recital at St. Paul’s Cathedral. The organist was Peter Wright (he has his own Wikipedia page), who played “Prelude and Fugue in B minor (BWV 544)” by J.S. Bach, “Joie et clarté des corps glorieux from Les corps glorieux” by Olivier Messiaen, and “Dankpsalm (Op. 145, No 2)” by Max Reger.
  • The three of us ate a mixed platter at Ilili, a Lebanese restaurant. (There are two locations of a restaurant of the same name in NYC and D.C., but it seems they’re unaffiliated.)
  • The night ended at Eagle, a discotheque next door to the restaurant. But on the way home from Eagle I noticed a seriously tall and wide gap between South Western Railway trains and the platforms at both the Vauxhall and Waterloo stations.

Transportation

  • London Overground. The development story of this collection of new services is fascinating and provides some lessons for Chicago. Transport for London, or TfL, is a governmental authority under the control of the Greater London Authority, which has an elected mayor and council, the London Assembly. The first of six lines opened in 2007 and there are now 113 stations. Over 16 years TfL incrementally built a rapid transit network using existing active and disused main line railways. Chicago has many disused railways and many underused Metra lines; the idea there is to redesign a “regional rail” (RER, S-Bahn, etc.) network using existing and new lines – I wrote about this last year.
  • Southeastern, a private railway (one stop from Charing Cross station to London Bridge station (his National Rail service is inside the Oyster area so it counts and costs as much as an Underground trip in the same area)
  • South Western, a private railway (one stop from Vauxhall station to Waterloo station; see Oyster area explanation above)
  • Bus 8 (a route dictated by TfL and operated by Stagecoach London, a subsidiary of Stagecoach Group headquartered in Perth, Scotland)

Note about certain transit routes here

Many of them are run by contractors. Some bus routes are, kind of hilariously, operated by the national railway operators of Germany and the Netherlands. Arriva is owned by Deutsche Bahn (DB) and Abellio is owned by Nederlandse Spoorwegen (NS). Some other bus routes are operated by RATP, the Greater Paris transit operator owned by the Government of France.

The Elizabeth Line is operated by a subsidiary of MTR, the transit operator and real estate developer majority owned by the Government of Hong Kong.