[mapserver-users] postgis-topology-how to use topogeom field

csaba toth akoel at yahoo.com
Thu Aug 23 17:26:48 PDT 2012


As I know the topogeom type is automatically casting to geometry type.
So I have a table (telek) with a field of topogeom  (topo_geom) in the postgresql db (tdc)
I made a map file for the mapserver and the layer looks like this:

 LAYER
    NAME "telek"
    CONNECTIONTYPE postgis
    CONNECTION "host=localhost password=postgres user=postgres dbname=tdc"
    DATA "topo_geom from public.telek"
    STATUS DEFAULT
    TYPE LINE
    TOLERANCE 10
    
    PROJECTION
      "init=epsg:2370"
    END

    CLASS
      STYLE
        COLOR 0 0 255
        WIDTH 10
      END
    END
  END

But I got the following error message when I try to display the map:

msDrawMap(): Image handling error. Failed to draw layer named 'telek'.
msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR: 
 find_srid() - couldnt find the corresponding SRID - is the geometry 
registered in the GEOMETRY_COLUMNS table?  Is there an 
uppercase/lowercase missmatch?
 


What could be the problem? 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120823/1c51ea07/attachment.html>


More information about the mapserver-users mailing list