Spatial reference systems supplied with IBM Spatial Support for Db2 for z/OS

The spatial reference system converts the coordinate data to positive integers.

IBM® Spatial Support for Db2 for z/OS® provides the spatial reference systems that are shown in the table below, along with the coordinate system on which each spatial reference system is based and the offset values and scale factors that IBM Spatial Support for Db2 for z/OS uses to convert the coordinate data to positive integers. You can find information about these spatial reference systems in the DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS catalog view.

If you are working with decimal-degrees, the offset values and scale factors for the default spatial reference systems support the full range of latitude-longitude coordinates and preserve 6 decimal positions, equivalent to approximately 10 cm.

If none of the default spatial reference systems meet your needs, you can create a new spatial reference system.

Table 1. Spatial reference systems provided with IBM Spatial Support for Db2 for z/OS
Spatial reference system	SRS ID	Coordinate system	Offset values	Scale factors	When to use
DEFAULT _SRS	0	None	xOffset = 0 yOffset = 0 zOffset = 0 mOffset = 0	xScale = 1 yScale = 1 zScale = 1 mScale = 1	You can select this system when your data is independent of a coordinate system or you cannot or do not need to specify one.
NAD83_ SRS_1	1	GCS_NORTH _AMERICAN _1983	xOffset = –180 yOffset = –90 zOffset = 0 mOffset = 0	xScale = 1,000,000 yScale = 1,000,000 zScale = 1 mScale = 1	You can select this spatial reference system if you plan to use the U.S. sample data that was previously available from Db2 Spatial Extender. If the coordinate data that you are working with was collected after 1983, use this system instead of NAD27_SRS_1002.
NAD27_ SRS_1002	1002	GCS_NORTH _AMERICAN _1927	xOffset = –180 yOffset = –90 zOffset = 0 mOffset = 0	xScale = 5,965,232 yScale = 5,965,232 zScale = 1 mScale = 1	You can select this spatial reference system if you plan to use the U.S. sample data that was previously available from Db2 Spatial Extender. If the coordinate data that you are working with was collected before 1983, use this system instead of NAD83_SRS_1. This system provides a greater degree of precision than the other default spatial reference systems.
WGS84_ SRS_1003	1003	GCS_WGS _1984	xOffset = –180 yOffset = –90 zOffset = 0 mOffset = 0	xScale = 5,965,232 yScale = 5,965,232 zScale = 1 mScale = 1	You can select this spatial reference system if you are working with data outside the U.S. (This system handles worldwide coordinates.)
DE_HDN _SRS_1004	1004	GCS _DEUTSCHES _HAUPTDREI ECKSNETZ	xOffset = –180 yOffset = –90 zOffset = 0 mOffset = 0	xScale = 5,965,232 yScale = 5,965,232 zScale = 1 mScale = 1	This spatial reference system is based on a coordinate system for German addresses.