<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Yes, that's logical, I can offset, but not UPDATE. <br>
select st_geometrytype(st_offsetcurve(way,-20)) from planet_osm_line
where osm_id=-1461806;<br>
st_geometrytype <br>
--------------------<br>
ST_MultiLineString<br>
(1 row)<br>
<br>
Thanks !<br>
<br>
Le 05/03/2012 11:54, Birgit Laggner a écrit :
<blockquote cite="mid:4F549B82.7040201@vti.bund.de" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
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 moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a moz-do-not-send="true" 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>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
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>
<br>
</body>
</html>