I want to make a nuanced heat map of transit access, but my computer cannot handle the processing.
I'm using a GTFS table with a each trip in a city's bus system. Each trip has a unique trip_id. I've used the lat/long to place a point for every stop on every bus trip.
This looks like a map of bus stops in the city, but in fact there are dozens or hundreds of points on top of each other -- one for each time a bus arrives at that stop.
I want to create the 0.5-mile service area using Network Analyst around each of these points. My computer crashes here. If I could complete this step, I would then merge the resulting polygons by trip_id. This would generate each trip's walkshed as a single polygon. I would then spatial join those polygons and rasterize the count of overlapping polygons to show how many distinct transit trips you can walk to from a given point.
This is superior to an easier method: using the number of times a bus arrives at a stop. If you live between Stop A and Stop B, your location would get "credit" for when Bus X arrives at Stop A and again when it arrives at Stop B, even though in reality that isn't materially increasing your transit access.
How can I change this analysis so that my computer doesn't crash? Or how else can I capture this nuance in a simpler method?