Dear all, I'm currently trying to have mapserver v6.0.1 grab data from my postgis database v 2.0.0 . When I request the layer through mapserver using cgi commands I get the following error message:
msDrawMap(): Image handling error. Failed to draw layer named
'aep_polygon_polyline'. msPostGISLayerWhichShapes(): Query error. Error (ERROR:
function geomfromtext(unknown, integer) does not exist LINE 1: ...gid" from
aep_polygon_polyline where geom_3754 && GeomFromTe... ^ HINT: No function
matches the given name and argument types. You might need to add explicit type
casts. ) executing query: select
encode(ST_AsBinary(ST_Force_2D("geom_3754"),'NDR'),'hex') as geom,"gid" from
aep_polygon_polyline where geom_3754 && GeomFromText('POLYGON((980934.251404232
125495.986,980934.251404232 1038792.604,2809561.55559577
1038792.604,2809561.55559577 125495.986,980934.251404232 125495.986))',3754)
my mapfile looks like this:
LAYER
NAME "aep_polygon_polyline"
STATUS ON
TYPE line
CONNECTIONTYPE postgis
CONNECTION "host=localhost dbname=aep_columbus user=****** password=********
port=5432"
DATA "geom_3754 from aep_polygon_polyline using unique gid using srid=3754"
PROJECTION
"init=epsg:3754"
END
CLASSITEM 'gid'
CLASS
STYLE
COLOR 200 200 200
OUTLINECOLOR 200 200 200
SIZE 2
END
END
END
I used the following command to create my shapefile:
shp2pgsql -s 3754 -g geom_3754 /path/to/my/shpfile | psql -h localhost -U
postgres -p 5432 -d aep_columbus
3754 is Ohio State Plane South. Does this mean that I need to use the -G
geography option to make my data properly render?
Thank you so much,
Paul
Paul A. Maddock
Mapping Technician
IJUS LLC
560 Officenter Place
Gahanna, OH 43230
Cell: (513) 404-6476
[cid:image001.gif@01CD23C8.5F79EDB0]<http://www.ijus.net/index.html>
<<inline: image001.gif>>
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
