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

Retorna os parâmetros de coeficiente polinomial racional (RPC) de um objeto raster como uma string JSON. Retorna null se o objeto raster não contiver informações de RPC.

Sintaxe

text ST_RPCGeoreference(raster raster_obj)

Parâmetros

Parâmetro	Descrição
`raster_obj`	O objeto raster.

Descrição

A função ST_RPCGeoreference retorna uma string JSON com os parâmetros RPC que descrevem o modelo de referência espacial do objeto raster. A tabela a seguir lista os campos da string JSON retornada.

Campo	Tipo	Descrição
`lineOff`	float	O deslocamento de linha.
`sampOff`	float	O deslocamento de amostragem.
`latOff`	float	O deslocamento de latitude.
`longOff`	float	O deslocamento de longitude.
`heightOff`	float	O deslocamento de altura.
`lineScale`	float	A razão de linha.
`sampScale`	float	A razão de amostragem.
`latScale`	float	A razão de latitude.
`longScale`	float	A razão de longitude.
`heightScale`	float	A razão de altura.
`lineDenCoeff`	float array	O número de coeficientes para o denominador da linha. Valores válidos: 1 a 20.
`lineNumCoeff`	float array	O número de coeficientes para o numerador da linha. Valores válidos: 1 a 20.
`sampNumCoeff`	float array	O número de coeficientes para o numerador da amostra. Valores válidos: 1 a 20.
`sampDenCoeff`	float array	O número de coeficientes para o denominador da amostra. Valores válidos: 1 a 20.
`errBias`	float	O erro de viés da raiz quadrada média (RMS) em metros, calculado sobre todos os pontos no eixo horizontal da imagem. Valor padrão: `-1.0`.
`errRandom`	float	O erro aleatório RMS em metros, calculado por ponto no eixo horizontal da imagem. Valor padrão: `-1.0`.

Exemplo

SELECT ST_RPCGeoreference(raster_obj) 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,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]}