com.vividsolutions.jump.datastore.postgis

Class PostgisDSMetadata

java.lang.Object

com.vividsolutions.jump.datastore.postgis.PostgisDSMetadata

All Implemented Interfaces:

DataStoreMetadata

public class PostgisDSMetadata
extends java.lang.Object
implements DataStoreMetadata

Constructor Summary

Constructors

Constructor and Description
PostgisDSMetadata(PostgisDSConnection conn)

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String[]	getColumnNames(java.lang.String datasetName)
java.lang.String[]	getDatasetNames()
com.vividsolutions.jts.geom.Envelope	getExtents(java.lang.String datasetName, java.lang.String attributeName)
java.lang.String[]	getGeometryAttributeNames(java.lang.String datasetName) Deprecated.
java.util.List<GeometryColumn>	getGeometryAttributes(java.lang.String datasetName)
java.lang.String	getGeometryIndicesQuery(java.lang.String schema, java.lang.String table, java.lang.String column) Deprecated. initially thought that statistic used by ST_Estimated_Extent was depending on whether a spatial index exists or not. Finally, statistics and index seem to be two independant things
java.util.List<PrimaryKeyColumn>	getPrimaryKeyColumns(java.lang.String datasetName) Returns PRIMARY KEY columns of dataset names.
SpatialReferenceSystemID	getSRID(java.lang.String tableName, java.lang.String colName) Deprecated.
boolean	isIndexed(java.lang.String schema, java.lang.String table, java.lang.String column) Returns whether column is used by a spatial index (Gist) or not.

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgisDSMetadata

public PostgisDSMetadata(PostgisDSConnection conn)

Method Detail

getDatasetNames

public java.lang.String[] getDatasetNames()

Specified by:

getDatasetNames in interface DataStoreMetadata

getExtents

public com.vividsolutions.jts.geom.Envelope getExtents(java.lang.String datasetName,
                                              java.lang.String attributeName)

Specified by:

getExtents in interface DataStoreMetadata

Parameters:

datasetName - table name (optionally prefixed by a schema name)

attributeName - column containing the Geometry

Returns:

May be null if the extents cannot be determined

getSRID

@Deprecated
public SpatialReferenceSystemID getSRID(java.lang.String tableName,
                                          java.lang.String colName)
                                 throws java.sql.SQLException

Deprecated.

Throws:

java.sql.SQLException

getGeometryAttributeNames

@Deprecated
public java.lang.String[] getGeometryAttributeNames(java.lang.String datasetName)

Deprecated.

getGeometryAttributes

public java.util.List<GeometryColumn> getGeometryAttributes(java.lang.String datasetName)

Specified by:

getGeometryAttributes in interface DataStoreMetadata

getPrimaryKeyColumns

public java.util.List<PrimaryKeyColumn> getPrimaryKeyColumns(java.lang.String datasetName)

Returns PRIMARY KEY columns of dataset names.

Specified by:

getPrimaryKeyColumns in interface DataStoreMetadata

Parameters:

datasetName - name of the table (optionally prefixed by the schema name)

Returns:

the list of columns involved in the Primary Key (generally, a single column)

getColumnNames

public java.lang.String[] getColumnNames(java.lang.String datasetName)

isIndexed

public boolean isIndexed(java.lang.String schema,
                java.lang.String table,
                java.lang.String column)
                  throws java.sql.SQLException

Returns whether column is used by a spatial index (Gist) or not.

Throws:

java.sql.SQLException

getGeometryIndicesQuery

@Deprecated
public java.lang.String getGeometryIndicesQuery(java.lang.String schema,
                                                  java.lang.String table,
                                                  java.lang.String column)

Deprecated. initially thought that statistic used by ST_Estimated_Extent was depending on whether a spatial index exists or not. Finally, statistics and index seem to be two independant things

Use PostgreSQL metadata to know if schema.table.column is spatially indexed (or involved in a spatial index).