GeoPackage Table

Examples

Below are examples of named table definitions for a GeoPackage database table.

In this example, the definition defines a connection to a GeoPackage database table using the following tokens:

@table@ the name of the table in the database
named_connection_path the name of the named file connection with path in the repository

<?xml version="1.0" encoding="UTF-8"?>
<mxp:NamedDataSourceDefinition xmlns:mxp="http://www.mapinfo.com/mxp" xmlns:gml="http://www.opengis.net/gml" version="MXP_WorkSpace_1_5">
	<ConnectionSet>
		<NamedConnectionRef resourceID="@named_connection_path@">
			<ConnectionName>Connection_1</ConnectionName>
		</NamedConnectionRef>
	</ConnectionSet>
	<DataSourceDefinitionSet>
		<GeoPackageDataSourceDefinition id="id300" readOnly="false">
			<mxp:DataSourceName>JDBCDataSource</mxp:DataSourceName>
			<mxp:ConnectionMember>
				<mxp:ConnectionName>Connection_1</mxp:ConnectionName>
			</mxp:ConnectionMember>
			<FileName>geopackage.gpkg</FileName>
			<mxp:DBTable>@table@</mxp:DBTable>
		</GeoPackageDataSourceDefinition>
	</DataSourceDefinitionSet>
	<DataSourceRef ref="id300"/>
</mxp:NamedDataSourceDefinition>

The location of the GeoPackage file is the concatenation of the FilePath identified in the ConnectionMember (if present) and the FileName.

Note: The ConnectionMember is optional thus allowing the FileName to contain the complete specification of the file location.

This example shows a named table definition that uses the DBDataSourceMetadata to specify a Cartesian SRS, which is required when the GeoPackage table has an SRID of -1.

<?xml version="1.0" encoding="UTF-8"?>
<NamedDataSourceDefinition xmlns="http://www.mapinfo.com/mxp" xmlns:gml="http://www.opengis.net/gml" version="MXP_NamedResource_1_5">
<ConnectionSet>
	<NamedConnectionRef resourceID="/Samples/NamedConnections/SampleData">
		<ConnectionName>Connection_1</ConnectionName>
	</NamedConnectionRef>
</ConnectionSet>
<DataSourceDefinitionSet>
	<GeoPackageDataSourceDefinition id="id1" readOnly="false">
		<DataSourceName>GPKG_DataSource</DataSourceName>
		<ConnectionMember>
			<ConnectionName>Connection_1</ConnectionName>
		</ConnectionMember>
		<FileName>geopackage.gpkg</FileName>
		<DBTable>GRID15</DBTable>
			<DBDataSourceMetadata>
				<FeatureGeometryAttribute srsName="epsg:3857">geom</FeatureGeometryAttribute>
			</DBDataSourceMetadata>
	</GeoPackageDataSourceDefinition>
</DataSourceDefinitionSet>