]
[mailto:[EMAIL PROTECTED] On Behalf Of
Burgholzer,Robert
Sent: Monday, June 02, 2008 8:04 AM
To: PostGIS Users Discussion; PostGIS Users Discussion
Subject: RE: [postgis-users] Creating a Flow Diagram with
PostGIS
Stanley,
Do I read this
:RE: [postgis-users] Creating a Flow Diagram with PostGIS
Here's my possibly buggy 2 cents:
This stores all geometry as geometry, not x,y attribute values. The
intent is to allow moving entities and have the database handle the
updates to related ent
---Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob
Pawley
Sent: Sunday, June 01, 2008 2:17 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Creating a Flow Diagram with PostGIS
Hi Robert
I managed to get the function working - in part.
UPDATE g
Message-
From: [EMAIL PROTECTED] on behalf of Paragon Corporation
Sent: Sun 6/1/2008 5:34 PM
To: 'PostGIS Users Discussion'
Cc:
Subject: RE: [postgis-users] Creating a Flow Diagram with PostGIS
I'm also confused how does your below query update anything - how
et_table.parent_code = the_moving_ball.parent_code;
Hope that helps,
Regina
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob
Pawley
Sent: Sunday, June 01, 2008 5:17 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Creating a Flow Diagram wit
, June 01, 2008 5:17 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Creating a Flow Diagram with PostGIS
Hi Robert
I managed to get the function working - in part.
UPDATE graphics.process_dgm
Set the_geom = translate(the_geom, (x1 - st_x(the_geom)), (y1 -
st_y(the_geom
Hi Robert
I managed to get the function working - in part.
UPDATE graphics.process_dgm
Set the_geom = translate(the_geom, (x1 - st_x(the_geom)), (y1 -
st_y(the_geom)))
where graphics.process_dgm.id = '178'
and graphics.process_dgm.id = '181';
This will move a point from one locati
Hi Robert
I think I'm just begining to understand the role of the coordinates in the
ST_Transform function.
In the example you gave for the ST_Translate function I don't yet understand
the value that is used for x1, y1 and z1.
As it stands I get the error message that x1 is not a column.
B
