[postgis-users] topology example

[Sandro Santilli]

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------'