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.

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 ...

    • Creating Map Layers

      Overview Note: You may not need to create your own Map Layer, your account will have many pre-built layers for you to use. See below. Go to Pre-defined Layers to see what layers have already been created for you. Creating your own Map Layer is the ...

    • Using the Public Map

      Overview The Public Map module is a tool for creating interactive read-only maps that can be embedded into public websites. Video Tutorial Compatibility Compatible Services Parish Online XMAP for Local Government Limitations / Terms Safari is not ...

    • Reordering Map Layers

      Overview As you build up your account with different Map Layers, you may find that when multiple layers are switched on, they obscure one another. A way around this is to reorder them. In your Admin Panel you'll have a list of your Map Layers. This ...

    • Pre-defined Layers

      Overview Parish Online has a range of layers pre-included in your account to make getting started with the software much easier. These are ready-to-use layers. Rather than having to create your own layer before you start drawing onto the map, you can ...