NYC Taxi Rides

Pickup and dropoff points for 1M NYC taxi rides on Jan 1-3, 2010.

Using a data loader, we ingest a remote file into DuckDB and project [longitude, latitude] coordinates (in the database!) to spatial positions with units of feet (1 foot = 12 inches). We then load the prepared data to visualize taxi pickup and dropoff locations, as well as the volume of rides by the time of day.

Please wait a few seconds for the dataset to load.

Select an interval in a plot to filter the maps. What spatial patterns can you find?