Performing Geospatial Analysis in PostgreSQL
In addition to looking at time series data to better understand trends, you can also use geospatial information (such as city, country, or latitude and longitude) to better understand your customers. For example, governments use geospatial analysis to better understand regional economic differences, while a ride-sharing platform might use geospatial data to find the closest driver for a customer.
You can represent a geospatial location using latitude and longitude coordinates, and this will be the fundamental building block for you to begin geospatial analysis.
Latitude and Longitude
Locations are often thought about in terms of the address—the city, state, country, or postal code that is assigned to the location that you are interested in. This is usually from an analytics perspective. For example, you can look at the sales volume in the ZoomZoom sales table by city and come up with meaningful results about which cities...