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

2015-07-18 Thread Lars Aksel Opsahl
Fra: postgis-users-boun...@lists.osgeo.org [postgis-users-boun...@lists.osgeo.org] p#229; vegne av Marc-André Goderre [magode...@cgq.qc.ca] Sendt: 4. juni 2015 17:21 Til: PostGIS Users Discussion Emne: Re: [postgis-users] creating topology data is slow Does

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

2015-06-05 Thread Lars Aksel Opsahl
...@gmail.com] p#229; vegne av Sandro Santilli [s...@keybit.net] Sendt: 3. juni 2015 10:49 Til: PostGIS Users Discussion Kopi: Lars Aksel Opsahl Emne: Re: [postgis-users] creating topology data is slow On Wed, Jun 03, 2015 at 05:56:24AM +, Lars Aksel Opsahl wrote: We are working quite big

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

2015-06-04 Thread Lars Aksel Opsahl
...@lists.osgeo.org [postgis-users-boun...@lists.osgeo.org] p#229; vegne av Marc-André Goderre [magode...@cgq.qc.ca] Sendt: 4. juni 2015 17:21 Til: PostGIS Users Discussion Emne: Re: [postgis-users] creating topology data is slow Does the processing became slower when the edge_data table became bigger

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

2015-06-04 Thread Marc-André Goderre
: [postgis-users] creating topology data is slow We are working quite big datasets (about 1 billion points and 20 million lines) that we convert from simple feature to topology. I ran a test yesterday and we added these 20 million lines in about 9 hours with attached attributes. This means heavy

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

2015-06-03 Thread Lars Aksel Opsahl
Santilli [s...@keybit.net] Sendt: 3. juni 2015 10:49 Til: PostGIS Users Discussion Kopi: Lars Aksel Opsahl Emne: Re: [postgis-users] creating topology data is slow On Wed, Jun 03, 2015 at 05:56:24AM +, Lars Aksel Opsahl wrote: We are working quite big datasets (about 1 billion points and 20

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

2015-06-03 Thread Lars Aksel Opsahl
] på vegne av Rémi Cura [remi.c...@gmail.com] Sendt: 2. juni 2015 21:33 Til: PostGIS Users Discussion Emne: Re: [postgis-users] creating topology data is slow I'm working on a batch way to import topology, it is not ready yet. If you now for sure your data is correct, you can skip a lot of testing

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

2015-06-02 Thread Rémi Cura
I'm working on a batch way to import topology, it is not ready yet. If you now for sure your 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

[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