Class PostgisDSMetadata

java.lang.Object

com.vividsolutions.jump.datastore.spatialdatabases.SpatialDatabasesDSMetadata

com.vividsolutions.jump.datastore.postgis.PostgisDSMetadata

All Implemented Interfaces:

DataStoreMetadata

public class PostgisDSMetadata
extends SpatialDatabasesDSMetadata

Field Summary

Fields inherited from class SpatialDatabasesDSMetadata

conn, coordDimQuery, datasetInfoQuery, datasetNameQuery, dataStoreLayers, defaultSchemaName, geoColumnsQuery, reader, spatialDbName, spatialExtentQuery1, spatialExtentQuery2, sridMap, sridQuery, txtReader

Constructor Summary

Constructors

Constructor	Description
PostgisDSMetadata(DataStoreConnection con)

Method Summary

Modifier and Type	Method	Description
String	getAddSpatialIndexStatement(String schemaName, String tableName, String geometryColumn)	Create statement to add a spatial index on the specified geometry column.
String	getCoordinateDimensionQuery(String schemaName, String tableName, String colName)
protected String	getDbTypeName(AttributeType type)	Return standard SQL data type for OpenJUMP AttributeType.
String	getGeoColumnsQuery(String datasetName)
List<GeometryColumn>	getGeometryAttributes(String datasetName)	Retrieves list of geometric tables from a custom DB Query: Should use OGC metadata geoemtry_columns or equivalent mechanism according to target DB.
String	getSpatialExtentQuery1(String schema, String table, String attributeName)
String	getSpatialExtentQuery2(String schema, String table, String attributeName)
String	getSridQuery(String schemaName, String tableName, String colName)

Methods inherited from class SpatialDatabasesDSMetadata

createColumnList, getAddGeometryColumnStatement, getColumnNames, getCoordinateDimension, getCreateTableStatement, getDatasetInfoQuery, getDatasetNameQuery, getDatasetNames, getDataStoreConnection, getDataStoreLayers, getDefaultSchemaName, getExtents, getGeometryAttributes, getPrimaryKeyColumns, getSchemaName, getSpatialDbName, getSRID, getTableName, isIndexed, missingGeoException, querySRID

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

PostgisDSMetadata

public PostgisDSMetadata(DataStoreConnection con)

Method Details

getSpatialExtentQuery1

public String getSpatialExtentQuery1(String schema,
 String table,
 String attributeName)

Overrides:

getSpatialExtentQuery1 in class SpatialDatabasesDSMetadata

getSpatialExtentQuery2

public String getSpatialExtentQuery2(String schema,
 String table,
 String attributeName)

Overrides:

getSpatialExtentQuery2 in class SpatialDatabasesDSMetadata

getGeoColumnsQuery

public String getGeoColumnsQuery(String datasetName)

Overrides:

getGeoColumnsQuery in class SpatialDatabasesDSMetadata

getSridQuery

public String getSridQuery(String schemaName,
 String tableName,
 String colName)

Overrides:

getSridQuery in class SpatialDatabasesDSMetadata

getGeometryAttributes

public List<GeometryColumn> getGeometryAttributes(String datasetName)

Description copied from class: SpatialDatabasesDSMetadata

Retrieves list of geometric tables from a custom DB Query: Should use OGC metadata geoemtry_columns or equivalent mechanism according to target DB.

Specified by:

getGeometryAttributes in interface DataStoreMetadata

Overrides:

getGeometryAttributes in class SpatialDatabasesDSMetadata

Parameters:

datasetName - name of a dataset

Returns:

list of GeometryColumn's referenced in this dataset

getCoordinateDimensionQuery

public String getCoordinateDimensionQuery(String schemaName,
 String tableName,
 String colName)

Overrides:

getCoordinateDimensionQuery in class SpatialDatabasesDSMetadata

getDbTypeName

protected String getDbTypeName(AttributeType type)

Description copied from class: SpatialDatabasesDSMetadata

Return standard SQL data type for OpenJUMP AttributeType. This method must be overloaded by specific database oj2dbType

Overrides:

getDbTypeName in class SpatialDatabasesDSMetadata

Parameters:

type - OpenJUMP attribute type

Returns:

the database datatype

getAddSpatialIndexStatement

public String getAddSpatialIndexStatement(String schemaName,
 String tableName,
 String geometryColumn)

Create statement to add a spatial index on the specified geometry column. The geometry column name must have its final form. Attribute name normalization is the responsability of the calling method.

Overrides:

getAddSpatialIndexStatement in class SpatialDatabasesDSMetadata

Parameters:

schemaName - unquoted schema name or null if default schema is used

tableName - unquoted table name

geometryColumn - unquoted geometry column name

Returns:

a sql string to add a spatial index