• I’m heading to Chicago for Thanksgiving and for most of December and while the temperature may not be conducive to biking around the city, I wanted to check out some data Chicago makes available on their bike-share program, Divvy.

    It’s an extremely rich dataset. Although Chicago’s Open Data Portal only covers 2013-2019, there’s over 21 million records in the data, along with some spatial data and basic demographic data for Divvy subscribers. Luckily, the actual Divvy site has data from January 2020 all the way up through October 2023, so I’ll be able to continue some analysis and forecasting into the current day.

    Forecasting is something that I’m starting to practicing more of. I’ve done some basic forecasting/predictions for some Gaelic Football Inter-County games but that has been fairly simple – simply taking previous results and scores to create offensive/defensive rating scores and then running head-to-head comparisons through a simulation model. With more practice and data, I can start running more complex forecasting and prediction models on everything from GAA games to my Vision Zero data.

    With that being said, it’s time to dive into Divvy’s data!

    Unfortunately, the Divvy data doesn’t have a unique identifier for users of the system. This means that both subscribers and one-time customers will be counted as a unique rider every time they hop on a Divvy bike. That’s not ideal, but can still give us an idea of who’s using bike-share. The data also has the exact start and stop time a bike was checked out and returned, as well as the station where the ride started and the station where the ride ended.

    Subscriber’s of Divvy’s system made up 75% of all trips from 2013-2019. Of those subscriber riders, 74% were male and 26% were female. Those are some dedicated Divvy-riders and speaks to the viability of Divvy’s network and the ability to bike to different destinations throughout the Divvy network.

    We can also see the Divvy stations that have the most amount of rides started and ended from below.

    Station Name# Of Rides Started
    Streeter Dr & Grand Ave322,534
    Lake Shore Dr & Monroe St296,230
    Clinton St & Washington Blvd285,137
    Canal St & Adams St274760
    Theater on the Lake248,945
    Station Name# of Rides Ended
    Streeter Dr & Grand Ave365,462
    Clinton St & Washington Blvd280,744
    Lake Shore Dr & Monroe St273,965
    Theater on the Lake267,808
    Canal St & Adams264,702

    Both tables have the exact same stations, indicating that many riders start their rides from these locations but also many riders end their rides at these locations.

    Divvy riders definitely skew younger. The vast majority of riders are between the ages of 20 and 40, with most of those in the 25-30 year old grouping. Props to the not insignificant amount of Divvy riders over 60, though!

    Breaking member ridership down by gender shows that there’s not much change in the age of riders.

    Enough with some exploratory data analysis…let’s look at some trends!

    Divvy Ridership Trends

    I’m a bike person but I’m not the Lycra-clad kind of bike person. I’ll wear workout clothes when I ride my bike sometimes, sure. But what I’m most interested in is how biking can be an alternative to the car for getting around. This has me interested specifically in weekday trends of Divvy ridership and how prevalent ridership is during work-day commute times.

    While driving and public transit remain the largest transportation mode share in Chicago, the amount of people biking in the city has increased the last two decades. Chicago is pretty dense (much denser than San Antonio, for example), making the city generally conducive to both walking and biking. While there’s certainly more work to do in making biking safer, biking is a popular option for commuting if you’re able to do it.

    The chart below aggregates all weekday Divvy rides in the data, making no distinction between years. There’s two clear spikes in ridership – one right around 8:00 AM and one right around 5:00 PM. This indicates that a lot of people are using Divvy during prime work-time commuting hours. What’s also interesting is that there’s a lot more rides during the post-work peak in the afternoon than the pre-work peak in the morning. Maybe some people who took the train or bus to work in the morning are opting for a Divvy ride in the afternoon. Or they’re taking Divvy to a “third spot” for drinks with co-workers before heading home.

    Weekday ridership trends during the “Pandemic Era” show the same work commuting pattern as the pre-Covid chart, but ridership starts to tick upwards beginning in 2020. More people were likely looking for socially distant ways to hang out with friends or break up the monotony of working from home by getting out on a Divvy bike.

    If we step back and look at yearly ridership aggregate totals, there’s an encouraging upward trend from Divvy’s start in 2013 through 2019, nearly hitting 4 million rides in 2017. There’s a slight drop in 2018 before a rebound in 2019. There’s another slight dip in 2020 but ridership absolutely explodes beginning in 2021, increasing by 58%. There’s even more riders in 2022. It remains to be seen if 2023 ridership can match ’21 or ’22 levels, but Divvy usage is still much higher than pre-pandemic levels. It’s clearly a popular option for getting around Chicago.

    The heatmap below shows daily Divvy rides for 2021, when the system saw its huge jump in ridership. The darker the red means that more Divvy bikes were used on those days where the red is a lighter color. Each day of each individual month is evaluated against each other, so a dark red square in January doesn’t mean that ridership was at the same level as a dark red square in July.

    January 2021 saw some pretty high ridership and if you’ve ever been in Chicago during January, you know that the weather doesn’t mess around. Ridership fell off in February, which is typically the worst winter month in Chicago, but many of the days still saw a few thousand rides. Ridership really took off in the summer months. June, July, and August all saw multiple days over 35,000 Divvy rides and September 2021 had 4 days over 30,000 rides.

    Where are riders going?

    We know that Divvy ridership has exploded since 2020 and has been on a steady upward trend since the program began in 2013. But where are all these riders going? Let’s take a look at the most popular station-to-station routes and examine how far Divvy users are typically riding.

    The most popular Divvy route in the data is the Lake Shore Dr & Monroe St to Streeter Dr & Grand Ave. Streeter Dr & Grand Ave station shows up several times in the top 10 as a starting point for Divvy trips.

    Many of these routes are along Lake Michigan, where the Lakefront Trail hugs the water. It’s a beautiful route, following Lake Michigan going as far north as Loyola University and further south through the Museum campus and Soldier Field. I highly recommend grabbing a Divvy and riding along the Lakefront if you’re in Chicago during the warm summer months.

    Forecasting Divvy Ridership

    Ok, we know that Divvy is popular and a lot of people use the bike-share system in Chicago. Let’s see what forecasting can tell us about the next 12 months or so of Divvy ridership.

    I’m going to forecast from November 2023 through September 2024, so almost a full year of ridership. Then I can come back and re-visit my forecast at the beginning of December and evaluate my November 2023 forecast.

    Using a SARIMA (Seasonal Autoregressive Integrated Moving Average) model, I’m going to do an in-sample prediction to start and then see what the forecast says about the next 12 months. An in-sample prediction is testing the model against data that’s already been recording, essentially testing how well the model is predicting known outcomes.

    I chose to use a SARIMA model because it takes into account the seasonality of the data. Divvy rides are going to be affected by the weather. Not as many people will want or choose to ride a bike during January in Chicago as will hop on the bike during May or June. This means that the weather and the time of year will have a major impact on ridership.

    The model is pretty close to the historical data. It over-predicts ridership in the first few years of Divvy being on the streets before coming very close in 2017 and 2018. Actual ridership over-performed the predicted amount in the summer of 2019 and 2020, but the model over-predicted the last 3 summers.

    If we look at what the model is forecasting for the next 12 months, we can see that the model expects the same season trend to occur. Divvy rides are already decreasing as the weather gets colder and then will start to climb once spring rolls around and the weather warms up. The forecast calls for ridership to peak in July 2024 before slowing down again.

    What It All Means…

    Bike-share is strong in Chicago and shows no signs of slowing down (except in winter). Ridership has increased since Divvy’s inception, despite a small downturn this summer from the previous highs of 2021 and 2022. As the system continues to expand and add more stations throughout all 50 wards of Chicago, I expect more and more people will continue to use Divvy. Combined with a concerted effort to create a safe bicycle network, Chicago is on-track to become a world-class bicycling city.

    Now, please no more NASCAR in downtown Chicago!

    Where to Find the Data and Analysis:

    If you want to download the data for yourself and check out the code I used to perform the analysis, take a look around my GitHub and Chicago’s Open Data Portal and the Divvy site. Feel free to ask any questions or leave any comments or ideas for future projects!

  • I was recently in Europe and brought my camera along. Here’s some of what I shot…

    Bike Planter, Bayeux, France
    Lonely bike, Barcelona, Spain
    Reading and drinking, Barcelona, Spain
    Portrait, Barcelona, Spain
    Perpignan train station, Perpignan, France
    Bayeux canal, Bayeux, France
    Mont St. Michel
    Alleyway, Paris, France
    Cafe friends, Paris, France
  • My crash map for San Antonio is now updated with TxDOT’s latest October 2023 data and it was not a good month for pedestrians and bicyclists.

    44 people (pedestrians and cyclists) were involved in some sort of vehicular incident in October. Unfortunately, 4 pedestrians and 1 bicyclists were killed last month and another 6 pedestrians were seriously injured, making October San Antonio’s second deadliest month this year (5 pedestrians were killed in January 2023).

    According to TxDOT’s data for San Antonio, 23 pedestrians have been killed so far in 2023. That’s 5 fewer than 2022 and 2 fewer than in 2021. There has been a very slight decrease in pedestrian deaths the last 5 years, but it doesn’t appear that the trend is due to any sort of increase in pedestrian safety measures by the City of San Antonio.

    They city’s Transportation Department site shows that the last Vision Zero project was completed in 2019. At least 5 more are planned or in the beginning stages of planning. The projects that have been completed don’t look very effective, either. Placing a few flashing lights over a 6 lane road (35-45mph speed limit) with a pedestrian island in the middle doesn’t make me confident that I’ll make it to the other side unscathed.

    In fact, a new study found that more Americans are walking less but pedestrian deaths are increasing. It’s worth a read-through, but remote work has played a large role in the trend in addition to other factors like dangerous street design and lack of adequate pedestrian facilities (aka sidewalks) that decrease access to destinations.

    San Antonio has a long way to go, but if you’re interested in seeing what’s in the works and how you can help check ActivateSA and the Complete Streets Coalition. This coalition is working to re-make San Antonio’s transportation system so that it accommodates all users – drivers, walkers, cyclists, and public transit fans. It’s a great group doing very important work for the city.

    A minor house-keeping note

    I’ve never done this before, but I set up a Buy Me a Coffee account. This is mainly to help offset some of the server costs associated with running my crash dashboard. If you enjoy the dashboard and want to show some support, consider pitching in a buck or two. I’m excited about the reception the dashboard has gotten so far and I have a fairly extensive backlog of improvements I’ll be adding in over the next couple of weeks to make it even better!

    Check out the data here.

  • I’m in the middle of making some significant updates to the San Antonio crash map (which will hopefully be ready by the beginning of December, but definitely for the start of 2024), but I wanted to take a quick look at some new residential construction permits issued in San Antonio.

    Like many other cities throughout the country, San Antonio is experiencing housing availability shortfalls. Bexar County and San Antonio itself has seen significant population growth over the last decade. With more people moving to the area to take advantage of decent weather and a low-cost of living, finding a place to call home has become more difficult for everyone.

    To build almost anything, you’ll need to get a permit in San Antonio. There’s all sorts of permits in San Antonio – Garage Sale permits, Accessory Dwelling Unit permits, Demolition Permits…the list goes on and on. There’s been over 260,000 permits issued in San Antonio from July 2020 through October 2023, of which “Mechanical”, “Electrical General” and “Plumbing General” make up a combined 32% of issued permits. New residential construction permits make up 5.5% (14,663) of all permits issued over the last 3+ years.

    The data set also includes other information such as the square footage of the new construction, the City Council District, primary contact, and location. Of all new construction permits issued, the average square footage is 4,474 square feet (pretty big!) and the median square footage is 2,211 square feet (still pretty big!).

    Breaking the permits down by Council District shows that districts 2, 3, 4, and 8 have seen the most number of approved permits for new residential construction. Median square footage is fairly close for all districts, though CD9 is the only district where the median area is over 3,000.

    When looking at average square footage, it’s clear there’s something pretty massive being built out in District 8. Looking at the data, a company called Fulton Construction Services appears to be building a pretty large housing community out in D8. They specialize in “transforming the housing landscape with the development of their unique low-density ‘Birdsong’ cottage communities”. This D8 construction skews their average square footage value very high, but the median square footage of new construction in D8 is much more in line with the other city council districts.

    Lennar Homes has received 22% of all pemits issued the last 3 years, with an average of 28 days between permit submission and approval. Perusing their website, this looks like another company that specializes in single-family homes outside of San Antonio’s center core. They’re also having a blow-out sale on some of their move-in ready homes, so if you’re looking for a home with an attached garage that’s larger than your kitchen, Lennar Homes is the way to go.

    For the most part, the amount of permits issued has strong variety throughout each of the years in the data (December 2020 only had 205 permits issued). Permit issuance declines as 2021 and 2022 progresses, but permits issued so far in 2023 have remained fairly steady.

    Below is a map with a sample of new residential construction permits issued over the last 3+ years. They’re generally spread throughout the city, with some new permits issued close to downtown. The majority of new permits, however, are right on the edges of Loop 410 or outside of Loop 1604.

    This is indicative of San Antonio’s continued sprawling development. Larger homes are being constructed further away from the city center, which will only exacerbate San Antonio’s car-oriented nature. While these homes are likely going to be cheaper than older homes closer to downtown, this type of sprawl comes with its own costs. People will spend more time in their car, cause more congestion and pollution, and generally spend more disposable income on their transportation and housing options.

    Because San Antonio lacks an efficient public transportation network, driving a car will likely be the only option available to new residents living outside of San Antonio’s loop-highway system. At least there’s some newer construction happening close to downtown, but there should be a more concerted effort to build denser housing there.

  • It may not exactly feel like it in San Antonio, but summer is over. At least it should be. Cooler temperatures have finally arrived with some consistency, which means I now have to put on a light hoodie for my early morning walk with my dogs. Cooler weather has got me thinking more about summer impacts on pedestrians and cyclists here in town, so let’s take a look.

    I’m identifying the “summer months” as May-August, which is roughly a summer break for students. I’m also looking at the 3 years pre-pandemic and the 3 years “post”-pandemic. I know that technically the pandemic ended earlier this year but at some point in 2021 it felt like things were back to something similar to the pre-2020 years, at least in Texas.

    Here’s the key takeaway: The rate of pedestrian and cyclist incidents dipped by a notable 14% in the post-pandemic summers. Digging deeper, this decrease is attributed mainly to the drop in “possible injury” incidents. From 2017-2019, 185 individuals were potentially injured in crashes, in contrast to a mere 52 from 2021-2022, and a more reduced 29 in the summer of 2023.

    Summer-time fatalities have decreased 12% compared to pre-pandemic deaths. Percentage differences are nice, but we’re still only talking about 4 fewer people killed from 2021-2023 and 2017-2019.

    It’s definitely an unmitigated good that fewer pedestrians and cyclists are being killed on San Antonio’s streets. What’s not clear is why that is happening. I’m confident in stating that it’s not necessarily because San Antonio’s leaders have made Vision Zero a key policy implementation – if anything, it’s been largely forgotten since the Vision Zero Action Plan was created in 2016. There have been some “improvements” but none completed since 2019 and the ones that have been completed don’t look all that safe for anyone to me.

    Another reason for the decrease in fatalities is that people are just walking and biking less. If people don’t feel safe going for a walk or trying to ride their bike, then they’re not going to do it. With cars continuing to remain the dominant form of personal transport here in San Antonio, biking and walking here will continue to be unsafe and lead to more and more people opting out of efficient and healthy ways to get around the city.

    For access to the data, go here.

  • In my last post, I looked at overall ridership trends for VIA Metropolitan Transit and how they’ve changed over the last two decades. VIA ridership took major hits during the Great Recession of 2008-09 and the COVID-19 pandemic, and ridership hasn’t recovered despite an increasing population. I detailed some of the factors that could be depressing ridership of VIA (development patterns, funding) but in this analysis I’m going to look “under the hood”, so to speak, at VIA’s General Transit Feed Specification (GTFS) data.

    GTFS is a common format for public transit schedules and geographic information. Public transit agencies publish their transit data in a series of text files which model a specific aspect of transit information – stops, routes, trips and other schedule data. This data can be used to create trip planners, publish time tables, and create performance dashboards, something many transit agencies make publicly available.

    Using VIA’s GTFS data, I can get a better understanding of how the system actually operates and how effective it is at moving San Antonians from Point A to Point B. Let’s define two important terms, first.

    The first is headway: this is defined as the time interval between two consecutive vehicles passing a particular point (i.e. a bus stop) on a specific route. Shorter headways means more frequent service. A 10-minute headway implies that, on average, a passenger would have to wait only about 10 minutes for the next us if they arrived at the stop at some random time.

    Next, is frequency: frequency is the number of vehicles (in this case, buses) that pass a specific point (a bus stop) on a route within a given time period. Higher frequencies mean that more vehicles are passing a bus stop within a certain time frame. For example, if VIA operates with 15-minute headways (do they?), then the frequency is 4 buses per hour.

    VIA publishes their GTFS data here, so let’s dive in!

    Let’s start by calculating some headways for VIA. I’m going to be using the tidytransit R package to analyze VIA’s GTFS data, starting with stop frequencies between 6:00am and 10:00am on weekdays. This particular time window was chosen as it’s a likely commuting time for people using VIA to get to work.

    The bus with the shortest headways between 6:00am and 10:00am is the Prímo Zarzamora (bus route 103), which runs every 12 minutes. The 103 runs North-South along Zarzamora St and connects the Madla Transit Center and Crossroads Park & Ride. The next fastest routes are VIA’s other two Prímo routes, the 100 and 102. Although slightly less frequent, those buses run every 15 minutes. These Prímo buses are sort of a Bus Rapid Transit-lite network mainly because there’s fewer stops on the routes and the buses get transit signal priority over cars.

    All of the Prímo routes are in the top 5 for ridership, and have experienced an increase in passenger trips when comparing June 2022 and June 2023. 12-15 minute headways for these Prímo buses is good, and certainly contribute to higher ridership numbers. But these are only 3 routes out of the entire VIA system. What are headways like for the 552, 20, and other routes with less ridership?

    Between 6:00am and 6:00pm, the 552 Loop 410/WW White Skip averages headways just over 15 minute headways, comparable to the Prímo routes. Looking at the route map below, I would classify this bus as another kind of “express” bus. It travels almost the entirety of Loop 410 and connects to several other VIA transit centers. It would take nearly 2 hours to ride this route from end-to-end.

    The 20 New Braunfels (Frequent) route also has average headways of 15 minutes. This route goes from Brooks City Base on the south side before cutting west to link up at VIA’s Centro Plaza transit hub downtown.

    So the other 2 routes in VIA’s system that have the highest ridership also average 15 minute headways. Prímo’s only advantage then is signal priority, as I don’t consider fewer stops to necessarily be an advantage.

    The other three routes I want to look at are ones that I’ve personally used – the 2 (Blanco Frequent), 3 (San Pedro Skip), and 4 (San Pedro Frequent). Here’s where we can start to see headway issues within VIA’s system. The average headway for the Blanco Frequent (Route 2) is 29 minutes over the course of 12 hours during a weekday. To put it bluntly, that is not good. Remember the definition of headway above – the average time I would have to wait for the 2 bus if I showed up to that bus stop at some random time is nearly 30 minutes. The San Pedro Skip (Route 3) and San Pedro Frequent (Route 4) are marginally better, but all three routes have headways that are longer than what it would take me to drive to most destinations I’m trying to get to.

    Granted, those headways are for a 12-hour period. If we only look at average headways for morning and evening commuting times, there’s little change. In fact, both the 2 and 3 routes are a couple minutes worse during those times. On average, a prospective rider of the the Blanco Frequent, San Pedro Skip, or San Pedro Frequent would need to wait 20-30 minutes for one of those buses to arrive.

    Because of the extensive freeway and stroad system in San Antonio, anyone with access to a car can likely get to wherever they want within 20-30 minutes. Even if a household is spending most of their income on rent and transportation-related costs, driving 20-30 minutes to the store is much more attractive than potentially waiting 20-30 minutes for a bus to show up, ride the bus to the store, do their shopping and then endure another 20-30 minute wait for the ride home.

    What might be the most frustrating thing about these headways on the 2, 3, and 4 routes is how they change as a bus drives along the route. The 2 bus starts at its southern-most point around 20 minute headways. About the final third of the 2 route is right around 40-50 minute headways. The San Pedro Skip route (middle graph) has varied headways throughout the whole route while the San Pedro Frequent route has a similar headway distribution as the 2 – starts “fast” but gets slower. I think VIA should remove “Frequent” from the names of these bus routes.

    There’s plenty more routes in VIA’s network than the Prímo routes and the 2, 3, and 4 routes. Judging by the average headways of routes that VIA classifies as “frequent”, however, I’m willing to go out on a limb and say that the rest of the bus network is likely as slow or slower than these routes. Keep in mind, too, that the 2, 3, and 4 routes all traverse through San Antonio’s downtown, one of the denser areas and an area that should have better bus service.

    If you want to see how high (or not, depending on your point of view) VIA is aiming when it comes to improvements to their bus network’s service, check out their Keep SA Moving plan. Their first stated goal is that all routes will have frequencies/headways of 30 minutes or better during weekday peak times. This means that there are VIA routes where the headways must be significantly worse than 30 minutes if an average wait time for a rider is going to be reduced a half hour. At some unspecified date in the future, VIA wants to have 15% of routes at 10-12 minute headways, a significant improvement to be sure. Take a look at the pie charts from their plan below – I’m not colorblind but it sure is hard for me to differentiate between the red palettes they’re using. I’ll be generous and go on the assumption that in the future (TBD), VIA wants to get to a point where 85% of their routes have headways between 15-30 minutes. I guess that’s better than 90% of routes having headways that long. Way to shoot for the moon, VIA.

    Some might ask why bus riders don’t just look up the bus schedule before going to their stop? While it’s a valid question, I don’t think constantly checking a bus schedule is convenient for users. First, not every bus rider may have a smart phone and even if they did, the app riders need to use to check the status of their bus can be confusing to decipher. Second, I believe that the mark of an effective transit system is one which checking a bus schedule isn’t necessary. If you’re transferring between buses and routes then absolutely check the schedule. But, ideally, you should be able to show up at your stop and have the confidence that the bus will arrive within 10-12 minutes of you getting there.

    San Antonio residents absolutely deserve better public transit. I know the pandemic really hit public transit agencies hard (see my last post for just how hard a hit VIA took). But as San Antonio continues to grow, changes in development patterns that encourage alternative modes of transportation need to be implemented. San Antonio was one of the cities that joined the Paris Climate agreement after Trump pulled the U.S. out of it. San Antonio’s own Climate Action & Adaptation Plan (CAAP) states that 38% of emissions came from the transportation sector (34% from private transportation). There’s plenty of strategies mentioned in the CAAP for reducing transportation emissions, such as enabling mobility as a service using “big data solutions”, but like so many other plans San Antonio has created there’s little said about how the city actually plans to implement these strategies.

    Using phrases like “smart city” and “big data solutions” sounds all technocratic and cool, but unless San Antonio can actually deliver on this 7 year old plan (and the delivery of any such strategies will need to happen fast if we don’t want another summer of 80+ days over 100 degrees), residents will continue to be saddled with an inadequate public transit system and few other mobility options other than using their personal vehicles.

  • I grew up consistently using public transportation, but as I’ve gotten older and lived in less transit-rich parts of the country, I’ve found myself resistant to hopping on the bus in San Antonio to get somewhere I want to go. Some of this resistance is that taking the bus to a destination like the office where I work would take approximately 1 hour and 10 minutes, while driving would take 15 minutes. Another reason is sheer laziness – taking the bus to a restaurant may take 20-25 minutes but driving will “only” take 10-15 minutes. A third aspect working against transit’s favor is its ease of use – I don’t feel confident that I can walk to one of several bus tops within 5 minutes of my house and only have to wait a few minutes before the bus I want shows up.

    I’m aware that the above very much sounds like “woe-is-me” complaining. I have options (privilege, actually) – I could drive my car, take the bus, ride my bike to a closer restaurant, or (and this the healthier and bigger money saver option) I could just eat at home. I have the luxury of choosing to ride the bus. I don’t have to, like so many other people who take the bus to work, to shop, to visit friends and family, to get to doctor appointments, or to many other places.

    Here’s the part that gets me every time – when I take the bus, I’m really glad I did. I didn’t have to drive around looking for parking, I wasn’t worried about other maniacs on the road, and I could zone out or read on the bus.

    VIA Metropolitan Transit, San Antonio’s public transportation provider, has always had to battle for funding. Only in 2020 did San Antonio voters approve a 1/8 cent sales tax to give VIA more funding, although it won’t go into effect until 2026. VIA also receives the least amount of sales tax dollars that other transit agencies in Texas cities receive, such as Austin, Houston and Dallas, which receive a full 1 cent of available sales tax. With increased funding starting in the next 3 years, VIA should be able to increase route frequencies, make capital improvements, and enhance ridership experience.

    A big project will be VIA’s Advanced Rapid Transit (ART) North-South bus route, going from the airport to Southtown. I’m not sure exactly what’s “advanced” about it since it’s really just a bus-rapid transit line, with dedicated lanes and level all-door boarding, which is fairly common throughout the rest of the world. Although the North-South line is scheduled to be completed first, VIA also has plans to complete an East-West route, which could be completed faster than originally anticipated if VIA gets more funding.

    I’m definitely looking forward to getting more mass-transit capacity in San Antonio, though I do have questions about what exactly VIA wants to get out of these ART routes. As I gather more data and do some more research, I’ll come back with another post on that.

    For now, I just want to take a simple look at VIA’s ridership over the last 20 or so years. To get ridership data, I used the National Transit Database, which contains tons of data on public transit agencies all across the country. I’m using a complete monthly ridership time series dataset, which contains all unlinked passenger trips (UPT) per month. The American Public Transportation Association defines UPTs as the number of passengers who board public transit vehicles regardless of how many vehicles they use to travel from their origin to their destination. So if I take the bus from my house to my favorite ramen restaurant, and I take two buses because I have to transfer, that counts as two trips.

    The graph below shows VIA’s monthly UPTs from January 2002 through June 2023. UPTs peaked after 2008, around the Great Recession, before falling off again as the recession worsened. Ridership steadily climbed upwards around 2010-2011, but never reached pre-2009 levels. Since 2012, UPTs have generally declined before the precipitous drop-off in ridership at the onset of the pandemic. Although ridership is starting to increase, there’s still a long way to go before VIA reaches ridership levels seen over a decade ago.

    Breaking out VIA’s monthly UPTs by year shows that there have always been some ups and downs throughout the year. Ridership looks to fall somewhat in the summer months from 2002 to 2007 before increasing in the early fall before dropping again, but in 2008 there’s a definite upward trend all year until right around October, when ridership dipped to its lowest point. Ridership remains steady in 2009 until a drop, again around the last quarter of the calendar year. We see similar ups and downs throughout the 2010s, though overall UPTs are generally lower than in the decade before. VIA’s ridership remains mostly between 3-4 million UPTs until the pandemic hits in March 2020. Since then, UPTs have remained relatively flat at around 2 million trips.

    To get a more normalized view of VIA ridership in relation to San Antonio’s population growth, I calculated UPTs per capita, or per person, annually. To get population data, I used the 2000 decennial census and applied that to years 2002-2008. From 2009-2020, I used the ACS 5-Year Survey population data. It’s not a perfect way to do it, since I’m applying one decennial census’ population value across an 8 year period, but I think it will still show a clear picture of VIA’s ridership in relation to population.

    The graph below shows VIA’s yearly UPTs per capita from 2002-2019 and the San Antonio-New Braunfels MSA population estimates from the census (I used the decennial census for 2002-2008 and the ACS 5-Year estimate for the remaining years). 1 Since the population estimates come from the SA-NB MSA, the population shown below is more than the total number of people in San Antonio proper. UPTs per capita increased steadily from 2002 through 2008, when we see a drop in ridership during the Great Recession. Rides per person peaked at 4.5 in 2008. Still, it shows a sharp decline in yearly UPTs per capita from 2008 onward despite steadily increasing population. VIA never seems to have fully recovered from the Great Recession back in 2008-09, which does not bode well for VIA’s potential recovery from the pandemic.

    I’m not too familiar with the history of VIA, so I’m unsure about how many new routes or how much new capacity was added from 2002 onwards. Adding new routes could potentially increase ridership, as well as improving the frequency of a route (how long between each bus arrives at a stop). The drop-offs in ridership near the end of the year are interesting, though, and I’m not quite sure what to make of them.

    I suspect, however, that a major factor effecting VIA’s ridership is population growth. San Antonio is growing rapidly, with nearly 20,000 people between July 2021 and July 2022. All these new residents need places to live and places to work. Lots of new developments are springing up outside of Loops 410 & 1604, many of them single-family homes or large apartment complexes. The median home price of new housing construction in San Antonio the last several years is close to $300,000. New homes that are built outside of Loops 410 and 1604 may not be serviced as well by VIA as are homes that are within Loop 410 and close to the downtown core. Additionally, San Antonio’s downtown vacancy rate of commercial and office real estate is nearly 40%, and many large employers, such as banking giant USAA, have left their downtown offices in favor of consolidated large campuses outside of Loop 410. This likely forces workers to look for residences outside of San Antonio’s freeway loops, where homes may generally be cheaper.

    Almost every census tract within San Antonio has experienced some amount of population growth. Except for a small census tract right in the middle of San Antonio, much of San Antonio’s population growth is occurring outside of the city center. Some of these population estimates may not be 100% accurate due to changing tract boundaries or the addition of new ones, but it’s clear that tracts far outside of the core city center are increasing at a faster rate than tracts closer to downtown. Much of San Antonio is zoned for single-family housing and building these types of dwellings is easier to do at the edges of the city, where land is more available and fairly cheap.

    Besides a growing population, there are other factors that are likely effecting VIA’s ridership. Important factors like route frequency, route speed, and connections all play a role in how VIA is utilized. I’m going to spend some time in the coming months diving into VIA’s Google Transit Feed Specification (GTFS) data, which will allow me to map VIA’s routes through San Antonio and examine route frequency and speed in more detail. With GTFS data, I should be able to exactly see where VIA is most efficient and where VIA’s service could use improvement. But in a city of 1.7 million people and counting, the lack of viable and frequent public transit will continue to cause headaches for residents trying to get around the city.

  • My San Antonio pedestrian/cyclist dashboard is now updated with July’s crash data, so now is a good time to take a look at how pedestrians and cyclists fared on San Antonio streets last month.

    16 bicyclists were involved in crashes during July, with 1 serious injury, 11 minor injuries, and 4 suffering a possible injury. Fortunately, no bicyclists were killed in July.

    Unfortunately, the same cannot be said of people trying to walk in San Antonio. July saw 2 pedestrian fatalities, both of which occurred at intersections. One of the deaths occurred at North Main and Park Avenue, near San Antonio College, and the other happened at North Zarzamora St. and Laurel St.

    3 fortunate pedestrians were not injured in their encounters with cars, but 3 others suffered serious injuries, 12 suffered minor injuries, and 6 came away with possible injuries.

    Of the 42 vehicle crashes involving a pedestrian or a cyclist, half occurred at intersections. Unfortunately, vehicular data was not available in July’s data pull, but I will check in a couple weeks when August’s data becomes available.

    If you’d like to explore the data for yourself, it’s available on my Github page!

  • Disclaimer: I used to work for the City of San Antonio (COSA) as an analyst in the Department of Human Services Homeless Division. This post is not going to be about homelessness, but about an email that I would see land in my inbox nearly everyday during the summer months: Ozone Action Day!!!

    Ozone Action Days were days when the amount of ground-level ozone was hazardous for everyone’s health, not just for people with respiratory issues. The email provided tips on how to reduce your impact on the environment and not contribute to ground-level ozone accumulation – don’t idle your car, take public transit or walk to work, etc, etc. I’m not sure how many of these emails I saw and I wish I kept track, but anecdotally I’d guess that 55-60% of days between May and October were classified as Ozone Action Days.

    It’s been another scorching summer here in San Antonio and as I was walking my dog this morning I thought about the City Health Dashboard site for some reason. I used this site for some school assignments a few years ago, specifically to examine relationships between public health outcomes in Baltimore. Walking in the 7:00am humidity and heat got me thinking about checking out some of the data available on the site for San Antonio.

    As someone who believes that public transit, walking, and biking are often the best & most sustainable ways of getting around a city, the negative environmental and health externalities of car-centric planning and culture are often in my thoughts. Tailpipe emissions create a variety of noxious elements, including the above-mentioned ground-level ozone (smog) and particulate matter. Both of these harmful emissions products are known to aggravate asthma, cause bronchial and respiratory problems, and contribute to premature death. High temperatures exacerbate the problems caused by tailpipe emissions by keeping particulate matter and other emissions closer to ground-level. Additionally, the heat generated by cars during operation create higher temperatures in the surrounding area, contributing to an “urban heat island” effect. Tack on homes’ air conditioners having to work much harder to cool a space, and more hot air is being pumped into the atmosphere.

    Causes of urban heat islands and pollution are so intertwined and interconnected that books have been written about them, and you (and me) should read them. That’s outside the scope of this post, which makes what I want to do relatively simple. Using data from City Health Dashboard and the 2019 ACS 5-Year Survey, I want to look at average air pollution levels in San Antonio’s 5 poorest and 5 wealthiest census tracts. From there, I can examine other health outcomes in these specific tracts of San Antonio before moving on to the whole of the city. I’m pretty confident in what I’ll find – air pollution is higher in the poorest census tracts of San Antonio than in the wealthier ones, and poor census tracts will also have worse health outcomes. Even if the results are what I expect, I think it’s still valuable to visually compare these metrics and remind ourselves that there’s still a ton of work to be done to create an equitable and healthy city for all residents.

    Ozone & Particulate Matter Pollution in San Antonio’s 5 Poorest & Wealthiest Census Tracts

    The air pollution data comes from City Health Dashboard and was collected by George Mason University (GMU) using North America Chemical Reanalysis (NARC) – you can read more about the process in the codebook! The data provides monthly average measurements for ozone (ppb) and particulate matter (PM2.5) for 2022 by census tract. Using data from the Census Bureau’s 2019 5-Year Survey, I was able to combine the data to create a single dataset that provides a census tract’s ozone and PM2.5 measurement as well as the tracts’ median household income. From there, I whittled the data down to the 5 wealthiest and poorest tracts by household income.

    Below is a table showing the 5 poorest and 5 wealthiest census tracts in San Antonio and their respective median household incomes, along with which zip code each tract is part of. The 78207 zip code makes up most of San Antonio’s West Side, a part of the city historically neglected, marginalized, and segregated from wealthier areas.1 78212, which is just north of downtown San Antonio, contains two census tracts on either ends of the wealth spectrum – 110700 and 190800.

    Census TractPart of Zip Code:Median Household Income
    11050078207$10,463
    11060078207$15,250
    11070078212$18,256
    15080078214$16,994
    16050178207$18,915
    19080078212$148,750
    19141278248$183,529
    19150478231$215,083
    19150578230$147,750
    19180678258$145,579

    Below is a map with the above census tracts highlighted over a map of San Antonio (you may need to open it in another window depending on your browser)2. The three census tracts with 78207 are blocks from the downtown district but physically separated by the convergence of two freeways – IH-10 and IH-35. Census tract 110700, part of zip code 78212, is wedged into the southwest corner of the confluence of IH-10 and IH-35. This is a topic for another post, but the built environment, especially the freeway system, of San Antonio and cities across the country can serve as a stout bulwark separating poor areas from wealthier ones.

    To graph out the average monthly particulate matter pollution in each of these ten census tracts, I grouped them into “Lowest” and “Highest” Income categories. Throughout every month of 2022, PM2.5 pollution was higher in the poorest areas of San Antonio than in the wealthier areas. While PM2.5 pollution averages actually increased in poorer tracts from February to June, wealthier tracts saw a slight increase followed by PM2.5 pollution improvement over the same period. Although average PM2.5 levels decreased across the city from June to August 2022, PM2.5 pollution still remained higher in poorer census tracts.

    Interestingly, ozone levels are typically higher in wealthier income tracts than lower tracts in San Antonio with ozone levels in these tracts mirroring each other throughout the year. Ozone is not emitted directly by tailpipe emissions, making it a secondary pollutant. There could be a variety of factors affecting ozone levels in San Antonio’s wealthier areas, including proximity to high-traffic roadways, such as arterial roads or freeways (though I believe this explanation is unlikely, San Antonio’s extensive freeway system could negate any kind of mitigation methods wealthier neighborhoods employ), or industrial nodes with high emissions. Another potential explanation is that the way GMU collected ozone data from NARC is flawed or that there are more sensors in wealthier areas than in lower-income parts of San Antonio.

    Pollution Levels Across Income in San Antonio

    We’ve seen how pollution levels vary in the poorest and wealthiest areas of San Antonio. If median income levels are grouped into $30,000 buckets, do we see any difference in pollution levels?

    Not really. Census tracts with median household incomes below $60,000 still experience higher PM2.5 pollution than wealthier census tracts throughout 2022. Census tracts with incomes higher than $60,000 still see some high levels of PM2.5 pollution but not nearly at levels experienced by low-income areas of San Antonio. The one outlier in the heatmap below is April 2022, when nearly every census tract experienced high levels of PM2.5 pollution. For the $120-$150K income range, that was the highest PM2.5 levels of the year.

    Ozone across the city spreads relatively equally across all income tracts. In fact, we can see slightly higher ozone levels in higher income groups during the summer months than in lower income areas. The winter months of November-January see relatively low levels of ozone.

    Other Health Outcomes Across San Antonio’s & Bexar County’s Census Tracts

    Using the CDC’s PLACES dataset, we can explore other public health variables in San Antonio & Bexar County. The PLACES dataset contains model-based estimates for a variety of public health outcomes at the census tract level. Joining this data to our City Health Dashboard and Census data by census tract allows to more closely examine some public health variables and their relationship to median income levels throughout the city.

    As differences in particulate matter between the 5 wealthiest and 5 poorest census tract were fairly significant, I’m interested in seeing the relationship in other census tracts between particulate matter levels and some other public health outcomes.

    Census tracts with median income in the lowest quartile (0-25%) of San Antonio consistently have higher rates of asthma than wealthier census tracts, even when there’s less particulate matter pollution. The same can be seen in high blood pressure rates in San Antonio census tracts. Poorer census tracts have consistently higher rates of residents with high blood pressure than wealthier tracts.

    If we only look at public health variables, the health inequality in San Antonio is even starker. There’s a clear positive relationship between diabetes rates and obesity rates in San Antonio’s poor areas. While even some of the richest areas of San Antonio have high obesity rates, none are over 50%. While not as starkly positive a relationship as obesity and diabetes, there’s still a positive relationship in San Antonio between high blood pressure rates and obesity. Again, however, census tracts in the lower quartile experience the worst obesity and high blood pressure rates. Depressingly, coronary heart disease and high blood pressure show a similar positive relationship between them when compared across income groups.

    It’s clear that there are massive health disparities in San Antonio when comparing across income groups and I haven’t even gotten into other demographic information, like race, ethnicity or gender, that likely create an even more distressing picture. There’s plenty of reasons why San Antonio’s population looks to be relatively unhealthy – lack of fresh produce in grocery stores, food deserts, car-centric urban sprawl requiring people to spend a lot of time in their vehicles, etc. Without concerted effort, especially in low-income areas of the city, to address these public health deficiencies present throughout the city, San Antonio residents will continue to suffer.

    1. A good book about the damage done to the West Side of San Antonio, “West Side Rising: How San Antonio’s 1921 Flood Devastated a City and Sparked a Latino Environmental Justice Movement” by Char Miller has been recommended to me by my wife. Don’t worry, it’s on my book list. ↩︎
    2. Here is a screenshot of the map, as well:
      ↩︎