Spatial reference systems supplied with Spatial Extender

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

Spatial Extender provides the spatial reference systems that are shown in Table 1, along with the coordinate system on which each spatial reference system is based and the offset values and scale factors that Spatial Extender 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. The Sample Spatial Map data and Geocoder Reference data is in decimal-degrees.

If you plan to use a geocoder which works only with U.S. addresses, ensure that you select or create a spatial reference system that handles U.S. coordinates, such as the GCS_NORTH_AMERICAN_1983 coordinate system. If you do not specify what coordinate system your spatial data should derive from, Spatial Extender uses the DEFAULT_SRS spatial reference system.

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 Spatial Extender
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 shipped with Spatial Extender and you want to use a larger scale than NAD83_SRS_4269. If the coordinate data that you are working with was collected after 1983, use this system instead of NAD27_SRS_1002.
NAD83_SRS_4269	4269	GCS_NORTH_AMERICAN_1983	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 shipped with 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 shipped with 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.)
WGS84_ SRS_4326	4326	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	GCSW _DEUTSCHE _HAUPTDRE IECKSNETZ	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.
BNG_SRS_27700	27700	BRITISH_NATIONAL_GRID	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 Great Britain.