sa_install_feature(  feat_name )

You can query the feat_name value to see what will be installed. For example, the following query returns the units of measure that would be installed for st_geometry_predefined_uom.

SELECT * FROM st_geometry_predefined_uom( 'CREATE' );

The previous example also shows you parameter names so you can query for specific values using a WHERE clause. For example, the following statement queries the unit_name parameter for the chain unit of measure:

SELECT * FROM st_geometry_predefined_uom( 'CREATE' ) WHERE unit_name='chain';

The following returns all units of measure that are based on foot:

SELECT * FROM st_geometry_predefined_uom() WHERE unit_name LIKE '%foot%';

Use the following query to find the spatial reference systems that would be installed:

SELECT * FROM st_geometry_predefined_srs();

The following statement queries for a spatial reference system by organization and organization_coordsys_id:

SELECT * FROM st_geometry_predefined_srs() WHERE organization='EPSG' AND organization_coordsys_id=2295;

For st_geometry_predefined_uom and st_geometry_predefined_srs, you must have the MANAGE ANY SPATIAL OBJECT system privilege.

For st_geometry_compat_func, you must have the MANAGE ANY OBJECT PRIVILEGE, CREATE ANY PROCEDURE, and SELECT ANY TABLE system privileges.

For sa_install_feature, you must have the MANAGE ANY SPATIAL OBJECT system privilege.

• Spatial reference systems (SRS) and Spatial reference identifiers (SRID)
• Units of measure
• Spatial compatibility functions

The following statement installs all of the predefined units of measure that are not installed by default in a new database:

CALL sa_install_feature( 'st_geometry_predefined_uom' );

The following statement installs a set of spatial compatibility functions which can be used as an alternative to the spatial methods:

CALL sa_install_feature( 'st_geometry_compat_func' );