[postgis-users] postgis-users Digest, Vol 97, Issue 7
worker201 at gmail.com
Sat May 8 01:04:25 PDT 2010
On Fri, May 07, 2010 at 12:05:37 +0200, strk wrote:
> On Fri, May 07, 2010 at 02:57:09AM -0700, Leigh Holcombe wrote:
>> Is there a way to force linestring data to be imported as a linestring instead
>> of as a multilinestring?
> Yes, shp2pgsql -S
Trying to use this option produced the following output:
# shp2pgsql -S -s st_address.shp test.kcstreets > kcstreets.sql
Shapefile type: Arc
Postgis type: LINESTRING
We have a Multilinestring with 2 parts, can't use -S switch!
Does this mean that one of the lines in the dataset actually is a real multilinestring?
>> Is there a way to convert a multilinestring into a linestring easily and quickly
>> on the fly (I'm doing PHP/LAPP programming)?
> ST_GeometryN(the_geom, 1) gives you the first LINESTRING of the (pseudo)set.
The following statement worked perfectly for me:
ST_AsText(line_interpolate_point(ST_GeometryN(the_geom, 1), $prop))
Thanks for all your help!
More information about the postgis-users