New features in 3.0

Support for custom identity providers

This version provides you with the ability to integrate your existing identity provider and corporate users accounts with GeoSpock DB, so that you do not have to create database user accounts for all your existing users to be able to access the ingested data. Currently, GeoSpock DB supports the following identity providers:

  • AWS Cognito
  • LDAP

Process

GeoSpock DB's data management process is driven programmatically through a command line tool, the GeoSpock CLI, that enables you ingest your data and manage your datasets (The GeoSpock CLI). Using the GeoSpock CLI, you can:

  • ingest your source input data into the GeoSpock DB, including ingesting more data into the same dataset
  • list the datasets loaded into the GeoSpock DB
  • view the status and history of each dataset
  • delete datasets that you no longer require

Using the GeoSpock CLI, you can also:

  • create a data source description from a sample of your source input data; see Generating a data source description
  • manage the GeoSpock DB's user accounts
  • control access to the data ingested into GeoSpock DB

The GeoSpock DB supports source input data in the following formats:

  • comma separated values (.csv)
  • tab separated values (.tsv)
  • JSON lines (.jsonl)
  • Parquet

Query

The GeoSpock DB can run both temporal and geospatial functions on your data GeoSpock DB (Querying your data). A number of SQL functions have been optimized for use with the GeoSpock database. The optimized functions include:

  • ST_Within()
  • ST_Distance()
  • line_locate_point()
  • ST_Intersects()

The custom GeoSpock functions include:

  • GS_Distance_Within()
  • GS_great_circle_distance_within()

The are a number of ways that you can access the GeoSpock database by:

Integrate

You can integrate your existing Business Intelligence (BI) tools and visualization tools into the GeoSpock database enabling you to use the database in your existing work flows for data analysis (Integrating your third party tools).

You can run SQL queries on the GeoSpock database using the following Business Intelligence (BI) tools:

To support further analysis of your data, you can also integrate tools such as Apache Spark, Jupyter Notebooks and Kepler.gl with GeoSpock DB.

You can also connect to the GeoSpock database using either a command line interface (CLI) or database connector; see Accessing the GeoSpock database programmatically for more information.