asically, you would start with your starting point for the flow. Then you
> search for the next matching line and check if the direction is ok.
> Otherwise you reverse the line. Then you go into your next search loop and
> so on. The loop should exit when all lines have been through the loo
Hello again, I do not have parent line id. All I have is a starting point
from where the direction should reference.
On Wed, Sep 14, 2016 at 9:09 AM Leknín Řepánek <godzilalal...@gmail.com>
wrote:
> On Wed, Sep 14, 2016 at 12:09:23PM +, Jonatan Malaver wrote:
> > the reason
hen update the record
> with the value of st_reverse.
>
> I guess my other question is why it matters.
>
> Jim
>
> On September 13, 2016 8:31:07 AM EDT, Jonatan Malaver <
> jon.mala...@shrewsburyma.gov> wrote:
>
>> Hello,
>>
>>I'm trying to come
wrote:
> ST_EndPoint, ST_StartPoint, ST_Reverse.
>
> On Tue, Sep 13, 2016 at 12:31:07PM +, Jonatan Malaver wrote:
> > Hello,
> >
> >I'm trying to come up with a query that would check the direction of
> a line.
> > If the end point is not the start point of the next
Hello,
I'm trying to come up with a query that would check the direction of a
line. If the end point is not the start point of the next line to update
the line by reversing that line. Can anyone give me pointers on how to do
it?
Thanks,
Jon
___
Hello,
Say I have 2 points (start and end). How could change the direction of
linestring going from start point to end point?
Thanks,
Jon
___
postgis-users mailing list
postgis-users@lists.osgeo.org
(f.geom),ST_StartPoint(n.geom)) = 0.01
which should be faster.
Obviously you need a GIST index on booth geometry columns.
If it all does not help please attach some test data.
Cheers, Tommaso
On 12/10/2013 03:01 AM, Jonatan Malaver wrote:
Another question, what can I do to improve performance
Hello,
I'm new to postgis/postgresql. I was wondering if anyone could tell me how to
make a function out of this sql query:
WITH RECURSIVE flow(gid, geom) AS (
SELECT e.gid, e.geom FROM electric_line e, fuses f WHERE
ST_DWithin(ST_AsText(e.geom)::geometry, ST_AsText(f.geom)::geometry,
FROM electric_line n, flow f
WHERE ST_DWithin(ST_EndPoint(f.geom),ST_StartPoint(n.geom),0.01)
)
SELECT *, ST_ASGeoJSON(ST_Transform(geom,4326),6) AS geojson
FROM flow;
$$
LANGUAGE SQL;
SELECT * FROM flow(1);
On 12/09/2013 03:57 PM, Jonatan Malaver wrote:
Hello,
I'm new to postgis
Another question, what can I do to improve performance on the query? The query
can take 2 seconds or more.
From: postgis-users-boun...@lists.osgeo.org
[mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Jonatan Malaver
Sent: Monday, December 09, 2013 8:52 PM
To: PostGIS Users Discussion
[mailto:postgis-users-boun...@lists.osgeo.orgmailto:postgis-users-boun...@lists.osgeo.org]
On Behalf Of Jonatan Malaver
Sent: Thursday, May 16, 2013 2:01 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] flow analysis
OK, so after some research I found out that ST_StartPoint
Discussion
Subject: Re: [postgis-users] flow analysis
Hi,
The WITH RECURSIVE construct allows to walk a graph:
This link may help:
http://blog.cleverelephant.ca/2010/07/network-walking-in-postgis.html
Nicolas
On 14 May 2013 18:40, Jonatan Malaver
jon.mala...@shrewsburyma.govmailto:jon.mala
?
Nicolas
On 15 May 2013 17:56, Jonatan Malaver
jon.mala...@shrewsburyma.govmailto:jon.mala...@shrewsburyma.gov wrote:
Hello again,
I tried the example, but it only returns the same line. Has anyone tried that
example?
Thanks,
Jonatan
From:
postgis-users-boun...@lists.osgeo.orgmailto:postgis
, and they are all intersected
by a line (circuit).
Thanks,
Jonatan Malaver
Assistant Engineer of Electrical and Cable Operations
Shrewsbury Electric Cable Operations
100 Maple Avenue
Shrewsbury, MA 01545
Office: 508.841.1520
Mobile: 774.262.0437
Fax: 508.842.9267
jon.mala...@shrewsburyma.gov
-Original
14 matches
Mail list logo