Minor update. I've rewritten the list of polygons to a proper SQL statement and seeing it all in one layer now starts to make at least some sense to me.
I will see if i can add some lines to have the KD-tree look. Still, would be nice to know, what to do with the leaf_values.
Gesendet: Dienstag, 05. März 2019 um 22:21 Uhr
Von: "Felix Kunde" <[email protected]>
An: [email protected]
Betreff: [postgis-users] Visualize sp-GiST index structure
Von: "Felix Kunde" <[email protected]>
An: [email protected]
Betreff: [postgis-users] Visualize sp-GiST index structure
Hi there,
I'm trying to use Gevel to print the structure of my sp-GiST indexes. For GiST, it works fine as descibed here: https://gist.github.com/Komzpa/f9e1c241d1d2a27cf5a4f985f646f8a6
But for spgist_print I'm getting error with the leaf_values.
SELECT
ST_SetSRID(replace(prefix::text, '2DF', '')::box2d::geometry, 4326) as geom,
tid, allthesame, node_n, level, tid_pointer, node_label, leaf_value
FROM
spgist_print('pts16_spgist') as t
(
tid tid,
allthesame bool,
node_n int,
level int,
tid_pointer tid,
prefix box2df,
node_label int,
leaf_value geometry
);
ERROR: Unknown geometry type: 1128379426 - Invalid type
As long as I only select levels where leaf_value is null it works.
Was hoping I could get an unterstanding how the index is structured by looking only at the prefix boxes, but they are so small an only lie in the center of my dataset. I've attached a file, where I have copied the prefixes of the first three levels. At level 4, I'm getting errors.
Has anybody already tried this before?
Cheers,
Felix_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
I'm trying to use Gevel to print the structure of my sp-GiST indexes. For GiST, it works fine as descibed here: https://gist.github.com/Komzpa/f9e1c241d1d2a27cf5a4f985f646f8a6
But for spgist_print I'm getting error with the leaf_values.
SELECT
ST_SetSRID(replace(prefix::text, '2DF', '')::box2d::geometry, 4326) as geom,
tid, allthesame, node_n, level, tid_pointer, node_label, leaf_value
FROM
spgist_print('pts16_spgist') as t
(
tid tid,
allthesame bool,
node_n int,
level int,
tid_pointer tid,
prefix box2df,
node_label int,
leaf_value geometry
);
ERROR: Unknown geometry type: 1128379426 - Invalid type
As long as I only select levels where leaf_value is null it works.
Was hoping I could get an unterstanding how the index is structured by looking only at the prefix boxes, but they are so small an only lie in the center of my dataset. I've attached a file, where I have copied the prefixes of the first three levels. At level 4, I'm getting errors.
Has anybody already tried this before?
Cheers,
Felix_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
spgist_levels_1_2_3
Description: Binary data
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
