[postgis-users] Multipart to Single part convert

Paragon Corporation lr at pcorp.us
Mon Jan 19 08:33:47 PST 2009

Use ST_Dump







From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Wirote
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

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.



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

More information about the postgis-users mailing list