[postgis-users] topology example

[Denis Rouzaud]

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

Basically, I wanted to create the topology to check it...
I think I cannot do anything with validatetopology until toTopoGeom  is 
achieved right?

Thanks again!!!



On 02/23/2012 11:13 AM, Sandro Santilli wrote:
> On Thu, Feb 23, 2012 at 10:45:45AM +0100, Denis Rouzaud wrote:
>> Hi all,
>>
>> Is there somewhere on the web a basic tutorial on how to deal with topology?
>> I am looking for a small step-by-step introduction.
>>
>> I looked for a while: chapter 11 of current doc, the wiki, some
>> presentations, strk's blog...
>>
>> Basically I have a table of pipes, and I would like to enable the
>> topology in it...
>   SELECT CreateTopology('pipes_topo', find_srid('public', 'pipes', 'geom));
>   SELECT AddTopoGeometryColumn('pipes_topo', 'pipes', 'topogeom', 'LINE');
>   UPDATE pipes SET topogeom = toTopoGeom(geom, 'pipes_topo', 1);
>
> Good luck!
>
> --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