[postgis-users] break road linestrings intelligently

[Richard Greenwood]

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!

Thanks,
Rich


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
www.greenwoodmap.com