[postgis-users] topologies

Sandro Santilli strk at kbt.io
Wed Mar 27 07:12:12 PDT 2019

On Tue, Mar 26, 2019 at 12:19:43PM +0000, paul.malm at lfv.se wrote:

> My SQL:
> SELECT fname, the_geom FROM public."RST_1813_UTM31N_WE_D_R_Line"
> SELECT fname, the_geom FROM public."CTR_1813_UTM31N_WE_line");
> SELECT Populate_Geometry_Columns('merged'::regclass);
> SELECT topology.CreateTopology('roads_topo', 32631);
> SELECT topology.AddTopoGeometryColumn('roads_topo', 'public', 'merged', 'topo_geom', 'LINESTRING');
> UPDATE merged SET topo_geom = topology.toTopoGeom(wkb_geometry, 'roads_topo', 1, 1.0);
> CREATE TABLE public."roads_clean" AS (
>     SELECT  topo_geom::geometry FROM merged);
> Nor I or pgAdmin 4 knows what wkb_geometry is, in the UPDATE command (directly copied from the example).
> Can someone please, help me?

You probably want to use the name of your geometry column, which seems
to be "the_geom" from your `CREATE TABLE merged` statement.


More information about the postgis-users mailing list