ST_RPCGeoreference - PolarDB

擷取Raster對象的RPC（Rational Polynomial Coefficients）相關資訊。如果Raster對象具備RPC資訊，則返回一個JSON格式的字串；如果不具備RPC資訊，則返回NULL。

文法

text ST_RPCGeoreference(raster raster_obj)

參數

參數名稱	描述
raster_obj	Raster對象。

描述

ST_RPCGeoreference函數返回的RPC參數是基於JSON格式的字串，描述了RPC空間的參考資訊。支援的參數如下：

參數名稱	描述	類型
lineOff	線位移	float
sampOff	採樣位移	float
latOff	緯度位移	float
longOff	經度位移	float
heightOff	高程位移	float
lineScale	線比例	float
sampScale	採樣比例	float
latScale	緯度比例	float
longScale	經度比例	float
heightScale	高程比例	float
lineDenCoeff	線分母係數（20個）	float array
lineNumCoeff	線分子係數（20個）	float array
sampNumCoeff	採樣分子係數（20個）	float array
sampDenCoeff	採樣分母係數（20個）	float array
errBias	錯誤誤差。以米為單位的映像中所有點的水平軸的均方根偏差誤差，未知時為`-1.0`。	float
errRandom	隨機誤差。以米為單位的映像中每個點每水平軸的均方根隨機誤差，未知時為`-1.0`。	float

樣本

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]}