How to Make Maps Using Leaflet.js, PostGIS and Chicago Open Data

The data includes the below for each rideshare trip:

I figured I would play around with the data, to at least learn some new skills, and at most find something interesting in the dataset. There are potentially other data cleaning issues – this post is intended to be more educational on how to produce these maps, as opposed to finding anything particularly interesting in the data

My first idea was to simply look at the raw number of trips, by pickup location:

Take a look at the logarithmic scale in the legend. Let’s make our own database to store the rideshare data:

Then, let’s change to this database:

You should see say something like You are now connected to database “rideshare” as user “postgres”.

Source: samc1213.github.io