New features in 3.0

GeoSpock DB is a cloud-based solution that processes big data and makes it available for analysis, enabling you to find patterns and trends in your data. It comprises features that enable you to:

  • process your data: the GeoSpock DB includes a command line interface (CLI) to enable you to manage your data, and user accounts; see Process
  • query your ingested data: the GeoSpock DB's SQL interface gives you access to your data for analysis; see Query
  • integrate the GeoSpock DB with your existing BI tools: the GeoSpock DB's architecture enables you to use standard database connectors to integrate it into your existing analysis work flows; see Integrate

Support for custom identity providers

This version now provides you 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:

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.