Using Interactive SQL, start and connect to the sample database (demo.db) as user DBA, or as a member of the SYS_SPATIAL_ADMIN_ROLE group.

The sample database is located in %SQLANYSAMP12%.

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.

See sa_install_feature system procedure and CREATE SPATIAL REFERENCE SYSTEM statement.

To determine the units of measure installed in your database, execute the following query in Interactive SQL:

SELECT * FROM ST_UNITS_OF_MEASURE;

See ST_UNITS_OF_MEASURE consolidated view.

To determine the spatial reference systems installed in your database, you can look in the Spatial Reference Systems folder in Sybase Central, or execute the following query in Interactive SQL:

SELECT * FROM ST_SPATIAL_REFERENCE_SYSTEMS;

See ST_SPATIAL_REFERENCE_SYSTEMS consolidated view.

Proceed to Lesson 2: Download the ESRI shapefile data.