=> ST_LineMerge()
Fred.
On Tue, Oct 7, 2008 at 8:58 PM, David William Bitner <[EMAIL PROTECTED]>wrote:
> Check out ST_Merge()
>
>
> On Tue, Oct 7, 2008 at 3:54 PM, Stephen Woodbridge <
> [EMAIL PROTECTED]> wrote:
>
>> Hi all,
>>
>> This is very annoying. I have two linestrings the join end-to-end and I
>> want to build a new single linestring by merging the two. How can I do this?
>>
>> Thanks,
>> -Steve
>>
>>
>> select astext( ST_Union(
>> ST_GeomFromText('LINESTRING(35.5269251710001 33.891749555,35.527091166
>> 33.8917984710001)'),
>> ST_GeomFromText('LINESTRING(35.527091166 33.8917984710001,35.5274352000001
>> 33.8918998510001,35.528236559 33.8919810230001)')
>> ));
>>
>> astext
>>
>> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>> MULTILINESTRING((35.5269251710001 33.891749555,35.527091166
>> 33.8917984710001),(35.527091166 33.8917984710001,35.5274352000001
>> 33.8918998510001,35.528236559 33.8919810230001))
>> (1 row)
>>
>> _______________________________________________
>> postgis-users mailing list
>> [email protected]
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
>
> --
> ************************************
> David William Bitner
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
