If all your linestrings are actually linestrings, then you can use the shp2pgsql
-S option The -S will force into single mode and if it can't, then it will throw an error. If you actually have multilinestrings, then what I do is bring it into a temp table as linestrings and use ST_Dump http://postgis.refractions.net/documentation/manual-svn/ST_Dump.html Hope that helps, Regina -----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Smith Roman Sent: Monday, January 26, 2009 8:38 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] forced conversion of linestring to mulitlinestringwhen using shp2pgsql utility ? Hi, I have a shape file of linestrings that I want to load into postgis as linestrings. My problem is whenever i use the shp2pgsql utility, the utility converts all the linestrings to multilinestrings. My purpose of loading the shape files is to do geometry operations on them eg line interpolation. This operation can only be done on linestring not multilinestrings. Is there a way shp2pgsql can load linestrings to postgis as linestrings ? or is there another tool that can do that for me ? Thanks, Smith. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
