A LONG VARCHAR parameter that identifies the feature to install. The default is NULL. The supported feature names are:
Installs predefined units of measure that are not installed by default in new databases.
Installs predefined spatial reference systems and units of measure that are not installed by default in new databases.
Installs a set of spatial compatibility functions. These functions can be used as an alternative to the spatial methods.
Feature name definitions are provided in the st_geometry_config.tgz file located in the %SQLANY16%\scripts directory. If the file is removed and you attempt to install features that are dependent on the file, an error is returned.
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;