<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META name=GENERATOR content="MSHTML 8.00.6001.19222"><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page WordSection1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
LI.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
DIV.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
P.MsoAcetate {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
LI.MsoAcetate {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
DIV.MsoAcetate {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: windowtext; mso-style-type: personal-compose
}
SPAN.BalloonTextChar {
FONT-FAMILY: "Tahoma","sans-serif"; mso-style-priority: 99; mso-style-link: "Balloon Text"; mso-style-name: "Balloon Text Char"
}
.MsoChpDefault {
mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US link=blue vLink=purple>
<DIV><SPAN class=953421821-26042012><FONT color=#0000ff size=2
face=Arial>Paul,</FONT></SPAN></DIV>
<DIV><SPAN class=953421821-26042012><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=953421821-26042012><FONT color=#0000ff size=2 face=Arial>I had
the same issue. The functions have been renamed in PostGIS 2. You need to run
legacy_minimal.sql in PostGreSQL. That file can be found here:
\PostgreSQL\9.1\share\contrib\postgis-2.0. </FONT></SPAN></DIV>
<DIV><SPAN class=953421821-26042012><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=953421821-26042012><FONT color=#0000ff size=2
face=Arial>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=953421821-26042012><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=953421821-26042012><FONT color=#0000ff size=2
face=Arial>Donald</FONT></SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px" dir=ltr>
<DIV></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left><FONT size=2
face=Tahoma>-----Original Message-----<BR><B>From:</B>
mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Paul
Maddock<BR><B>Sent:</B> 26 April 2012 21:52<BR><B>To:</B>
mapserver-users@lists.osgeo.org<BR><B>Subject:</B> [mapserver-users]
Postgis/mapserver error<BR><BR></FONT></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN style="BACKGROUND: white; COLOR: black">Dear
all,<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="BACKGROUND: white; COLOR: black"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="BACKGROUND: white; COLOR: black">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:<o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><SPAN
style="BACKGROUND: white; COLOR: black"><BR><I>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)<o:p></o:p></I></SPAN></P>
<P class=MsoNormal><SPAN
style="BACKGROUND: white; COLOR: black"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="BACKGROUND: white; COLOR: black"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="BACKGROUND: white; COLOR: black">my mapfile
looks like this:<o:p></o:p></SPAN></P>
<P class=MsoNormal><I><o:p> </o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I>LAYER<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I> NAME
"aep_polygon_polyline"<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I> STATUS
ON<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I> TYPE
line<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I> CONNECTIONTYPE
postgis<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I> CONNECTION
"host=localhost dbname=aep_columbus user=****** password=********
port=5432"<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I>
<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in"
class=MsoNormal><I> <o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I> DATA
"geom_3754 from aep_polygon_polyline using unique gid using
srid=3754"<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I>
PROJECTION<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in"
class=MsoNormal><I>
"init=epsg:3754"<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I>
END<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I> CLASSITEM
'gid'<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I>
CLASS
<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in"
class=MsoNormal><I>
STYLE
<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in"
class=MsoNormal><I>
COLOR 200 200 200<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in"
class=MsoNormal><I>
OUTLINECOLOR 200 200 200<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in"
class=MsoNormal><I>
SIZE 2<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in"
class=MsoNormal><I>
END<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I>
END<o:p></o:p></I></P>
<P style="MARGIN-LEFT: 1.5in" class=MsoNormal><I>END<o:p></o:p></I></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>I used the following command to create my
shapefile:<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P style="MARGIN-LEFT: 1in" class=MsoNormal><I>shp2pgsql -s 3754 -g geom_3754
/path/to/my/shpfile | psql -h localhost -U postgres -p 5432 -d
aep_columbus<o:p></o:p></I></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>3754 is Ohio State Plane South. Does this mean that I
need to use the –G geography option to make my data properly
render?<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Thank you so much,<o:p></o:p></P>
<P class=MsoNormal>Paul<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><B><SPAN style="FONT-SIZE: 12pt">Paul A.
Maddock<o:p></o:p></SPAN></B></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 12pt">Mapping
Technician<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 12pt">IJUS
LLC<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 12pt">560 Officenter
Place<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 12pt">Gahanna, OH
43230<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 12pt">Cell: (513)
404-6476<o:p></o:p></SPAN></P>
<P class=MsoNormal><A href="http://www.ijus.net/index.html"><SPAN
style="COLOR: blue; TEXT-DECORATION: none"><IMG id=Picture_x0020_1 border=0
alt="Description: Description: Home" src="cid:953421821@26042012-2FD1"
width=100 height=71></SPAN></A><SPAN
style="FONT-SIZE: 12pt"><o:p></o:p></SPAN></P>
<P class=MsoNormal><o:p> </o:p></P></DIV></BLOCKQUOTE></BODY></HTML>