Name
ID
Transformations
Coordinate system
OK
Cancel
Use this window to define a new spatial reference system for this database. A spatial reference system specifies how the spatial data will be scaled, translated, and projected from three dimensions onto two dimensions before it is stored in the database.
For more information on the relationship between a spatial reference system and a coordinate system, see the DB2 Spatial Extender User's Guide and Reference.
Name
ID
Transformations
Coordinate system
OK
Cancel
Name
Type a 1 to 64-character name for the new spatial reference system.
Restriction: This name must be unique among the spatial reference systems for this database. No two spatial reference systems in the database can have the same name.
ID
Type an integer for the identifier to be associated with this spatial reference system. This ID is used to associate spatial data columns with the transformations that you specify in this window.
Restriction: This identifier must be unique among the spatial reference systems for this database. No two spatial reference systems in the database can have the same identifier.
Transformations
Type in the offset and scale values that will be applied to the underlying coordinate system for this spatial reference system definition. For more information on the relationship between a spatial reference system, a coordinate system, and offsets and scales, see the DB2 Spatial Extender User's Guide and Reference.
You can supply offsets and scales for the X, Y, and Z dimensions of the system as well as for its linear reference measures. A linear reference measure represents a feature such as a mileage post along a road.
The offset for a dimension (or for the linear reference measure) is the amount by which that dimension in this particular spatial reference system is translated with respect to the origin of corresponding dimension (or linear measure) in the standard coordinate system on which this spatial reference system is based.
For example, if the standard coordinate system on which this spatial reference system is based has an origin of X=0, and you specify an offset of 3 for the X field for this spatial reference system, then all values in the X dimension of spatial data columns that use this spatial reference system will by offset by 3 units with respect to the standard coordinate system.
The default offset is zero (0).
The scale for a dimension is the factor by which coordinates for that dimension will be multiplied with respect to the coordinate system specified in the Coordinate system field. The X and Y dimensions must have the same scale factors. Therefore, you cannot specify a Y dimension or offset. If you type a scale for the X dimension, it is automatically applied to the Y dimension.
Coordinate system
Use this box to specify the standard coordinate system on which this new spatial reference system will be based. The standard coordinate system is used for mapping between a curved coordinate system and a planar coordinate system. It provides locale-specific information about how to project locations on the three-dimensional Earth using only a two-dimensional map.
Use one of these methods:
push button
to open a window in which you can browse for the coordinate system that you want.
The default is the name of the coordinate system that has an ID equal to 0.
