Catalog views

Use spatial catalog views to obtain useful information about your spatial data.

SYSGEO.ST_COORDINATE_SYSTEMS catalog view
Use the SYSGEO.ST_COORDINATE_SYSTEMS catalog view to retrieve information about coordinate systems.
SYSGEO.ST_GEOMETRY_COLUMNS catalog view
Use the SYSGEO.ST_GEOMETRY_COLUMNS catalog view to find information about all spatial columns in all tables that contain spatial data in the database.
SYSGEO.ST_SIZINGS catalog view
Use the SYSGEO.ST_SIZINGS catalog view to retrieve information about supported variables and their maximum length.
SYSGEO.ST_SPATIAL_REFERENCE_SYSTEMS catalog view
Use the SYSGEO.ST_SPATIAL_REFERENCE_SYSTEMS catalog view to retrieve information about registered spatial reference systems.
SYSGEO.ST_UNITS_OF_MEASURE catalog view
Use the SYSGEO.ST_UNITS_OF_MEASURE catalog view to determine what units of measure you can choose from.

Parent topic: Db2 Spatial Analytics