<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#ffffff" text="#000000">
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>
</body>
</html>