ST_SetRPCGeoreference - PolarDB - Alibaba Cloud ドキュメントセンター

ラスターオブジェクトの有理多項式係数 (RPC) パラメーターを指定します。

構文

raster ST_SetRPCGeoreference(raster raster_obj, text rpc_json)

パラメーター

パラメーター	説明
raster_obj	ラスターオブジェクト
rpc_json	JSON形式のRPC記述。

説明

次の表に、サポートされるRPCパラメーターを示します。

パラメーター	説明	データ型
lineOff	ラインオフセット。	float
sampOff	サンプリングオフセット。	float
latOff	緯度オフセット。	float
longOff	経度オフセット。	float
heightOff	高さオフセット。	float
lineScale	ライン比。	float
sampScale	サンプリング比。	float
latScale	緯度比。	float
longScale	経度比。	float
heightScale	高さの比率。	float
lineDenCoeff	ライン分母の係数の数。有効な値: 1 ~ 20。	float array
lineNumCoeff	行分子の係数の数。有効な値: 1 ~ 20。	float array
sampNumCoeff	サンプル分子の係数の数。有効な値: 1 ~ 20。	float array
sampDenCoeff	サンプル分母の係数の数。有効な値: 1 ~ 20。	float array
errBias	バイアスエラー。二乗平均平方根 (RMS) バイアス誤差 (メートル単位) 。これらの誤差は、画像内の水平軸ごとのすべての点に関連する。デフォルト値: `-1.0`	float
errRandom	ランダムエラー。 RMSランダムエラー (メートル単位) 。これらの誤差は、画像内の水平軸ごとの各点に関連する。デフォルト値: `-1.0`	float

例：

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