[postgis-users] Multipart to Single part convert

[Paragon Corporation]

Use ST_Dump

 

http://postgis.refractions.net/documentation/manual-svn/ST_Dump.html

 

Leo

 

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Wirote
Laongmanee
Sent: Monday, January 19, 2009 8:51 AM
To: postgis-users
Subject: [postgis-users] Multipart to Single part convert

 

Dear List,

May someone can share experience, I have a table of road inventory but they
are multilinestring (multi-part), I developed function inform coordinate
from KM stone.

It need linestring, so I need to convert multipart data to single part
(linestring). 

At this moment I asked my friend convert multipart shape file to single part
on ArcGIS before import to postgis. But in near future I must do this again.
So better do by postgis but I have no idea. 

Best regards,

-- 
Wirote Laongmanee
Chulalongkorn University,
Bangkok, Thailand

 

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 3777 (20090119) __________

 

The message was checked by ESET NOD32 Antivirus.

 

http://www.eset.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090119/c85e8cb0/attachment.html>