Package mil.nga.geopackage.srs

Class SpatialReferenceSystemDao

java.lang.Object

com.j256.ormlite.dao.BaseDaoImpl<T,ID>

mil.nga.geopackage.db.GeoPackageDao<SpatialReferenceSystem,Long>

mil.nga.geopackage.srs.SpatialReferenceSystemDao

All Implemented Interfaces:

CloseableIterable<SpatialReferenceSystem>, Dao<SpatialReferenceSystem,Long>, Iterable<SpatialReferenceSystem>

public class SpatialReferenceSystemDao
extends GeoPackageDao<SpatialReferenceSystem,Long>

Spatial Reference System Data Access Object

Author:

osbornb

Nested Class Summary

Nested classes/interfaces inherited from interface com.j256.ormlite.dao.Dao

Dao.CreateOrUpdateStatus, Dao.DaoObserver

Field Summary

Fields inherited from class mil.nga.geopackage.db.GeoPackageDao

db

Fields inherited from class com.j256.ormlite.dao.BaseDaoImpl

connectionSource, constructor, databaseType, dataClass, lastIterator, objectFactory, statementExecutor, tableConfig, tableInfo

Constructor Summary

Constructors

Constructor	Description
SpatialReferenceSystemDao(ConnectionSource connectionSource, Class<SpatialReferenceSystem> dataClass)	Constructor, required by ORMLite

Method Summary

Modifier and Type	Method	Description
static SpatialReferenceSystemDao	create(GeoPackageCoreConnection db)	Create the DAO
static SpatialReferenceSystemDao	create(GeoPackageCore geoPackage)	Create the DAO
int	create(SpatialReferenceSystem srs)
SpatialReferenceSystem	createIfNotExists(SpatialReferenceSystem data)
Dao.CreateOrUpdateStatus	createOrUpdate(SpatialReferenceSystem data)
SpatialReferenceSystem	createUndefinedCartesian()	Creates the required Undefined Cartesian Spatial Reference System (spec Requirement 11)
SpatialReferenceSystem	createUndefinedGeographic()	Creates the required Undefined Geographic Spatial Reference System (spec Requirement 11)
SpatialReferenceSystem	createWebMercator()	Creates the Web Mercator Spatial Reference System if it does not already exist
SpatialReferenceSystem	createWgs84()	Creates the required EPSG WGS84 Spatial Reference System (spec Requirement 11)
SpatialReferenceSystem	createWgs84Geographical3D()	Creates the required EPSG WGS84 Geographical 3D Spatial Reference System
int	deleteByIdCascade(Long id)	Delete a Spatial Reference System by id, cascading
int	deleteCascade(PreparedQuery<SpatialReferenceSystem> preparedDelete)	Delete the Spatial Reference Systems matching the prepared query, cascading
int	deleteCascade(Collection<SpatialReferenceSystem> srsCollection)	Delete the collection of Spatial Reference Systems, cascading
int	deleteCascade(SpatialReferenceSystem srs)	Delete the Spatial Reference System, cascading
int	deleteIdsCascade(Collection<Long> idCollection)	Delete the Spatial Reference Systems with the provided ids, cascading
String	getDefinition_12_063(long srsId)	Query to get the definition 12 063 value if the extension exists
Double	getEpoch(long srsId)	Query to get the epoch value if the extension exists
SpatialReferenceSystem	getOrCreate(Projection projection)	Get or Create the Spatial Reference System from the projection
SpatialReferenceSystem	getOrCreateCode(String organization, long coordsysId)	Get or Create the Spatial Reference System for the provided organization and id
SpatialReferenceSystem	getOrCreateFromEpsg(long epsg)	Get or Create the Spatial Reference System for the provided epsg
boolean	hasDefinition_12_063()	Determine if the SRS table contains the extension definition 12 063 column for CRS WKT
boolean	hasEpoch()	Determine if the SRS table contains the extension epoch column for CRS WKT
List<SpatialReferenceSystem>	query(PreparedQuery<SpatialReferenceSystem> preparedQuery)
SpatialReferenceSystem	query(Projection projection)	Query for the projection
List<SpatialReferenceSystem>	queryForAll()
List<SpatialReferenceSystem>	queryForEq(String fieldName, Object value)
List<SpatialReferenceSystem>	queryForFieldValues(Map<String,Object> fieldValues)
List<SpatialReferenceSystem>	queryForFieldValuesArgs(Map<String,Object> fieldValues)
SpatialReferenceSystem	queryForFirst(PreparedQuery<SpatialReferenceSystem> preparedQuery)
SpatialReferenceSystem	queryForId(Long id)
List<SpatialReferenceSystem>	queryForMatching(SpatialReferenceSystem matchObj)
List<SpatialReferenceSystem>	queryForMatchingArgs(SpatialReferenceSystem matchObj)
SpatialReferenceSystem	queryForOrganizationCoordsysId(String organization, long organizationCoordsysId)	Query for the organization coordsys id
SpatialReferenceSystem	queryForSameId(SpatialReferenceSystem data)
void	setCrsWktExtension(CrsWktExtension crsWktExtension)	Set the CRS WKT Extension
void	setExtension(Collection<SpatialReferenceSystem> srsList)	Query and set the values in the srs objects if the extension exists
void	setExtension(SpatialReferenceSystem srs)	Query and set the values in the srs object if the extension exists
static void	setExtensionValues(GeoPackageCoreConnection db, SpatialReferenceSystem srs)	Set extension values into the spatial reference system
static void	setExtensionValues(GeoPackageCore geoPackage, SpatialReferenceSystem srs)	Set extension values into the spatial reference system
int	update(SpatialReferenceSystem data)
void	updateDefinition_12_063(long srsId, String definition)	Update the definition 12 063 in the database if the extension exists
void	updateEpoch(long srsId, Double epoch)	Update the epoch in the database if the extension exists
void	updateExtension(SpatialReferenceSystem srs)	Update the extension if exists

Methods inherited from class mil.nga.geopackage.db.GeoPackageDao

createDao, createDao, createDao, dropTable, getDatabase, isTable, isTableExists, isTableOrView, isView, setDatabase, tableExists, tableOrViewExists, verifyExists, viewExists

Methods inherited from class com.j256.ormlite.dao.BaseDaoImpl

assignEmptyForeignCollection, callBatchTasks, checkForInitialized, clearAllInternalObjectCaches, clearObjectCache, closeableIterator, closeLastIterator, commit, countOf, countOf, create, createObjectInstance, delete, delete, delete, deleteBuilder, deleteById, deleteIds, endThreadConnection, executeRaw, executeRawNoArgs, extractId, findForeignFieldType, getConnectionSource, getDataClass, getEmptyForeignCollection, getObjectCache, getRawRowMapper, getSelectStarRowMapper, getTableConfig, getTableInfo, getTableName, getWrappedIterable, getWrappedIterable, idExists, initialize, isAutoCommit, isUpdatable, iterator, iterator, iterator, iterator, mapSelectStarRow, notifyChanges, objectsEqual, objectToString, queryBuilder, queryForFirst, queryRaw, queryRaw, queryRaw, queryRaw, queryRaw, queryRawValue, refresh, registerObserver, rollBack, setAutoCommit, setConnectionSource, setObjectCache, setObjectCache, setObjectFactory, setTableConfig, startThreadConnection, unregisterObserver, update, updateBuilder, updateId, updateRaw

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Constructor Detail

SpatialReferenceSystemDao

public SpatialReferenceSystemDao(ConnectionSource connectionSource,
                                 Class<SpatialReferenceSystem> dataClass)
                          throws SQLException

Constructor, required by ORMLite

Parameters:

connectionSource - connection source

dataClass - data class

Throws:

SQLException - upon creation failure

Method Detail

create

public static SpatialReferenceSystemDao create(GeoPackageCore geoPackage)

Create the DAO

Parameters:

geoPackage - GeoPackage

Returns:

dao

Since:

4.0.0

create

public static SpatialReferenceSystemDao create(GeoPackageCoreConnection db)

Create the DAO

Parameters:

db - database connection

Returns:

dao

Since:

4.0.0

setExtensionValues

public static void setExtensionValues(GeoPackageCore geoPackage,
                                      SpatialReferenceSystem srs)

Set extension values into the spatial reference system

Parameters:

geoPackage - GeoPackage

srs - spatial reference system

setExtensionValues

public static void setExtensionValues(GeoPackageCoreConnection db,
                                      SpatialReferenceSystem srs)

Set extension values into the spatial reference system

Parameters:

db - database connection

srs - spatial reference system

setCrsWktExtension

public void setCrsWktExtension(CrsWktExtension crsWktExtension)

Set the CRS WKT Extension

Parameters:

crsWktExtension - CRS WKT Extension

Since:

1.1.8

hasDefinition_12_063

public boolean hasDefinition_12_063()

Determine if the SRS table contains the extension definition 12 063 column for CRS WKT

Returns:

true if has extension

Since:

1.2.1

hasEpoch

public boolean hasEpoch()

Determine if the SRS table contains the extension epoch column for CRS WKT

Returns:

true if has extension

Since:

6.6.0

createWgs84

public SpatialReferenceSystem createWgs84()
                                   throws SQLException

Creates the required EPSG WGS84 Spatial Reference System (spec Requirement 11)

Returns:

spatial reference system

Throws:

SQLException - upon creation failure

createUndefinedCartesian

public SpatialReferenceSystem createUndefinedCartesian()
                                                throws SQLException

Creates the required Undefined Cartesian Spatial Reference System (spec Requirement 11)

Returns:

spatial reference system

Throws:

SQLException - upon creation failure

createUndefinedGeographic

public SpatialReferenceSystem createUndefinedGeographic()
                                                 throws SQLException

Creates the required Undefined Geographic Spatial Reference System (spec Requirement 11)

Returns:

spatial reference system

Throws:

SQLException - upon creation failure

createWebMercator

public SpatialReferenceSystem createWebMercator()
                                         throws SQLException

Creates the Web Mercator Spatial Reference System if it does not already exist

Returns:

spatial reference system

Throws:

SQLException - upon creation failure

createWgs84Geographical3D

public SpatialReferenceSystem createWgs84Geographical3D()
                                                 throws SQLException

Creates the required EPSG WGS84 Geographical 3D Spatial Reference System

Returns:

spatial reference system

Throws:

SQLException - upon creation failure

Since:

1.2.1

getDefinition_12_063

public String getDefinition_12_063(long srsId)

Query to get the definition 12 063 value if the extension exists

Parameters:

srsId - srs id

Returns:

definition or null

Since:

1.2.1

getEpoch

public Double getEpoch(long srsId)

Query to get the epoch value if the extension exists

Parameters:

srsId - srs id

Returns:

epoch or null

Since:

6.6.0

setExtension

public void setExtension(SpatialReferenceSystem srs)

Query and set the values in the srs object if the extension exists

Parameters:

srs - spatial reference system

Since:

6.6.0

setExtension

public void setExtension(Collection<SpatialReferenceSystem> srsList)

Query and set the values in the srs objects if the extension exists

Parameters:

srsList - srs list

Since:

6.6.0

updateDefinition_12_063

public void updateDefinition_12_063(long srsId,
                                    String definition)

Update the definition 12 063 in the database if the extension exists

Parameters:

srsId - srs id

definition - definition

Since:

1.2.1

updateEpoch

public void updateEpoch(long srsId,
                        Double epoch)

Update the epoch in the database if the extension exists

Parameters:

srsId - srs id

epoch - epoch

Since:

6.6.0

updateExtension

public void updateExtension(SpatialReferenceSystem srs)

Update the extension if exists

Parameters:

srs - srs

Since:

6.6.0

queryForId

public SpatialReferenceSystem queryForId(Long id)
                                  throws SQLException

Specified by:

queryForId in interface Dao<SpatialReferenceSystem,Long>

Overrides:

queryForId in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

queryForFirst

public SpatialReferenceSystem queryForFirst(PreparedQuery<SpatialReferenceSystem> preparedQuery)
                                     throws SQLException

Specified by:

queryForFirst in interface Dao<SpatialReferenceSystem,Long>

Overrides:

queryForFirst in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

queryForAll

public List<SpatialReferenceSystem> queryForAll()
                                         throws SQLException

Specified by:

queryForAll in interface Dao<SpatialReferenceSystem,Long>

Overrides:

queryForAll in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

queryForEq

public List<SpatialReferenceSystem> queryForEq(String fieldName,
                                               Object value)
                                        throws SQLException

Specified by:

queryForEq in interface Dao<SpatialReferenceSystem,Long>

Overrides:

queryForEq in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

query

public List<SpatialReferenceSystem> query(PreparedQuery<SpatialReferenceSystem> preparedQuery)
                                   throws SQLException

Specified by:

query in interface Dao<SpatialReferenceSystem,Long>

Overrides:

query in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

queryForMatching

public List<SpatialReferenceSystem> queryForMatching(SpatialReferenceSystem matchObj)
                                              throws SQLException

Specified by:

queryForMatching in interface Dao<SpatialReferenceSystem,Long>

Overrides:

queryForMatching in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

queryForMatchingArgs

public List<SpatialReferenceSystem> queryForMatchingArgs(SpatialReferenceSystem matchObj)
                                                  throws SQLException

Specified by:

queryForMatchingArgs in interface Dao<SpatialReferenceSystem,Long>

Overrides:

queryForMatchingArgs in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

queryForFieldValues

public List<SpatialReferenceSystem> queryForFieldValues(Map<String,Object> fieldValues)
                                                 throws SQLException

Specified by:

queryForFieldValues in interface Dao<SpatialReferenceSystem,Long>

Overrides:

queryForFieldValues in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

queryForFieldValuesArgs

public List<SpatialReferenceSystem> queryForFieldValuesArgs(Map<String,Object> fieldValues)
                                                     throws SQLException

Specified by:

queryForFieldValuesArgs in interface Dao<SpatialReferenceSystem,Long>

Overrides:

queryForFieldValuesArgs in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

queryForSameId

public SpatialReferenceSystem queryForSameId(SpatialReferenceSystem data)
                                      throws SQLException

Specified by:

queryForSameId in interface Dao<SpatialReferenceSystem,Long>

Overrides:

queryForSameId in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

create

public int create(SpatialReferenceSystem srs)
           throws SQLException

Specified by:

create in interface Dao<SpatialReferenceSystem,Long>

Overrides:

create in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

createIfNotExists

public SpatialReferenceSystem createIfNotExists(SpatialReferenceSystem data)
                                         throws SQLException

Specified by:

createIfNotExists in interface Dao<SpatialReferenceSystem,Long>

Overrides:

createIfNotExists in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

createOrUpdate

public Dao.CreateOrUpdateStatus createOrUpdate(SpatialReferenceSystem data)
                                        throws SQLException

Specified by:

createOrUpdate in interface Dao<SpatialReferenceSystem,Long>

Overrides:

createOrUpdate in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

update

public int update(SpatialReferenceSystem data)
           throws SQLException

Specified by:

update in interface Dao<SpatialReferenceSystem,Long>

Overrides:

update in class BaseDaoImpl<SpatialReferenceSystem,Long>

Throws:

SQLException

getOrCreateFromEpsg

public SpatialReferenceSystem getOrCreateFromEpsg(long epsg)
                                           throws SQLException

Get or Create the Spatial Reference System for the provided epsg

Parameters:

epsg - epsg

Returns:

srs

Throws:

SQLException - upon query or creation failure

Since:

1.2.0

getOrCreateCode

public SpatialReferenceSystem getOrCreateCode(String organization,
                                              long coordsysId)
                                       throws SQLException

Get or Create the Spatial Reference System for the provided organization and id

Parameters:

organization - organization

coordsysId - coordsys id

Returns:

srs

Throws:

SQLException - upon query or creation failure

Since:

1.3.0

getOrCreate

public SpatialReferenceSystem getOrCreate(Projection projection)
                                   throws SQLException

Get or Create the Spatial Reference System from the projection

Parameters:

projection - projection

Returns:

srs

Throws:

SQLException - upon query or creation failure

Since:

5.0.0

queryForOrganizationCoordsysId

public SpatialReferenceSystem queryForOrganizationCoordsysId(String organization,
                                                             long organizationCoordsysId)
                                                      throws SQLException

Query for the organization coordsys id

Parameters:

organization - organization

organizationCoordsysId - organization coordsys id

Returns:

srs

Throws:

SQLException - upon query failure

Since:

1.3.0

query

public SpatialReferenceSystem query(Projection projection)
                             throws SQLException

Query for the projection

Parameters:

projection - projection

Returns:

srs

Throws:

SQLException - upon query failure

Since:

5.0.0

deleteCascade

public int deleteCascade(SpatialReferenceSystem srs)
                  throws SQLException

Delete the Spatial Reference System, cascading

Parameters:

srs - spatial reference system

Returns:

deleted count

Throws:

SQLException - upon deletion failure

deleteCascade

public int deleteCascade(Collection<SpatialReferenceSystem> srsCollection)
                  throws SQLException

Delete the collection of Spatial Reference Systems, cascading

Parameters:

srsCollection - spatial reference system collection

Returns:

deleted count

Throws:

SQLException - upon deletion failure

deleteCascade

public int deleteCascade(PreparedQuery<SpatialReferenceSystem> preparedDelete)
                  throws SQLException

Delete the Spatial Reference Systems matching the prepared query, cascading

Parameters:

preparedDelete - prepared delete query

Returns:

deleted count

Throws:

SQLException - upon deletion failure

deleteByIdCascade

public int deleteByIdCascade(Long id)
                      throws SQLException

Delete a Spatial Reference System by id, cascading

Parameters:

id - id

Returns:

deleted count

Throws:

SQLException - upon deletion failure

deleteIdsCascade

public int deleteIdsCascade(Collection<Long> idCollection)
                     throws SQLException

Delete the Spatial Reference Systems with the provided ids, cascading

Parameters:

idCollection - id collection

Returns:

deleted count

Throws:

SQLException - upon deletion failure