Thank you very much! Will try it!
mike
On Fri, Apr 2, 2010 at 8:32 PM, Goyo wrote:
> El jue, 01-04-2010 a las 00:17 +0200, jamesmikedup...@googlemail.com
> escribió:
>> Hi,
>> I am also using 1.4 on karmic, the ubuntugis ppa.
>>
>> I did not set it, but saved as a new projection
>> opened that an
El jue, 01-04-2010 a las 00:17 +0200, jamesmikedup...@googlemail.com
escribió:
> Hi,
> I am also using 1.4 on karmic, the ubuntugis ppa.
>
> I did not set it, but saved as a new projection
> opened that and used the reproject tool.
>
> Will try with the set and save. Does that save as do the repr
No, it's why I have added a max(f.id) just for the test. After some
search, QGIS absolutely needs a int4 primary key, but doesn't explain
why in a table it's ok, not in a view...
2010/4/2 Andrea Peri 2007 :
- Masquer le texte des messages précédents -
> Perhaps,
> it missing a "group by" operator
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
Perhaps,
it missing a "group by" operator ?
SELECT
f.id AS oid,
ST_Multi(ST_Union(f.the_geom)) as the_geom
FROM (
SELECT
id,
ST_Dump(the_geom)).geom As the_geom
FROM
v_tmp
) As f
group by
f.id
Regards,
Andrea.
___
Qgis-us
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 ab
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 many
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 (ST_Dump(the_
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 'publi