PostGIS Layer Failing

Fawcett, David David.Fawcett at STATE.MN.US
Sat Dec 1 11:52:09 PST 2007


I am testing out a new install of PostGIS and MapServer on OS X Leopard.  I built a map file to display a simple ten point layer coming from PostGIS.  

I get the following error:

msDrawMap(): Image handling error. Failed to draw layer named 'basemap'. prepare_database(): Query error. Couldnt recover from a bad query: 'DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),'NDR'),the_geom::text from ten_points_layer WHERE the_geom && setSRID('BOX3D(146545.5 4814000,804891.5 5472346)'::BOX3D, find_srid('','ten_points_layer','the_geom') )'

Here is the layer definition:
LAYER
    NAME basemap
    STATUS DEFAULT
    TYPE POLYGON
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=localhost dbname=mydb user=myuser password=mypass port=5432"
    DATA "the_geom FROM ten_points_layer using unique the_geom"

    CLASS 
	   COLOR 255 255 255
       OUTLINECOLOR 181 181 181   #An OUTLINECOLOR with no COLOR gives same effect as old POLYLINE
    END
  
    PROJECTION
      "init=epsg:26915"
    END
 END

Any ideas?  I am also having trouble getting QGIS to display the layer.  

Thanks, 

David.



More information about the MapServer-users mailing list