The st_units_of_measure table
The st_units_of_measure table stores data about units of measure. The definitions of units of measure are used to convert measurements to different units of measure.
Include the appropriate value from the unit_name column when you calculate distance or area for geometries that have angular units.
| unit_name | unit_type | conversion_factor | description |
|---|---|---|---|
| meter | linear | 1 | 9001 - International meter |
| foot | linear | 0.3048 | 9002 - International foot |
| foot_us | linear | 0.3048006096012192 | 9003 - US survey foot |
| foot_clarke | linear | 0.3047972650 | 9005 - Clarke's foot |
| fathom | linear | 1.8288 | 9014 - Fathom |
| nautical_mile | linear | 1852 | 9030 - International nautical mile |
| meter_german | linear | 1.000001359650 | 9031 - German legal meter |
| chain_us | linear | 20.11684023368047 | 9033 - US survey chain |
| link_us | linear | 20.11684023368047 | 9034 - US survey link |
| mile_us | linear | 20.11684023368047 | 9035 - US survey mile |
| kilometer | linear | 1000 | 9036 - Kilometer |
| yard_clarke | linear | 0.914391795 | 9037 - Yard (Clarke) |
| chain_clarke | linear | 20.11661949 | 9038 - Chain (Clarke) |
| link_clarke | linear | 0.2011661949 | 9039 - Link (Clarke's ratio) |
| yard_sears | linear | 0.2011661949 | 9040 - Yard (Sears) |
| foot_sears | linear | 0.3047994715386762 | 9041 - Sear's foot |
| chain_sears | linear | 20.11676512155263 | 9042 - Chain (Sears) |
| link_sears | linear | 0.2011676512155263 | 9043 - Link (Sears) |
| yard_benoit_1895_a | linear | 0.9143992 | 9050 - Yard (Benoit 1895 A) |
| foot_benoit_1895_a | linear | 0.3047997333333333 | 9051 - Foot (Benoit 1895 A) |
| chain_benoit_1895_a | linear | 20.1167824 | 9052 - Chain (Benoit 1895 A) |
| link_benoit_1895_a | linear | 0.201167824 | 9043 - Link (Sears) |
| yard_benoit_1895_a | linear | 0.9143992 | 9050 - Yard (Benoit 1895 A) |
| foot_benoit_1895_a | linear | 0.3047997333333333 | 9051 - Foot (Benoit 1895 A) |
| chain_benoit_1895_a | linear | 20.1167824 | 9052 - Chain (Benoit 1895 A) |
| link_benoit_1895_a | linear | 0.201167824 | 9053 - Link (Benoit 1895 A) |
| yard_benoit_1895_b | linear | 0.9143992042898124 | 9060 - Yard (Benoit 1895 B) |
| foot_benoit_1895_b | linear | 0.3047997347632708 | 9061 - Foot (Benoit 1895 B) |
| chain_benoit_1895_b | linear | 20.11678249437587 | 9062 - Chain (Benoit 1895 B) |
| link_benoit_1895_b | linear | 0.2011678249437587 | 9063 - Link (Benoit 1895 B) |
| foot_1865 | linear | 0.3048008333333334 | 9070 - Foot (1865) |
| foot_indian | linear | 0.3047995102481469 | 9080 - Indian geodetic foot |
| foot_indian_1937 | linear | 0.30479841 | 9081 - Indian foot (1937) |
| foot_indian_1962 | linear | 0.3047996 | 9082 - Indian foot (1962) |
| foot_indian_1975 | linear | 0.3047995 | 9083 - Indian foot (1975) |
| yard_indian | linear | 0.9143985307444408 | 9084 - Indian yard |
| yard_indian_1937 | linear | 0.91439523 | 9085 - Indian yard (1937) |
| yard_indian_1962 | linear | 0.9143988 | 9086 - Indian yard (1962) |
| yard_indian_1975 | linear | 0.9143985 | 9087 - Indian yard (1975) |
| radian | angular | 1 | 9101 - Radian |
| degree | angular | 0.0174532925199433 | 9102 - Degree |
| minute | angular | 0.0002908882086657216 | 9103 - Arc-minute |
| second | angular | 4.84813681109536E-06 | 9104 - Arc-second |
| grad | angular | 0.01570796326794897 | 9105 - Grad (angle subtended by 1/400 circle) |
| gon | angular | 0.01570796326794897 | 9106 - Gon (angle subtended by 1/400 circle) |
| microradian | angular | 1E-06 | 9109 - Microradian (1e-6 radian) |
| minute_centesimal | angular | 0.0001570796326794897 | 9112 - Centesimal minute (1/100th Gon (Grad)) |
| second_centesimal | angular | 1.570796326794897E-06 | 9113 - Centesimal second(1/10000th Gon (Grad)) |
| mil_6400 | angular | 0.0009817477042468104 | 9114 - Mil (angle subtended by 1/6400 circle) |