In this first part in a series dedicated to looking at geographical data, we're going to introduce you to OpenStreetMap data, import that data into an IBM Cloud Databases for PostgreSQL deployment, and make queries on some of the non-conventional data stored in hstore columns
We are going to look at how to upload an Esri shapefile of Seattle streets, layer on a set of locations throughout Seattle, and then find the shortest paths to those points using the street network.
We're going to show you how PostgreSQL, PostGIS, and pgRouting on IBM Cloud Databases for PostgreSQL can get you started with complex geospatial queries.
Geospatial data plays a crucial role in data forecasting, spatial analytics, and reporting, especially in the fields of logistics and finance. With IBM Cloud SQL Query, you can now run SQL queries on geospatial data on files stored as CSV, Parquet, or JSON in IBM Cloud Object Storage (COS) using IBM's geospatial toolkit.