Each year, New York City celebrates Pride Month with a large procession down 5th Avenue, passing by the Stonewall Inn, the site of a police raid in 1969 that launched the gay liberation movement.
The event, which marks the important political, social, and historic impact of the gay liberation movement, also has a significant physical and spatial impact on the city. We wanted to find the post-pride parade hotspots to assess the effect the parade on local businesses and transit. (And also it’s just kind of cool data).
We took yellow NYC taxi pick-up and drop-off data from Sunday, June 26th, 2016 (NYC only releases taxi data monthly, so we’ll update this once we have 2017 data!), and compared it with data from the previous Sunday (June 19th) to get a somewhat like-for-like comparison.
We plotted taxi drop-off locations where:
We then clustered these points using a commonly used spatial clustering algorithm called DBSCAN, which looks at the density of points within a specified region and groups points if they are sufficiently densely packed.
Because we are interested in finding the specific locations where people go, we set our search radius for the algorithm to be fairly small (10 meters or around 32 feet).
From here, we looked at where these clusters are and what is in the area. Our seasoned team of expert LGBTQ socialites handpicked some of the larger (and thus, more likely) events, businesses, and public venues where we see clusters and used CARTO’s walkshed function to calculate 1-min and 2-min walksheds around these areas to see if the clusters fall in these regions.
We can see:
Where did people go in 2017? Check back in a few weeks to see what the data tells us. Happy Pride!
Although leading data warehouses already offer some level of support for spatial data, they can usually only work with core spatial functionalities and lack some of the adv...Use Cases
The Healthy Regions + Policy Lab (or HeRoP) at the University of Chicago integrates innovative GIScience, public health, and statistical approaches to explore, understand, ...Use Cases
In September 2021 many petrol stations across the UK ran out of fuel. Panic buying was attributed to media reports of a leaked government briefing outlining the shortage of...Use Cases
Please fill out the below form and we'll be in touch real soon.