Hi all,
I try to construct views from a lines table to group roads' portions
together, but I fall on this view when called from QGIS :
SELECT 1::oid AS oid, ST_Multi(ST_Union(f.the_geom)) as the_geom
FROM (SELECT (ST_Dump(the_geom)).geom As the_geom FROM v_tmp) As f
but qgis says :
The view
Le vendredi 02 avril 2010 10:16:40, Lionel Roubeyrie a écrit :
Hi all,
I try to construct views from a lines table to group roads' portions
together, but I fall on this view when called from QGIS :
SELECT 1::oid AS oid, ST_Multi(ST_Union(f.the_geom)) as the_geom
FROM (SELECT
My previous message was send to quickly, sorry (gmail and his keyboard
shotcuts...)
In fact I have a linestring table containing roads, each road is
represented with multiple portions, each portion having a attribute
corresponding to the daily traffic average.
I want to simplify the table (too
Ok, seems to be a view problem (and a QGIS one...), because using
directly this view on the source table 'tmp' :
SELECT max(f.gid), st_multi(st_union(f.the_geom)) AS the_geom
FROM ( SELECT gid, (st_dump(tmp.the_geom)).geom AS the_geom
FROM tmp WHERE numero='D941') f
QGIS complaints