[postgis-users] Error in geometry type
yvecai
yvecai at gmail.com
Sun Mar 4 00:07:37 PST 2012
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120304/7e01e164/attachment.html>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: out.wkt
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120304/7e01e164/attachment.ksh>
More information about the postgis-users
mailing list