Re: [postgis-users] QGIS plugin to track in PostGIS database ( triggerusage)

2015-02-27 Thread Edwin Liava'a
Bravo! cheers! On 2/28/15, Andre Mano andre.s.m...@gmail.com wrote: Cool! Thanks! On Fri, Feb 27, 2015 at 4:49 PM, Hugues François hugues.franc...@irstea.fr wrote: Hi remi, Very nice and useful for us ! Thanks for the job. Regards, Hug Original Message From:

[postgis-users] QGIS plugin to track in PostGIS database ( trigger usage)

2015-02-27 Thread Rémi Cura
Hello Dear List, We are pleased to announce the release of a QGIS plug-in http://remi-c.github.io/interactive_map_tracking/ that has been designed to be used with PostGIS. The first functionality is that it allows multi-user camera extent (in qgis) *tracking*. So when editing the same data,

Re: [postgis-users] QGIS plugin to track in PostGIS database ( triggerusage)

2015-02-27 Thread Hugues François
Hi remi, Very nice and useful for us ! Thanks for the job. Regards, Hug Original Message From: Rémi Cura remi.c...@gmail.com Sent: Friday, February 27, 2015 04:33 PM To: PostGIS Users Discussion postgis-users@lists.osgeo.org Subject: [postgis-users] QGIS plugin to track in

Re: [postgis-users] QGIS plugin to track in PostGIS database ( triggerusage)

2015-02-27 Thread Andre Mano
Cool! Thanks! On Fri, Feb 27, 2015 at 4:49 PM, Hugues François hugues.franc...@irstea.fr wrote: Hi remi, Very nice and useful for us ! Thanks for the job. Regards, Hug Original Message From: Rémi Cura remi.c...@gmail.com Sent: Friday, February 27, 2015 04:33 PM

[postgis-users] PostGIS 1.5.3-2 Help: ST_ConvexHull ( ST_Collect ( points from a join table

2015-02-27 Thread Domenico Giusti
Dear list, I have two tables and I need help:) * table_record with a 3d polygon geom id, primary key code, geom * table_record_point with a 3d point geom id, primary key code, reference table_record(code) x, y, z, geom The

Re: [postgis-users] PostGIS 1.5.3-2 Help: ST_ConvexHull ( ST_Collect ( points from a join table

2015-02-27 Thread Hugues François
Hello, It sounds like an sql problem more than a postgis one but the query below should work, assuming the code used is unique for table_record (which should be the case for the foreign key on point_record). UPDATE table_record AS foo SET geom = bar.geom FROM ( SELECT p.code,