[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