Suman, Also try ST_LineMerge for merging the indivudal linestring elements of a single multilinestring into a single linestring (where the lines connect). ST_Union is expensive, although I believe work has been done on aggregated geometry functions in the later/latest postgis releases.
Steve 2009/9/16 Suman Chatterjee <schatter...@addisontx.gov> > Hi Pavel! > Thanks a lot for your help. St_union is really helpful. Now I am able to do > it > Suman > > -----Original Message----- > From: Pavel Iacovlev [mailto:iacovlev.pa...@gmail.com] > Sent: Wednesday, September 16, 2009 8:44 AM > To: Suman Chatterjee > Cc: mapserver-users@lists.osgeo.org > Subject: Re: [mapserver-users] multilinestring and linestring > > 1) You can convert multiple multilinestrings into 1 multilinestring > with st_union > 2) st_multi() > > On Wed, Sep 16, 2009 at 4:30 PM, Suman Chatterjee > <schatter...@addisontx.gov> wrote: > > Hi all, > > > > I want to know : > > > > > > > > 1) Is there any way to convert many Multilinestring geometry into > one > > linestring geometry? > > > > > > > > I need to enter linestring geometry into a table with check constraint > > "enforce_geotype_the_geom" meant for Multilinestring . So I need to > convert > > the linestring to a multilinestring > > > > > > > > 2) How can I convert a linestring to a multilinestring? > > > > > > > > Thanks > > > > Suman > > > > > ******************************************************************************************************************* > > > > This e-mail and any files or attachments transmitted with it contains > > Information that is confidential and privileged. This document may > contain > > Protected Health Information (PHI) or other information that is intended > > only for the use of the individual(s) and entity(ies) to whom it is > > addressed. If you are the intended recipient, further disclosures are > > prohibited without proper authorization. If you are not the intended > > recipient, any disclosure, copying, printing, or use of this information > is > > strictly prohibited and possibly a violation of federal or state law and > > regulations. If you have received this information in error, please > delete > > it and notify Hamid Khaleghipour at 972-450-2868 immediately. Thank you. > > > > > ******************************************************************************************************************* > > > > _______________________________________________ > > mapserver-users mailing list > > mapserver-users@lists.osgeo.org > > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > > > > > > -- > http://iap.md, The future is open > _______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users >
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
