Supported linear units
Use linear units that are supported by Db2® Spatial Extender.
Table 1 shows a sample of the available linear
units. For a complete list, use the following query:
select substr(unit_name,1,20) as unit_name, conversion_factor as factor, substr(description,1,35)
from db2gse.st_units_of_measure where unit_type = 'LINEAR' order by unit_name| Unit | Conversion factor |
|---|---|
|
Meter |
1.0 |
|
Foot (International) |
0.3048 |
|
U.S. foot |
12/39.37 |
|
Modified American foot |
12.0004584/39.37 |
|
Clarke's foot |
12/39.370432 |
|
Indian foot |
12/39.370141 |
|
Link |
7.92/39.370432 |
|
Link (Benoit) |
7.92/39.370113 |
|
Link (Sears) |
7.92/39.370147 |
|
Mile |
1609.344 |
|
Chain (Benoit) |
792/39.370113 |
|
Chain (Sears) |
792/39.370147 |
|
Yard (Indian) |
36/39.370141 |
|
Yard (Sears) |
36/39.370147 |
|
Fathom |
1.8288 |
| Mile (statute mile) | 1609.344 |
|
Nautical mile |
1852.0 |