Personal geodatabase (ESRI)

 

Read

Yes

Write

No

 

JMap Server can read Personal geodatabases to extract spatial and attribute data to be used as a spatial data source. This format uses Microsoft Access files to store the data. The connection to the Access database must already be configured using the ODBC driver (this is available on Windows systems only). See Creating Databases for more information.

Parameters

Database

Select the database to read the data from. This database should point to an ODBC source configured to read an MS Access file. It must already be configured in JMap Admin.

SQL query

Enter the SQL query used to extract geometries and attributes from the database.

Geometry table

Select the physical table that effectively contains the geometries. Pressing Load will retrieve the list of fields returned by the query. This is necessary for the rest of the configuration.

Id field

Select a field that contains unique identifiers. Only integer fields are listed. It is usually called OBJECT_ID.