ST_SetRPCGeoreference - ApsaraDB RDS: Central de Documentação do Alibaba Cloud

Sintaxe

raster ST_SetRPCGeoreference(raster raster_obj, text rpc_json)

Parâmetros

Parâmetro	Descrição
`raster_obj`	O objeto raster.
`rpc_json`	Os parâmetros RPC no formato JSON.

Parâmetros RPC

Informe os campos a seguir no argumento rpc_json.

Parâmetro	Descrição	Tipo
`lineOff`	Deslocamento de linha.	float
`sampOff`	Deslocamento de amostragem.	float
`latOff`	Deslocamento de latitude.	float
`longOff`	Deslocamento de longitude.	float
`heightOff`	Deslocamento de altura.	float
`lineScale`	Escala de linha.	float
`sampScale`	Escala de amostragem.	float
`latScale`	Escala de latitude.	float
`longScale`	Escala de longitude.	float
`heightScale`	Escala de altura.	float
`lineDenCoeff`	Coeficientes do polinômio denominador de linha. Valores válidos: 1 a 20 coeficientes.	float array
`lineNumCoeff`	Coeficientes do polinômio numerador de linha. Valores válidos: 1 a 20 coeficientes.	float array
`sampNumCoeff`	Coeficientes do polinômio numerador de amostra. Valores válidos: 1 a 20 coeficientes.	float array
`sampDenCoeff`	Coeficientes do polinômio denominador de amostra. Valores válidos: 1 a 20 coeficientes.	float array
`errBias`	Erro de viés da raiz do erro quadrático médio (RMS) em metros, aplicado a todos os pontos por eixo horizontal. Valor padrão: `-1.0`.	float
`errRandom`	Erro aleatório RMS em metros, aplicado por ponto e por eixo horizontal. Valor padrão: `-1.0`.	float

Exemplo

O exemplo a seguir define parâmetros RPC em um objeto raster e os lê com ST_RPCGeoreference.

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;

Saída:

{"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.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]}