Supported prime meridians

Use prime meridians that are supported by Db2® Spatial Extender.

Table 1 shows the most frequently used prime meridians. For a complete list use the following query:
select distinct substr(definition, posstr(definition,'PRIMEM'), 50) 
     from db2gse.st_coordinate_systems where organization_coordsys_id < 500000

Table 1. Supported prime meridians
Location Coordinates

Greenwich

0° 0' 0"

Bern

7° 26' 22.5" E

Bogota

74° 4' 51.3" W

Brussels

4° 22' 4.71" E

Ferro

17° 40' 0" W

Jakarta

106° 48' 27.79" E

Lisbon

9° 7' 54.862" W

Madrid

3° 41' 16.58" W

Paris

2° 20' 14.025" E

Rome

12° 27' 8.4" E

Stockholm

18° 3' 29" E