-
Book Overview & Buying
-
Table Of Contents
SQL for Data Analytics - Fourth Edition
By :
Consumer behavior generally will vary among different geographical areas. People living in large cities certainly behave differently from people living in the countryside. So, in addition to looking at time-series data and text patterns to better understand trends, Postgres also allows you to 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.
Locations are often thought about in terms of the address— the city, state, country, or postal code that they are assigned to. For example, you can look...