Registering spatial columns
Spatial queries use the spatial reference system associated with the geometry data to construct the shapes for processing. Registering the spatial column improves the description to your data. It also improves query speed, because it allows the spatial reference system to be reused during processing.
Before you begin
- Ensure that your user ID holds the proper authorization to execute the procedure st_register_spatial_column for the specified spatial column.
About this task
When you register a spatial column, a spatial reference system, and implicitly a coordinate system definition, is associated with the column. Use the view SYSGEO.ST_GEOMETRY_COLUMNS to see spatial columns and their registrations.
It is good practice to use the same spatial reference system for all spatial data in a column. For example, some visualization tools that generate graphical displays for spatial data require that all data in a spatial column uses the same reference system.