Re: postgis-users Digest, Vol 31, Issue 64

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: postgis-users Digest, Vol 31, Issue 64

Miguel R. Luaces
>What is it these multipolygon???
>USA map ???

No, it is not.

It is the border of the province of A Coruña (Spain). We are evaluating
whether migrating a GIS to PostGIS is a good idea in terms of efficiency.
You can have a look at the current version of the GIS at
http://www.dicoruna.es/webeiel/ [Be warned, propietary software, IE only]

We created a SQL script to insert the province boundaries into PostGIS and
it took that much time. On the other hand, inserting the boundaries of the
94 municipalities (94 geometries with 500000 vertices) took only 5 minutes.

Why does this happen? It seems that PostGIS has an efficiency problem with
very large geometries.

Best regards,
  Miguel

--
===================================================================
Dr. Miguel R. Luaces          [hidden email]
Enxenio SL                    http://www.enxenio.es
Estrada dos Baños de Arteixo, Edif. San Cristovo, Portal B, 2º Esq.
15008 A Coruña (Spain)        Tlf./Fax.: 981 913 768
===================================================================

_______________________________________________
postgis-users mailing list
[hidden email]
http://postgis.refractions.net/mailman/listinfo/postgis-users