This is documentation of an archived release.
For documentation on the current version, please check Knowledge Base.

Back to Landing page for Databases in Orbit
Back to Supported Geodata Resources

Spatial Databases

A spatial database is a database that is optimized to store and query data that is related to objects in space, including points, lines and polygons. While typical databases can understand various numeric and character types of data, additional functionality needs to be added for databases to process spatial data types. These are typically called geometry or feature.

Anyway any database can be used to store spatial information. Using a GIS interface like Orbit this spatial data can be viewed and queried. In this way a free and easy to install database can be turned into a powerful spatial database. Therefore, some additional fields are required and the geometry needs to be stored using well-known text or well-known binary. Points can also be saved by storing their coordinates in separate fields.

The database table stores both spatial information (geometry) and attribute information.


Accessing a spatial database in Orbit

  1. Database Connection
    Configure a JDBC Database Connections using an available Database Driver.

  2. Orbit DataBase File
    Create an Orbit DataBase File from the datasetlist drop-down.
    The .odb File describes how spatial information is stored in an external database and allows the translation of spatial data from a database into an Orbit dataset. This odb-file can be considered as a map layer.

  3. Open dataset
    The odb-file will be automatically added to the datasetlist at creation. Open an existing odb-file in Orbit like a normal dataset, see Open dataset


Supported Databases

Orbit supports any database via the Java Database Connectivity.
To make a Connection from a Java application to a database, a database driver is required. Many databases provide a Java class to access their database using the SQL language. These are JDBC drivers : JDBC Database Drivers.

Spatial and Relational Databases

  • MS Access
  • MySQL
  • Oracle
  • Postgresql
  • SQLServer


Supported Database Geometries

Vector geometry can be stored in different ways in a database table. Orbit supports :

Orbit advises the use of Well-Known text as it is an ISO standard and originally defined by the Open Geospatial Consortium. The below listed WKT geometry types are supported :

  • GeometryCollection
  • LineString
  • MultiLineString
  • MultiPoint
  • MultiPolygon
  • Point
  • Polygon
  • PolyhedralSurface
  • TIN
  • Triangle


Add spatial bounding boxes

To reduce database access and optimize the speed of use in Orbit, object bounding columns can be added in the database table.
This is optional but advised when reading large amounts of vector data stored as Well known text or well known binary. It is mandatory for writing (insert or update).
When using Oracle spatial to store and manage the object geometry, these viewing optimizations are managed by Oracle. No Orbit interaction or optimizations are supported.

Orbit auto-calculate the bounding values for all objects at first view, and update them on object edits.
The object bounding database columns must be created by the administrator. Orbit will only used them if available. The value type should be Double and their names are fix, using the “SPATIAL_COLUMN” name as defined in the Orbit DataBase File as prefix :

  • <SPATIAL_COLUMN>MINX
  • <SPATIAL_COLUMN>MAXX
  • <SPATIAL_COLUMN>MINY
  • <SPATIAL_COLUMN>MAXY


Edit database structure

However Orbit is able to connect to any by Java supported database, Orbit is not a database management application.

Using Orbit following database actions are supported :

  • Insert a table record
  • Edit or Update a table record
  • Remove a table record
  • Insert a new database table

In other words this means that it is possible in Orbit to :

  • Create, edit and remove an object in Orbit.
    One table record is one object in Orbit. Both spatial component and attribute component can be updated using Orbit
  • Create and delete a dataset in Orbit stored in an available database connection. (only available from Orbit Asset Inventory).

Dataset structure management like add or remove attributes must be done via the database design table tools.

 
Last modified:: 2021/08/12 12:22