[postgis-users] topology - topogeo_id <> mylayer.mypk

Sandro Santilli strk at kbt.io
Fri May 27 13:13:53 PDT 2016

On Fri, May 27, 2016 at 02:34:24PM -0500, Garret W wrote:

> After creating a topology on a trail network, the unique IDs used in my
> dataset are not the showing up as they should in relations.topogeo_id.

How do you think they should ?

> Here are my steps (pretty standard):
> SELECT CreateTopology('trails_topo', 3435);
> SELECT AddTopoGeometryColumn('trails_topo', 'myschema', 'temp_trails',
> 'topogeom', 'LINESTRING');
> UPDATE public.temp_trails SET topogeom = toTopoGeom(geom, 'trails_topo', 1,
> 3);

Where's the statement creating the "temp_trails" table ?

> Afterwards Im just using the relations table to join the attributes to the
> new topological data.

The attributes should be associated to the TopoGeometry objects (for example
in "temp_trails"), not to the records in the relation table.


  ()   Free GIS & Flash consultant/developer
  /\   https://strk.kbt.io/services.html

More information about the postgis-users mailing list