Yes, that's logical, I can offset, but not UPDATE.
select st_geometrytype(st_offsetcurve(way,-20)) from planet_osm_line
where osm_id=-1461806;
st_geometrytype
--------------------
ST_MultiLineString
(1 row)
Thanks !
Le 05/03/2012 11:54, Birgit Laggner a écrit :
Hi Yves,
did you test st_geometrytype(st_offsetcurve(way,-20))? Because, I
could imagine the MultiLineString results from the st_offsetcurve
function.
Hope that helps,
Birgit.
Am 04.03.2012 09:07, schrieb yvecai:
I have a strange error on ST_offsetcurve calls on geometries that are
supposed to be LineStrings.
Yves
gis=# update planet_osm_line set way=ST_OffsetCurve(way,-20)
where osm_id=-1461806;
ERREUR: Geometry type (MultiLineString) does not match column
type (LineString)
gis=# select geometrytype(way) from planet_osm_line where osm_id
= -1461806;
geometrytype
--------------
LINESTRING
(1 ligne)
gis=# select st_geometrytype(way) from planet_osm_line where
osm_id = -1461806;
st_geometrytype
-----------------
ST_LineString
(1 ligne)
gis=# select st_numgeometries(way) from planet_osm_line where
osm_id = -1461806;
st_numgeometries
------------------
1
(1 ligne)
See attached the result of:
echo "select st_astext(way) from planet_osm_line where osm_id =
-1461806;" | psql -d gis > out.wkt
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users