Configuring your Geological database

GeologXL connects with its datasources in a disconnected manner. This allows for offline capture and editing.

Data is organized into layers and categories.

You determine the categories and layers you want. Some layers can just be for orientation or data. Others can be the actual capturing layers. The capturing layers will usually come from a database.

You can also set up all your metadata. The metadata can come from a database (the usual case) or can be fixed local lists.

You can refresh your metadata and geology data by clicking the load offline layers button on the toolbar. As long as you have a connection to your database this will re-load all your metadata etcetera from the connected database or even databases.

You are not limited to a single database in GeologXL.

You can define relations between your data to allow master detail capturing:

In the above when we view the data for the class layer we see that there are child records, class details for each class record.

This was set up by defining relations in the GeologXL system for clasts and class details.

If the datasource for a layer is from a database then there is a SQL query specified to retrieve the data for the layer.

In this case the layer SQL was set up to only retrieve the class data for clasts within the current screen boundaries.

This allowed only data for the current working area to be downloaded.