Module org.apache.sis.storage.sql
module org.apache.sis.storage.sql
Data store for features in a SQL spatial database.
This module expects a spatial schema conforms to the conventions described in the
OGC Simple feature access - Part 2: SQL option
international standard, also known as ISO 19125-2.
Difference with Geopackage
Compared to the OGC Geopackage standard, this SQL module has the following differences:- There is no discovery mechanism (e.g., no
"gpkg_contents"
table). The tables to use as resource definitions must be specified explicitly. - Each feature table can contain an arbitrary number of geometry columns, including zero. By contrast, Geopackage requires each feature table to have exactly one geometry column.
- As a consequence of the above, this module makes no distinction between "features" table and "attributes" table.
- This module supports complex features, i.e. features having associations to other features. The associations are discovered automatically by following the foreigner keys.
- Primary keys are optional. If present, they can be of any type (not necessarily integers) and can be composite (made of many columns). By contrast, Geopackage mandates primary keys made of exactly one column of integers.
- Since:
- 1.0
-
Packages
ExportsPackageDescriptionData store capable to read and write features using a JDBC connection to a database.Indirect ExportsFromPackagesorg.apache.sis.coverage org.apache.sis.coverage.grid org.apache.sis.feature org.apache.sis.feature.builder org.apache.sis.filter org.apache.sis.image org.apache.sis.index.treeorg.apache.sis.metadata org.apache.sis.metadata.iso org.apache.sis.metadata.iso.acquisition org.apache.sis.metadata.iso.citation org.apache.sis.metadata.iso.constraint org.apache.sis.metadata.iso.content org.apache.sis.metadata.iso.distribution org.apache.sis.metadata.iso.extent org.apache.sis.metadata.iso.identification org.apache.sis.metadata.iso.lineage org.apache.sis.metadata.iso.maintenance org.apache.sis.metadata.iso.quality org.apache.sis.metadata.iso.spatial org.apache.sis.metadata.sql org.apache.sis.util.iso org.apache.sis.xmlorg.apache.sis.coordinate org.apache.sis.geometry org.apache.sis.io.wkt org.apache.sis.parameter org.apache.sis.referencing org.apache.sis.referencing.crs org.apache.sis.referencing.cs org.apache.sis.referencing.datum org.apache.sis.referencing.factory org.apache.sis.referencing.factory.sql org.apache.sis.referencing.operation org.apache.sis.referencing.operation.builder org.apache.sis.referencing.operation.matrix org.apache.sis.referencing.operation.transform -
Modules
RequiresIndirect RequiresModifierModuleDescriptiontransitiveRaster imagery and geometry features.transitiveImplementations of metadata derived from ISO 19115.transitiveReferencing by coordinates.transitiveUnits of measurement and miscellaneous utility methods required by Apache SIS.