[postgis-users] break road linestrings intelligently

Richard Greenwood richard.greenwood at gmail.com
Wed Sep 26 19:35:02 PDT 2012

Martin, Jan, Sandro -

Thanks for the suggestions. I think I'm pointed in the right
direction. Comparing the end points to generate the sequential order
makes sense, should have thought of that myself.

Always good to hear from you guys!


On Wed, Sep 26, 2012 at 6:00 AM, Sandro Santilli <strk at keybit.net> wrote:
> On Tue, Sep 25, 2012 at 07:43:10PM -0600, Richard Greenwood wrote:
>> I break the original linestring into 3 new linestrings, but
>> how do I populate the "from" and "to" values? If I know the order of
>> the 3 new linestrings it would be very easy to calculate the new
>> values based on the length of each new linestring, eg. line #1
>> 100-240, line#2 241-385, line #3 386-500 or some such thing.
> What I've been doing in topology for determining the order has been
> comparing the location of a point of each substring against the parent
> string.
> --strk;
>  http://www.cartodb.com - Map, analyze and build applications with your data
>                                        ~~ http://strk.keybit.net
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Richard Greenwood
richard.greenwood at gmail.com

More information about the postgis-users mailing list