feat_name
A LONG VARCHAR parameter that identifies the feature to install. The supported feature names are:
Value
Description
st_geometry_predefined_uom
Installs predefined units of measure that are not installed by default in new databases.
st_geometry_predefined_srs
Installs predefined spatial reference systems and units of measure that are not installed by default in new databases.
st_geometry_compat_func
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 %SQLANY12%\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 dbo.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 dbo.st_geometry_predefined_uom('CREATE') WHERE unit_name='chain';
unit_name
unit_type
conversion_factor
...
chain
LINEAR
20.1168
...
The following returns all units of measure that are based on foot:
SELECT * FROM dbo.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 dbo.st_geometry_predefined_srs();
The following statement queries for a spatial reference system by organization and organization_coordsys_id:
SELECT * FROM dbo.st_geometry_predefined_srs() WHERE organization='EPSG' AND organization_coordsys_id=2295;
Syntax