Re: [postgis-users] creating topology data is slow

2015-06-04 Thread Marc-André Goderre
data is correct, you can skip a lot of testing and be efficient in a batch way. You could use grass and the topological export. Cheers, Rémi-C 2015-06-02 19:25 GMT+02:00 Marc-André Goderre magode...@cgq.qc.camailto:magode...@cgq.qc.ca: Hello all, I'm creating topology data from almost all

[postgis-users] creating topology data is slow

2015-06-02 Thread Marc-André Goderre
Hello all, I'm creating topology data from almost all world road OSM data ( More than 77 Million ways). Processing the data with postgis topology in one shot is so long than that I created a hexagonal grid that let me create topological data from only one or many cell of the grid. Even this

[postgis-users] Best projection srid for topology

2015-05-27 Thread Marc-André Goderre
Hello all, I'm working on a many million lines topology project with OSM data in 4326 srid. I'd like to know if i should transform their geom in a meter srid ( like 3857). Should it be faster for the 'toTopoGeom()' function to work with geometry in 4326 or in 3857 srid? Thanks Marc

Re: [postgis-users] RE Best projection srid for topology

2015-05-27 Thread Marc-André Goderre
: postgis-users-boun...@lists.osgeo.org Objet : [postgis-users] RE Best projection srid for topology If you need to translate to meter I think you should avoid 3857 if you need precision on linear or surface measure. It depend where on earth you are Marc-André Goderre magode