Obtains the related information about the rational polynomial coefficients (RPCs) of a raster object. If the specified raster object contains RPC information, a JSON string is returned. If the specified raster object does not contain RPC information, null is returned.

Syntax

text ST_RPCGeoreference(raster raster_obj)

Parameters

Parameter Description
raster_obj The raster object.

Description

The ST_RPCGeoreference function returns a JSON string that contains RPC parameters. This string describes the reference information about the RPC space. The following table describes the supported 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(raster_obj) 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]}