[postgis-users] topology, joining attributes

[Rémi Cura]

Hey,
I think Sandro wrote a QGis plugin to edit topology, I never used it though.

To accelerate load of topology,
you should use GRASS GIS 7 , with the external command. (should be several
times faster).

However there is currently no solution to load really fast (in your case,
10sec would be bottom limit I guess).

If you load only polygon, you could also manually batch fill topology
tables, but it is a bit complicated.

Cheers,
Rémi-C



2014-07-24 5:14 GMT+02:00 Richard Greenwood <richard.greenwood at gmail.com>:

> Sandro,
>
> Thanks for the suggestion. The speed of my queries are fine even with the
> relation table. Populating the topology however is quite slow, >2 hours for
> 64k polygons. Which leads to another question which should probably be
> asked in another thread - but what tools are available for interactive
> topology editing? If I could maintain my data in the topology then I would
> not need to repeatedly reload it.
>
> Thanks,
> Rich
>
>
>
> On Wed, Jul 23, 2014 at 10:10 AM, Sandro Santilli <strk at keybit.net> wrote:
>
>> On Wed, Jul 23, 2014 at 10:49:47AM +0200, Rémi Cura wrote:
>>
>> > Your querry could look like this:
>> >
>> > SELECT my_topogeom, f.face_id
>> > FROM my_table AS mt
>> > INNER JOIN relation AS r ON (((mt.mytopogeom).id ,
>> > (mt.mytopogeom).layer_id)) = (r.topogeo_id, r.layer_id  )
>> > INNER JOIN face AS f ON (r.element_id = f.face_id)
>>
>> See also http://postgis.net/docs/GetTopoGeomElements.html
>> .. if you want to have more isolation from the "relation" table
>> (not necessarely a good idea, in terms of speed)
>>
>> --strk;
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
>
> --
> Richard W. Greenwood, PLS
> www.greenwoodmap.com
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140724/447e70a4/attachment.html>