PolarDB:ST_HMTAsArray

Sintaksis

float8[][] ST_HMTAsArray(bytea hmt);

Nilai Pengembalian

Mengembalikan array 2D float8, dengan setiap nilai mewakili statistik dari heatmap.

Parameter

Deskripsi

Fungsi ini mengonversi ubin heatmap menjadi representasi berbasis matriks array untuk mempermudah visualisasi. Ubin heatmap dihasilkan menggunakan fungsi ST_AsHMT.

Contoh

CREATE TABLE test_table AS
SELECT i num,
    ST_setSRID(st_makepoint((i-0.5)::numeric, (i-0.5)::numeric), 4326) geom,
    i*100::int4 weight,
    i*i*i::float8 volume
FROM generate_series(1, 10) i;

SELECT ST_HMTAsArray(ST_AsHMT(geom, --geometry type
    ST_MakeEnvelope(0, 0, 10, 10, 4326), -- Extent
    10,        -- Width, in pixel
    10        -- height
))
FROM test_table;
---------
[0:9][0:9]={{1,0,0,0,0,0,0,0,0,0},{0,1,0,0,0,0,0,0,0,0},{0,0,1,0,0,0,0,0,0,0},{0,0,0,1,0,0,0,0,0,0},{0,0,0,0,1,0,0,0,0,0},{0,0,0,0,0,1,0,0,0,0},{0,0,0,0,0,0,1,0,0,0},{0,0,0,0,0,0,0,1,0,0},{0,0,0,0,0,0,0,0,1,0},{0,0,0,0,0,0,0,0,0,1}}