Annotations in a database

<< Click to Display Table of Contents >>

Navigation:  Spatial Data Sources > Vector Data Sources >

Annotations in a database

Read

Yes

Write

No

JMap has its own storage format for annotations in database tables. If you have any annotations in this format, JMap Server can use them as a spatial data source. Annotation tables in JMap format have a certain number of required fields, as explained in the table below. An SQL query must be provided. The query will be executed to read the data and it can access more than one table at a time.

The database connection must already be configured. Refer to the Creating Databases section for more details on this topic.

Parameters

Database

Select the database from which the data must be read. This database must already be configured in JMap Admin.

SQL query

Enter the SQL query used to extract annotations from the database.

Geometry table

Select the physical table containing the geometries. By clicking on Load, you will obtain the list of fields returned by the query. This action is necessary to configure the remaining parameters.

X field

Select the field containing the X coordinate of the lower left position of the text.

Y field

Select the field containing the Y coordinate of the lower left position of the text.

Id field

Select a field containing unique identifiers. Only fields containing whole numbers are listed.

Text field

Select the field containing the annotation text.

Height field

Select the field containing the height of the annotation, indicated in data units.

Angle field

Select the field containing the rotation angle of the annotation text. The angle is indicated in degrees and increases clockwise. The zero value indicates that the text is horizontal.