全部产品
Search
文档中心

PolarDB:ST_RPCGeoreference

更新时间:Jul 02, 2025

Mengambil informasi terkait koefisien polinomial rasional (RPC) dari objek raster. Jika objek raster memiliki informasi RPC, string JSON akan dikembalikan. Jika tidak, nilai null akan dikembalikan.

Sintaksis

text ST_RPCGeoreference(raster raster_obj)

Parameter

ParameterDeskripsi
raster_objObjek raster.

Deskripsi

Fungsi ST_RPCGeoreference mengembalikan string JSON yang berisi parameter RPC. String ini mencakup informasi referensi untuk ruang RPC. Tabel berikut menjelaskan parameter yang didukung.

ParameterDeskripsiTipe
lineOffOffset baris.float
sampOffOffset pengambilan sampel.float
latOffOffset lintang.float
longOffOffset bujur.float
heightOffOffset ketinggian.float
lineScaleRasio baris.float
sampScaleRasio pengambilan sampel.float
latScaleRasio lintang.float
longScaleRasio bujur.float
heightScaleRasio ketinggian.float
lineDenCoeffJumlah koefisien untuk penyebut baris. Nilai valid: 1 hingga 20.larik float
lineNumCoeffJumlah koefisien untuk pembilang baris. Nilai valid: 1 hingga 20.larik float
sampNumCoeffJumlah koefisien untuk pembilang sampel. Nilai valid: 1 hingga 20.larik float
sampDenCoeffJumlah koefisien untuk penyebut sampel. Nilai valid: 1 hingga 20.larik float
errBiasKesalahan bias. Kesalahan bias akar-kuadrat-rata-rata (RMS) dalam meter. Kesalahan ini terkait dengan semua titik per sumbu horizontal dalam gambar. Nilai default: -1.0.float
errRandomKesalahan acak. Kesalahan acak RMS dalam meter. Kesalahan ini terkait dengan setiap titik per sumbu horizontal dalam gambar. Nilai default: -1.0.float

Contoh:

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