Ticket #1789 (closed defect: fixed)
False positive "edge crosses node"
|Reported by:||strk||Owned by:||strk|
I was playing with hexagon grids and knowing irrational numbers approximation would have introduced slight discrepancies I thought to take a look using PostGIS topology.
To be honest I did expect problems :)
Well, here's the problem: ERROR: Invalid edge (no two distinct vertices exist)
1. load https://github.com/Vizzuality/cartodb/blob/develop/lib/sql/CDB_Hexagon.sql 1. create a grid table: create table hgrid10 as select CDB_HexagonGrid(ST_MakeEnvelope(-180, -90, 180, 90), 10) as geom; 1. create a topology out of it: select createtopology('hexagon_topo'); select ST_CreateTopoGeo('hexagon_topo', st_collect(geom)) from hgrid10;