Adding Database Views and Non-spatial tables to Earthlight

Creating reference to Views and Non-spatial tables works in similar way as common table, however it requires entering some additional information. To start, go to Administration > Create > From Existing Table.

Views

  1. Choose a view that you want to reference.
  2. Select your reference location.
  3. Click Create a new reference button.

Now you need to set your reference settings.

  1. First, choose a primary key column for your view.
  2. Set view’s geometry column.
  3. Specify geometry type.
  4. Add all the tables that are referenced to your view.

Non-Spatial Tables

In case of Non-spatial tables – select Primary key(1), Easting(2) & Northing(3) columns and set SRID(4).