Specifies rational polynomial coefficient (RPC) parameters for a raster object.
Syntax
raster ST_SetRPCGeoreference(raster raster_obj, text rpc_json)Parameters
| Parameter | Description |
|---|---|
| raster_obj | The raster object. |
| rpc_json | The RPC description in the JSON format. |
Description
The following table describes the supported RPC parameters.
| Parameter | Description | Type |
|---|---|---|
| lineOff | The line offset. | float |
| sampOff | The sampling offset. | float |
| latOff | The latitude offset. | float |
| longOff | The longitude offset. | float |
| heightOff | The height offset. | float |
| lineScale | The line ratio. | float |
| sampScale | The sampling ratio. | float |
| latScale | The latitude ratio. | float |
| longScale | The longitude ratio. | float |
| heightScale | The height ratio. | float |
| lineDenCoeff | The number of coefficients for a line denominator. Valid values: 1 to 20. | float array |
| lineNumCoeff | The number of coefficients for a line numerator. Valid values: 1 to 20. | float array |
| sampNumCoeff | The number of coefficients for a sample numerator. Valid values: 1 to 20. | float array |
| sampDenCoeff | The number of coefficients for a sample denominator. Valid values: 1 to 20. | float array |
| errBias | The bias errors. The root-mean-square (RMS) bias errors in meters. These errors are
related to all points per horizontal axis in an image. Default value: -1.0.
|
float |
| errRandom | The random errors. The RMS random errors in meters. These errors are related to each
point per horizontal axis in an image. Default value: -1.0.
|
float |
Example:
SELECT ST_RPCGeoreference(ST_setRPCGeoreference(raster_obj, '{
"lineOff": 12800.00,
"sampOff": 4008.00,
"latOff": 55.02030000,
"longOff": 27.04780000,
"heightOff": 179.000,
"lineScale": 12800.00,
"sampScale": 4008.00,
"latScale": 0.12380000,
"longScale": 0.06850000,
"heightScale": 300.000,
"lineNumCoeff": [
-2.104832000000000E-03,
-1.642616000000000E-02,
-1.027459000000000E+00,
4.182002500000000E-03,
-1.902795200000000E-03,
1.614313300000000E-05,
4.786355800000000E-04,
-2.127866900000000E-04,
6.958830700000000E-03,
-2.260572200000000E-06,
-2.225955200000000E-07,
-3.746937200000000E-07,
4.648645700000000E-04,
-1.801288800000000E-08,
5.140758300000000E-06,
7.566147900000000E-04,
-5.452440900000000E-07,
1.394079900000000E-07,
-1.828159600000000E-05,
2.421558100000000E-09
],
"lineDenCoeff": [
1.000000000000000E+00,
-5.006651300000000E-04,
-1.457830900000000E-03,
6.037474400000000E-04,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00
],
"sampNumCoeff": [
1.000000000000000E+00,
-5.006651300000000E-04,
-1.457830900000000E-03,
6.037474400000000E-04,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00
],
"sampDenCoeff": [
1.000000000000000E+00,
-5.006651300000000E-04,
-1.457830900000000E-03,
6.037474400000000E-04,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00,
0.000000000000000E+00
]
}'))
FROM raster_table
WHERE id = 1;
------------------------------
{"lineOff":12800.0,"sampOff":4008.0,"latOff":55.0203,"longOff":27.0478,"heightOff":179.0,"lineScale":12800.0,"sampScale":4008.0,"latScale":0.1238,"longScale":0.0685,"heightScale":300.0,"errBias":-1.0,"errRandom":-1.0,"lineDenCoeff":[1.0,-0.00050066513,-0.0014578309,0.0006037474.
.4,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0],"lineNumCoeff":[-0.002104832,-0.01642616,-1.027459,0.0041820025,-0.0019027952,0.000016143133,0.00047863558,-0.00021278669,0.0069588307,-0.0000022605722,-2.2259552e-7,-3.7469372e-7,0.00046486457,-1.8012888e-8,0.0.
.000051407583,0.00075661479,-5.4524409e-7,1.3940799e-7,-0.000018281596,2.4215581e-9],"sampDenCoeff":[1.0,-0.00050066513,-0.0014578309,0.00060374744,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0],"sampNumCoeff":[1.0,-0.00050066513,-0.0014578309,0.00060374744,0.0.
.,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]}