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 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';

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;

DBA or be a member of the SYS_SPATIAL_ADMIN_ROLE group

• 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');