Publishing Layers from a Remote Database

Publishing Layers from a Remote Database

Overview

XMAP supports connections to any PostGIS database of version 9.6 or greater. This database can be hosted and managed by us or you. If you have a remote database you can use this to connect to many software applications to improve access to data across your organisation.

Connecting XMAP to your database

Contact support if you wish to connect XMAP to your database. You will need to provide:
  1. Host
  2. Username
  3. Password
  4. Database Name

Publishing Layers from your database

  1. From the XMAP Admin Panel access the Data -> Layers option on the left hand side. 
  2. Click the + button to add a new layer
  3. Click the 'Layer Type' drop down and select 'Remote PostGIS Connection'
  4. On the right hand side follow the prompts via the drop downs to select the Database, Schema and Table you want to publish. 
  5. Once a table is selected you can add a Title on the left.
  6. If the geometry of the table is of type 'geometry' you will be prompted to select a simple geometry type on the left.

Best Practices

To ensure compatibility across multiple systems and follow best practice for database management we recommend:

Always use lower case, alphanumeric, snake_case names for relations (schemas, tables, columns, constraints etc) in your database, e.g:
  1. Instead of calling your schema Building Control, call it building_control.
  2. Instead of calling your table Building Control Applications, call it building_control_applications.
  3. Instead of calling your column Application Reference (refval), call it application_refval.
XMAP may reject names if they do not follow this guidance. 

Notes
  1. Tables and Columns must:
    1. be in lower case, and camel_case
    2. start with a letter
  2. Where possible use text, integer and Date column types. If you find a different column type is not working please let us know.

    • Related Articles

    • Connecting to a Cloud Database through Microsoft Access

      Overview This article is for connecting to a cloud database in order to edit non-spatial data through Microsoft Access. This guide is for those using Windows. Method Required Installations Install Microsoft Access (if not installed already) Install ...

    • Adding Layers to Collections

      Summary: This short article will walk you through adding a layer into a collection. Adding Layers into a Collection: In the Collections section click on the collection name you want to add the layer into, or create a new Collection for the layer. ...

    • Database Manager

      Overview The Database Manager is made available if your organisation has 1 or more dedicated (private) PostgreSQL databases linked to it. It exposes administration functionality for you to manage your database at a high level without the need to ...

    • Quick introduction to layers in XMAP

      Overview Layers (points, lines, polygons or base mapping) are stored in Collections on the left of the map. Searching for layers: You can search for layers via the Layer Search tool at the top of the Collections panel. Layer Tools: When you click on ...

    • Database best practices

      This short article is designed to help you better understand how to get the most out of your data in both XMAP and QGIS by applying simple but effective 'best practice' principles to your PostGIS database. The golden rules: Schema names, table names ...