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