<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Yves,<br>
<br>
did you test st_geometrytype(st_offsetcurve(way,-20))? Because, I
could imagine the MultiLineString results from the st_offsetcurve
function.<br>
<br>
Hope that helps,<br>
<br>
Birgit.<br>
<br>
<br>
Am 04.03.2012 09:07, schrieb yvecai:
<blockquote cite="mid:4F5322C9.9060300@gmail.com" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
I have a strange error on ST_offsetcurve calls on geometries that
are supposed to be LineStrings.<br>
Yves<br>
<blockquote>gis=# update planet_osm_line set
way=ST_OffsetCurve(way,-20) where osm_id=-1461806;<br>
ERREUR: Geometry type (MultiLineString) does not match column
type (LineString)<br>
<br>
gis=# select geometrytype(way) from planet_osm_line where osm_id
= -1461806;<br>
geometrytype <br>
--------------<br>
LINESTRING<br>
(1 ligne)<br>
<br>
gis=# select st_geometrytype(way) from planet_osm_line where
osm_id = -1461806;<br>
st_geometrytype <br>
-----------------<br>
ST_LineString<br>
(1 ligne)<br>
<br>
gis=# select st_numgeometries(way) from planet_osm_line where
osm_id = -1461806;<br>
st_numgeometries <br>
------------------<br>
1<br>
(1 ligne)<br>
</blockquote>
See attached the result of:<br>
echo "select st_astext(way) from planet_osm_line where osm_id =
-1461806;" | psql -d gis > out.wkt<br>
<br>
<br>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>