From Existing Table

Once the import script has been run on the server we are ready to create references in Earthlight. To create new reference for a layer please follow the steps below:

Click here to select the repository.
You can use this search box to quickly locate desired table.
Highlight layer/s for which you want to create references.
Select destination folder for references.
Click Create layer reference to start the operation.

You can also reference spatial views and non-spatial tables which store Easting and Northing data.

Creating reference to Views and Non-spatial tables works in similar way as common table, however it required entering some additional information.

From Earthlight version 2014 R2 it’s possible to order tables by creation date (timestamp). However, only new layers imported by Earthlight or by one of Earthlight tools will contain creation date.

Views

Choose views group from the Repository drop down menu.
Choose a view that you want to reference.
Select your reference location.
Click Create layer reference button.

Now you need to set your reference settings.

First, choose a primary key column for your view.
Set view’s geometry column.
Specify geometry type.
Add all the tables that are referenced to your view. You can use search box to quickly locate desired table.

Please note

Selecting tables which are referenced to your view is required for creating database triggers on them and to allow Earthlight refreshing caches of the view. It is required for example when one of the view 'source' tables changes.

If you are not aware which tables are used in the view:

please ask your db administrator about this information,

or

select a table which is not a part of the view, but you know that it is regularly updated (every day for instance). In this case, referenced view caches will be updated so often as the selected table.

Non-Spatial Tables

In case of Non-spatial tables – select Primary key⁽¹⁾, Easting⁽²⁾ & Northing⁽³⁾ columns and set SRID⁽⁴⁾.

Web Mapping Service

It is required to expose the Earthlight server to the Internet to be able to connect to a remote WMS server.

Here’s the example of usage for some free geology data from http://ogc.bgs.ac.uk/

In order to add a new reference to the WMS layer go to Administration > Create > From Existing Table.

Now you should choose the directory where a reference will be created⁽¹⁾ (this is mandatory to enable the Create web layer referencebutton). Next click the arrow on the Create web layer reference button and choose Create WMS reference⁽²⁾ option from the drop-down list.

To reference the layer, you have to set all the WMS settings inside the displayed dialog.

First you have to fill the Address field for the Web Map Service (we used http://ogc.bgs.ac.uk/cgi-bin/BGS_Bedrock_and_Superficial_Geology/wms).
Choose the version of WMS server (most servers serve all the versions of WMS, so if you are not sure which one is good, you can tryv1.3.0).
Click the Get capabilities button to get the layer names from the server.
Choose the layer, you want to reference.
Write layer name. It has to be at least 3 characters long and consist exclusively of letters, numbers, underscores, spaces and dashes.
Set SRS (Spatial Reference System) to EPSG:27700.
Choose the tile images format and click OK.

Now the layer is referenced and ready for use. You can add it to the map.