Supported spheroids
Use spheroids that are supported by Db2® Spatial Extender.
select distinct substr(definition, posstr(definition,'SPHEROID'), 50)
from db2gse.st_coordinate_systems where organization_coordsys_id < 500000| Name | Semi-major axis | Inverse flattening |
|---|---|---|
| Airy 1830 |
6377563.396 |
299.3249646 |
| Airy Modified 1849 |
6377340.189 |
299.3249646 |
| Average Terrestrial System 1977 |
6378135.0 |
298.257 |
| Australian National Spheroid |
6378160.0 |
298.25 |
| Bessel 1841 |
6377397.155 |
299.1528128 |
| Bessel Modified |
6377492.018 |
299.1528128 |
| Bessel Namibia |
6377483.865 |
299.1528128 |
| Clarke 1858 |
6378293.639 |
294.260676369 |
| Clarke 1866 |
6378206.4 |
294.9786982 |
| Clarke 1866 (Michigan) |
6378450.047 |
294.978684677 |
| Clarke 1880 |
6378249.138 |
293.466307656 |
| Clarke 1880 (Arc) |
6378249.145 |
293.466307656 |
| Clarke 1880 (Benoit) |
6378300.79 |
293.466234571 |
| Clarke 1880 (IGN) |
6378249.2 |
293.46602 |
| Clarke 1880 (RGS) |
6378249.145 |
293.465 |
| Clarke 1880 (SGA 1922) |
6378249.2 |
293.46598 |
| Everest (1830 Definition) |
6377299.36 |
300.8017 |
| Everest 1830 Modified |
6377304.063 |
300.8017 |
| Everest Adjustment 1937 |
6377276.345 |
300.8017 |
| Everest 1830 (1962 Definition) |
6377301.243 |
300.8017255 |
| Everest 1830 (1967 Definition) |
6377298.556 |
300.8017 |
| Everest 1830 (1975 Definition) |
6377299.151 |
300.8017255 |
| Everest 1969 Modified |
6377295.664 |
300.8017 |
| Fischer 1960 |
6378166.0 |
298.3 |
| Fischer 1968 |
6378150 .0 |
298.3 |
| Modified Fischer |
6378155 .0 |
298.3 |
| GEM 10C |
6378137.0 |
298.257222101 |
| GRS 1967 |
6378160.0 |
298.247167427 |
| GRS 1967 Truncated |
6378160.0 |
298.25 |
| GRS 1980 |
6378137.0 |
298.257222101 |
| Helmert 1906 |
6378200.0 |
298.3 |
| Hough 1960 |
6378270.0 |
297.0 |
| Indonesian National Spheroid |
6378160.0 |
298.247 |
| International 1924 |
6378388.0 |
297.0 |
| International 1967 |
6378160.0 |
298.25 |
| Krassowsky 1940 |
6378245.0 |
298.3 |
| NWL 9D |
6378145.0 |
298.25 |
| NWL 10D |
6378135.0 |
298.26 |
| OSU 86F |
6378136.2 |
298.25722 |
| OSU 91A |
6378136.3 |
298.25722 |
| Plessis 1817 |
6376523.0 |
308.64 |
| Sphere |
6371000.0 |
0.0 |
| Sphere (ArcInfo) |
6370997.0 |
0.0 |
| Struve 1860 |
6378298.3 |
294.73 |
| Walbeck |
6376896.0 |
302.78 |
| War Office |
6378300.0 |
296.0 |
| WGS 1966 |
6378145.0 |
298.25 |
| WGS 1972 |
6378135.0 |
298.26 |
| WGS 1984 |
6378137.0 |
298.257223563 |