Spatial Structure

This chapter describes schema objects related to Tibero Spatial.

Tables

The following describes each table.

Table	Description
SPATIAL_REF_SYS_BASE	Stores metadata of Spatial Reference System used in a database.

SPATIAL_REF_SYS_BASE

Stores metadata of Spatial Reference System used in a database.

• Columns

Column	Data Type	Description
OWNER	VARCHAR(30)	Database user who adds Spatial Reference System.
SRID	INTEGER	ID of Spatial Reference System in a database.
AUTH_NAME	VARCHAR(256)	Standard name used in Spatial Reference System.
AUTH_SRID	NUMBER	Standard ID used in Spatial Reference System.
SRTEXT	VARCHAR(2000)	Well-known text expression for Spatial Reference System.
PROJ4TEXT	VARCHAR(2000)	Coordinate definition string expression of the proj4 library used for coordinate conversion.

• References

SPATIAL_REF_SYS

---

View

This section describes views associated with a metadata table of Spatial Reference System.

The following describes each view.

View	Description
ALL_GEOMETRY_COLUMNS	Contains metadata of all GEOMETRY columns which are registered in the database.
SPATIAL_REF_SYS	Contains Spatial Reference System information used in a database.
USER_GEOMETRY_COLUMNS	Contains metadata of a current user's GEOMETRY columns which are registered in the database.

ALL_GEOMETRY_COLUMNS

Contains metadata of all GEOMETRY columns which are registered in the database. This view is set according to the OGC standard.

• Columns

Column	Data Type	Description
F_TABLE_CATALOG	VARCHAR(64)	Name of a database that includes the GEOMETRY column.
F_TABLE_SCHEMA	VARCHAR(128)	Owner of a table that includes the GEOMETRY column.
F_TABLE_NAME	VARCHAR(128)	Name of a table that includes the GEOMETRY column.
F_GEOMETRY_COLUMN	VARCHAR(128)	GEOMETRY column name.
STORAGE_TYPE	VARCHAR(0)	Always NULL.
GEOMETRY_TYPE	NUMBER	Integer notation for the GEOMETRY type.
TYPE	VARCHAR (65532)	String that indicates the GEOMETRY type.
COORD_DIMENSION	NUMBER	GEOMETRY's dimension.
MAX_PPR	VARCHAR(0)	Always NULL.
SRID	NUMBER	Spatial Reference System ID of GEOMETRY.

• References

USER_GEOMETRY_COLUMNS

SPATIAL_REF_SYS

Contains Spatial Reference System information used in a database.

• Columns

All columns in the SPATIAL_REF_SYS_BASE table except for the OWNER column.

• References

SPATIAL_REF_SYS_BASE

USER_GEOMETRY_COLUMNS

Contains GEOMETRY columns of all tables owned by the current user.

• Columns

Same as in the ALL_GEOMETRY_COLUMNS view.

• References

ALL_GEOMETRY_COLUMNS

---

Procedures

This section describes procedures used to manage a metadata table of Spatial Reference System.

The following describes each procedure.

Procedure	Description
REGISTER_SRS	Registers Spatial Reference System metadata to the SPATIAL_REF_SYS_BASE table.
UNREGISTER_SRS	Unregisters Spatial Reference System metadata from the SPATIAL_REF_SYS_BASE table.

REGISTER_SRS

Registers Spatial Reference System metadata to the SPATIAL_REF_SYS_BASE table.

The following is the details.

• Prototype

EXEC REGISTER_SRS
(
        SRID       IN INTEGER,
        AUTH_NAME  IN VARCHAR2,
        AUTH_SRID  IN INTEGER,
        SRTEXT     IN VARCHAR2,
        PROJ4TEXT  IN VARCHAR2
);

• Parameters

Parameter	Description
SRID	ID of Spatial Reference System in a database.
AUTH_NAME	Standard name used in Spatial Reference System.
AUTH_SRID	Standard ID used in Spatial Reference System.
SRTEXT	Well-known text expression for Spatial Reference System.
PROJ4TEXT	Coordinate definition string expression of the proj4 library used for coordinate conversion.

UNREGISTER_SRS

Unregisters Spatial Reference System metadata from the SPATIAL_REF_SYS_BASE table.

The following is the details.

• Prototype

EXEC UNREGISTER_SRS
(
        AUTH_NAME  IN VARCHAR2
        AUTH_SRID  IN INTEGER
);

• Parameters

Parameter	Description
AUTH_NAME	Standard name used in Spatial Reference System.
AUTH_SRID	Standard ID used in Spatial Reference System.