Analyzing 1. 1 Billion NYC Taxi and Uber Trips, with a Vengeance. The New York City Taxi & Limousine Commission has released a staggeringly detailed historical dataset covering over 1. The son of a mighty Carthaginian warrior, Hannibal Barca will stop at nothing to wipe out the Roman Republic. Experts describe his global vision in this. AS OF MONDAY, AUGUST 08, 2016 ALL EVENT STAFF IS HEADED TO THE HILTON. EMails May Not Be Answered Quickly Born of Vengeance (12), The League: Nemesis Rising #1 New York Times Best Selling Series. January 2. 00. 9 through June 2. Taken as a whole, the detailed trip- level data is more than just a vast list of taxi pickup and drop off coordinates: it. How bad is the rush hour traffic from Midtown to JFK? Where does the Bridge and Tunnel crowd hang out on Saturday nights? What time do investment bankers get to work? How has Uber changed the landscape for taxis? And could Bruce Willis and Samuel L. Jackson have made it from 7. Broadway to Wall Street in less than 3. The dataset addresses all of these questions and many more. I mapped the coordinates of every trip to local census tracts and neighborhoods, then set about in an attempt to extract stories and meaning from the data. This post covers a lot, but for those who want to pursue more analysis on their own: everything in this post. Full instructions to download and analyze the data for yourself are available on Git. Hub. Table of Contents. Maps. The Data. Borough Trends, and the Rise of Uber. Airport Traffic. On the Realism of Die Hard 3. How Does Weather Affect Taxi and Uber Ridership? NYC Late Night Taxi Index. The Bridge and Tunnel Crowd. Northside Williamsburg. Privacy Concerns. Investment Bankers. Parting Thoughts. Update. I. You can click the maps to view high resolution versions: These maps show every taxi pickup and drop off, respectively, in New York City from 2. The maps are made up of tiny dots, where brighter regions indicate more taxi activity. The green tinted regions represent activity by green boro taxis, which can only pick up passengers in upper Manhattan and the outer boroughs. Notice how pickups are more heavily concentrated in Manhattan, while drop offs extend further into the outer boroughs. If you think these are pretty, I recommend checking out the high resolution images of pickups and drop offs. Each individual trip record contains precise location coordinates for where the trip started and ended, timestamps for when the trip started and ended, plus a few other variables including fare amount, payment method, and distance traveled. I used Postgre. SQL to store the data and Post. GIS to perform geographic calculations, including the heavy lifting of mapping latitude/longitude coordinates to NYC census tracts and neighborhoods. The full dataset takes up 2. GB on disk, before adding any indexes. For more detailed information on the database schema and geographic calculations, take a look at the Git. Hub repository. Uber Data. Thanks to the folks at Five. Thirty. Eight, there is also some publicly available data covering nearly 1. Uber rides in NYC from April. The Uber data is not as detailed as the taxi data, in particular Uber provides time and location for pickups only, not drop offs, but I wanted to provide a unified dataset including all available taxi and Uber data. Each trip in the dataset has a cab. Yellow taxis still account for more drop offs in Brooklyn, since many people continue to take taxis from Manhattan to Brooklyn, but even in drop offs, the green taxis are closing the gap. Let. I live in Brooklyn, and although I sometimes take taxis, an anecdotal review of my credit card statements suggests that I take about four times as many Ubers as I do taxis. As of June 2. 01. I wrote this, Uber accounts for more than twice as many pickups in Brooklyn compared to yellow taxis, and is rapidly approaching the popularity of green taxis: Note that Uber data is only available from Apr 2. In any given month, around 8. NYC taxi pickups occur in Manhattan, and most of those are made by yellow taxis. Even though green taxis are allowed to operate in upper Manhattan, they account for barely a fraction of yellow taxi activity: Uber has grown dramatically in Manhattan as well, notching a 2. June 2. 01. 4 to June 2. Uber made 1. 4 million more Manhattan pickups in June 2. June 2. 01. 4, while taxis made 1. However, even though Uber picked up nearly 2 million Manhattan passengers in June 2. Uber still accounts for less than 1. Manhattan pickups: Queens still has more yellow taxi pickups than green taxi pickups, but that. And although Uber has experienced nearly Brooklyn- like growth in Queens, it still lags behind yellow and green taxis, though again the yellow taxis are heavily influenced by airport pickups: If we restrict to pickups at La. Guardia and JFK Airports, we can see that Uber has grown to over 1. The Bronx and Staten Island have significantly lower taxi volume, but you can see graphs for both on Git. Hub. The most noteworthy observations are that almost no yellow taxis venture to the Bronx, and Uber is already more popular than taxis on Staten Island. But the Van Wyck Expressway was designed to carry. Even if the only traffic using the Van Wyck was JFK traffic, the expressway’s capacity would not be sufficient to handle it. If the Van Wyck expressway could not come anywhere near handling JFK’s traffic when that traffic was 1. Of course, this depends on many factors: is there bad rush hour traffic? Will your cab driver know a . In most cases, the worst hour to travel to an airport is 4. For example, the median taxi trip leaving Midtown headed for JFK Airport between 4 and 5 PM takes 6. Google Maps estimates about an hour travel time on public transit from Bryant Park to JFK, so depending on the time of day and how close you are to a subway stop, your expected travel time might be better on public transit than in a cab, and you could save a bunch of money. The stories are similar for traveling to La. Guardia and Newark airports, and from other neighborhoods. You can see the graphs for airport travel times from any neighborhood by selecting it in the dropdown below: Pick a neighborhood. Battery Park- Lower Manhattan. Central Harlem North. Central Harlem South. Chelsea- Flatiron- Union Square. Chinatown. Clinton (Hell’s Kitchen)East Harlem North. East Harlem South. East Village. Gramercy. Lenox Hill- Roosevelt Island. Lincoln Square. Lower East Side. Marble Hill- Inwood. Midtown. Morningside Heights. Murray Hill- Kips Bay. So. Ho- Tri. Be. Ca- Little Italy. Stuyvesant Town. Turtle Bay- East Midtown. Upper East Side. Upper West Side. Washington Heights North. Washington Heights South. West Village. Yorkville. Bedford. Brooklyn Heights- Cobble Hill. Bushwick. Carroll Gardens- Red Hook. Clinton Hill. Crown Heights North. Crown Heights South. DUMBO- Downtown- Boerum Hill. East New York. East Williamsburg. Flatbush. Fort Greene. Greenpoint. Park Slope- Gowanus. Prospect Heights. Prospect Lefferts Gardens- Wingate. Stuyvesant Heights. Williamsburg. Astoria. Briarwood- Jamaica Hills. Elmhurst. Flushing. Forest Hills. Hunters Point- Sunnyside. Jackson Heights. Jamaica. Kew Gardens. Long Island City. Maspeth. Old Astoria. South Ozone Park. Springfield Gardens South- Brookville. Steinway. Woodside. Mott Haven- Port Morris. West Concourse. Travel time from to.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |