In the details section of a spatial data source, click on Permissions to access the permissions section. You can also modify permissions in batches. To do this, select several data sources in the list and click on Permissions.
A list of authorized users and groups displays. Click on to add new users or groups. The available users and groups are configured in the JMap Server section of JMap Admin. Refer to the Managing Users and Groups section for more information on managing users in JMap.
Only administrator permissions are associated with spatial data sources.
Permissions for spatial data source
Remote access
Allows a user to access this spatial data source through a JMap Server to JMap Server connection.
This permission must be granted to the user account through which the secure connection between both JMap Servers was established.
For more information on this topic, refer to sections JMap Server to JMap Server Connections and Sharing Spatial Data Sources.
Administrate spatial data source
Allows an administrator to modify the configuration of the spatial data source.
Access spatial data source
Allows an administrator to create layers that take their data from this data source.
The attribute configuration window contains two tabs: Metadata and Attribute sample. This button is used to update the statistics of the SDS.
Metadata
Type
Indicates the attribute’s data type.
SQL Type
Indicates the SQL type of the attribute data.
Indexed
Check this box to have the attribute indexed.
Title
You can change the title of the attribute.
Format pattern
Specify a format pattern for displaying SDS items.
The pattern must follow the Java standards.
This article offers more details: https://docs.oracle.com/javase/tutorial/i18n/format/decimalFormat.html.
Upon saving, recursively apply to associated layers…
By checking the appropriate boxes, you will apply the title and/or format pattern of the attribute to all layers that are associated with the SDS.
1
General information configured when creating the SDS.
2
SDS parameters configured when it was created.
The hyperlink allows you to access the DB that contains the data.
3
Spatial information.
The extent corresponds to the geographical extent of the elements contained in the SDS.
When it has no elements, the values are equal to 0.
4
JMap Cloud. This section allows you to share the vector SDS in the JMap Cloud platform.
The section Sharing a vector SDS with JMap Cloud provides details on this function.
5
Attributes. This section presents a list of SDS attributes.
Clicking on the name of an attribute will open a window, allowing you to configure its properties.
6
References. This section lists the projects and layers that use this SDS.
A legend indicates which layers are referenced.
7
These buttons allow you to edit, update or delete the SDS configuration. A button also allows to make the vector SDS of file type editable.
8
The menu provides access to the Metadata, Permissions and Scheduling automatic data source updates sections.
External attributes for a spatial data source are attributes that are obtained from an external database (external means a database that is separate from the data source itself). The external attributes are added to the list of existing attributes and can thereafter be used like any other attribute in reports, queries, mouseover, thematics, etc.
External attributes are available only for vector spatial data sources that read data from files (shp, mif, tab, dwg, dgn, etc.) and JMap Spatial tables. When working with vector data sources that access data inside existing spatial databases (PostGIS, MySQL Spatial, Oracle Spatial/Locator, etc.), this option is not available. In that case however, it is often easy to include all needed attributes using normal SQL joins with other tables or by creating views.
External attributes are created from the spatial data source creation wizard.
To create an external attribute, choose External attributes in the Attribute section of the wizard. Press Add and choose one of the following two methods: Select fields or SQL query.
Choose this option in order to select one or more fields from a specific database table from which you want to obtain the values. This option is the simplest method, and it allows you to create several attributes at once.
Choose this option to provide an SQL query that will extract the attribute values in the database. This method is more flexible, but limits you to creating one attribute at a time.
Metadata can be associated with spatial data sources in JMap. It can include information such as the person who produced the data, the date it was updated, a description, etc. Users can view this information for the corresponding layers in JMap applications. Metadata can be entered directly into JMap Admin using preset templates or it can be taken from an external metadata management system. Refer to the section for more information on creating templates.
To access the metadata settings of a spatial data source, click on Metadata in the details section of a spatial data source. The following options are available:
Layers whose data originates from spatial data sources with metadata will automatically inherit this metadata. Metadata can be viewed by users of JMap Web and JMap Pro applications.
JMap Server allows you to define metadata templates to document spatial data sources directly in JMap Admin. Once the template has been defined, you can associate it to certain data sources and enter all the information, which users can then easily view in JMap’s applications. If you already use a metadata management system that can be accessed in a browser, you can also create a direct link between certain layers and this system.
You can create as many metadata templates as you want.
The metadata template management section can be accessed by clicking on Metadata templates in the Spatial data section.
Click on Create to create a new template. The interface shows the following options.
This icon allows you to provide the title in multiple languages.
Settings
Database
Select the database from which the attribute values will be taken.
This database must already be configured in JMap Admin.
Schema
Select the schema containing the table.
Table
Select the table containing the fields to be used as external attributes.
Include
The list of available fields is displayed.
Select the ones to be included as external attributes.
GET VALUE FROM
Indicate the name of the field.
ATTRIBUTE NAME
You can give the external attribute a name that will be different from the field name.
DYNAMIC ATTRIBUTE
Select this option if you want the attribute to be dynamic.
Dynamic attributes are read directly from the source in a dynamic manner.
Attributes that are not dynamic are imported into JMap’s system database and are only reread when the data source is updated.
In certain cases, dynamic attributes can reduce the system’s performance.
Join on fields
Select the parameters of the join between the external data and the JMap data source.
Aggregation type
This option is only available if a single field is selected.
Select the aggregation method to use if more than one value is found for the same geometry: Keep first element: Keep only the first value found. Average: Calculate the average value to use as the attribute value. Only available for numeric attributes. Summation: Calculate the summation value to use as the attribute value. Only available for numeric attributes. Using separator: Build a string containing all values separated by the specified character. Only available for text attributes.
Parameters
Attribute name
Enter a name for the external attribute.
Dynamic attribute
Select this option to make the attribute dynamic.
Dynamic attributes are read directly from the source in a dynamic manner.
Non dynamic attributes are imported in JMap’s System database and are only reread when the spatial data source is updated in JMap Admin.
Dynamic attributes can impact performances in some situations.
Database
Select the database from which the attribute values will be taken.
This database must already be configured in JMap Admin.
SQL query
Enter the SQL query to be executed in the external database that returns the values to use for the external attribute, along with the field used to join with the data source.
Press Execute to test the query and to initialize the other parts of the interface.
Get value from
Select the table and the field to get the values from.
Only those returned by the SQL query are available.
Join on fields
Select the parameters of the join between the external data and the JMap data source.
Aggregation type
Select the aggregation method to use if more than one value is found for the same geometry: Keep first element: Keep only the first value found. Average: Calculate the average value to use as the attribute value. Only available for numeric attributes. Summation: Calculate the summation value to use as the attribute value. Only available for numeric attributes. Using separator: Build a string containing all values separated by the specified character. Only available for text attributes.
Metadata |
|
Type | 3 options are possible: None: No metadata is associated with this data source. External: The metadata comes from a metadata management system that is outside of JMap and accessed through a URL. The URL must be entered in the URL field below. Template: The metadata is entered directly in this section using the selected template. |
URL | If the type of metadata is external, this setting defines the URL to be opened in order to view the metadata associated with this spatial data source. |
Template | If the type of metadata is template, select the template to be used for this data source. The metadata entry form for this template displays. Enter the metadata in the various fields. |
Metadata template |
Name | Enter a name for this template. Template names must be unique. |
Default language | Among the languages available for the metadata template, choose the default language that will be used when the requested language is unavailable or when translations are missing. |
Available languages | Select one or more languages that will be supported for this metadata template. All text elements in the template's configuration (section and field names, field values) will have to be translated into each supported language. You must select at least one language. |
Section name | You can define one or more metadata sections. Enter a name for the current section. |
Label | Enter a label for the field. The label text will be displayed in the metadata entry window and in the consultation interface. |
Type | Select the type of field. The following types are available: TEXT: Alphanumeric data entry field on a single line. TEXTAREA: Data entry field spanning multiple lines to allow for longer text. |
Mouseover | By selecting this option, the field value will be displayed in the mouseover bubble when a layer is pointed in the layer bar of JMap Server applications. This bubble presents a summary of a layer's metadata. |
Click on to add a new section.
Click on to delete a section.
Click on to add a new field.
Click on to delete a field.
