Connect to a Database table

SpatialWorx supports connections to the following databases:

This page has the following options:

Remote Database Information

Host IP or DNS Name

The internet provider address or the domain name/system name of the remote database, e.g., ec2-34-210-141-104.us-west-2.compute.amazonaws.com or simply an IP address such as 27.202.15.159

Port Number

The port number identifying the location of the remote database. Often combined with the IP or DNS name to provide access to a set of data, e.g., 1521

Instance/Service Name

Multiple instances can be associated with a single database service. This field holds the specific instance or service name to point to the required source data, e.g., sw_project1

Remote Schema Name

A schema is a grouping of database objects (tables, views, etc) within a database. It is a way of logically partitioning objects within a database. With the proper permissions, tables in multiple schemas can be accessed with one database connection, e.g., swadmin_ovc_3

Remote Table Name

The name of the table within the Schema defined in Remote Schema Name, e.g., FITTINGS, POLE, PIPE, etc.

DB User

The user identification key that provides secure access to the Source being defined, e.g., SWADMIN123

DB Password

The password associated with the DB User key that provides secure access to the Source being defined, e.g., SWPWD123

Source Description

Source Name

The name by which the Source is referenced. This Name is referenced when you add a Layer to a Project.

Description

Brief description of the Source - this is only for your benefit and is optional.

Group Name

A Group Name is simply a way to group or logically organize different Layers in the SpatialWorx app so they are easy to find in the Layer display and placement menus.

Projection

Map projection system to be used, e.g., EPSG:4326, EPSG:3857

Geometry

Type of geometry being defined - select the appropriate icon:

  • Point
  • Line
  • Polygon
  • None

Allowed Feature Manipulations

This allows you to control what manipulations field users can perform on any feature Layers derived from this Source.

Place

Indicates that the Feature being defined can be placed in the SpatialWorx App.

Edit/Move Feature Geometries

Indicates that the Feature being defined can be graphically edited or moved in the SpatialWorx App.

Delete

Indicates that the Feature being defined can be deleted in the SpatialWorx App.