Supported map projections

Use map projections that are supported by Db2® Spatial Extender.

Table 1, Table 2, and Table 3 include samples of different projection types. For a complete list, use the following query:

with pos(id,proj) as (select organization_coordsys_id, posstr(definition, 'PROJECTION') from
                        db2gse.st_coordinate_systems) select distinct substr(definition, proj, 46) from 
                        db2gse.st_coordinate_systems cs, pos  where cs.organization_coordsys_id = pos.id and pos.proj > 0

Table 1. Cylindrical projections
Cylindrical projections	Pseudocylindrical projections
Behrmann	Craster parabolic
Cassini	Eckert I
Cylindrical equal area	Eckert II
Gall's stereographic	Eckert III
Gauss-Kruger	Eckert IV
Mercator	Eckert V
Miller cylindrical	Eckert VI
Plate-Carée	Mercator (Hotine) Mollweide
Times	Robinson
Transverse Mercator	Sinusoidal (Sansom-Flamsteed)
	Winkel I

Table 2. Conic projections
Conic projection	Conic projection
Albers conic equal-area	Polyconic
Bipolar oblique conformal conic	Two-point equidistant
Bonne	Hammer-Aitoff equal-area
Equidistant conic	Van der Grinten I
Lambert conformal conic

Table 3. Map projection parameters
Parameter	Description
central_meridian	The line of longitude chosen as the origin of x-coordinates.
scale_factor	Scale_factor is used generally to reduce the amount of distortion in a map projection.
standard_parallel_1	A line of latitude that has no distortion generally. Also used for latitude of true scale.
standard_parallel_2	A line of longitude that has no distortion generally.
longitude_of_center	The longitude that defines the center point of the map projection.
latitude_of_center	The latitude that defines the center point of the map projection.
longitude_of_origin	The longitude chosen as the origin of x-coordinates.
latitude_of_origin	The latitude chosen as the origin of y-coordinates.
false_easting	A value added to x-coordinates so that all x-coordinate values are positive.
false_northing	A value added to y-coordinates so that all y-coordinates are positive.
azimuth	The angle east of north that defines the center line of an oblique projection.
longitude_of_point_1	The longitude of the first point needed for a map projection.
latitude_of_point_1	The latitude of the first point needed for a map projection.
longitude_of_point_2	The longitude of the second point needed for a map projection.
latitude_of_point_2	The latitude of the second point needed for a map projection.
longitude_of_point_3	The longitude of the third point needed for a map projection.
latitude_of_point_3	The latitude of the third point needed for a map projection.
landsat_number	The number of a Landsat satellite.
path_number	The orbital path number for a particular satellite.
perspective_point_height	The height above the earth of the perspective point of the map projection.
fipszone	State Plane Coordinate System zone number.
zone	UTM zone number.