[postgis-users] topology example

[Denis Rouzaud]

Hi Sandro,

Thanks again.

I have a fresh installed for 2 days now.
Postgis 2.0 a6 (it is a 7 now)
Geos 3.3.2
Is this ok?

I did not do anything with topology_upgrade.sql, there is nothing 
written in the installation doc.
What should I do with it?

Would you perform a loop to update the topogeom field, so one entry at once?

Thanks a lot for your valuable help!

Greetings

Denis

On 02/23/2012 11:56 AM, Sandro Santilli wrote:
> On Thu, Feb 23, 2012 at 11:31:13AM +0100, Denis Rouzaud wrote:
>> Hi Sandro,
>>
>> Thanks a lot!
>> Can you also give me hint on what to do when I have an error:
>> psql:topology.sql:14: ERROR:  SQL/MM Spatial exception - point not on edge
> Upgrade to latest GEOS and PostGIS
> (don't forget to load the topology_upgrade.sql file!)
>
> If the problem persists split your update calls in smaller
> ranges until you hit the exception. Further reduce the chunk
> until you get (if ever) to the offending geometry.
>
> Note that order in which geometries are added into the topology
> matters so you may even NOT seeing the problem anymore when changing
> such order.
>
>> Basically, I wanted to create the topology to check it...
>> I think I cannot do anything with validatetopology until toTopoGeom
>> is achieved right?
> Well, ValidateTopology only checks the primitives, not the higher
> level features. If you know GRASS higher level features validation
> is the presence polygon-0 and polygon-2 objects.
>
> If all you want is primitives validation you could use ST_CreateTopoGeo
> passing it a collection of all your pipes.
>
> --strk;
>
>    ,------o-.
>    |   __/  |    Delivering high quality PostGIS 2.0 !
>    |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
>    `-o------'
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users