Lesson 1: Install additional units of measure and spatial reference systems

This lesson shows you how to use the sa_install_feature system procedure to install many predefined units of measure and spatial reference systems you will need later in this tutorial.

Prerequisites

This lesson assumes you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Experimenting with the spatial features.

Task

Using Interactive SQL, start and connect to the sample database (iqdemo.db).

The sample database is located in "%ALLUSERPROFILE%"\SybaseIQ\demo.
Execute the following statement in Interactive SQL:
```
CALL sa_install_feature( 'st_geometry_predefined_srs' );
```
When the statement finishes, the additional units of measure and spatial reference systems have been installed.
To determine the units of measure installed in your database, execute the following query in Interactive SQL:
```
SELECT * FROM ST_UNITS_OF_MEASURE;
```
To determine the spatial reference systems installed in your database, execute the following query in Interactive SQL:
```
SELECT * FROM ST_SPATIAL_REFERENCE_SYSTEMS;
```

The list of installed spatial reference systems is returned.