<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16674" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=516511103-24072008><FONT face=Arial
color=#0000ff size=2>Jorge,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=516511103-24072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=516511103-24072008><FONT face=Arial
color=#0000ff size=2>If you don't have the table registered in the
geometry_columns table then that would be the problem like the error
says.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=516511103-24072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=516511103-24072008><FONT face=Arial
color=#0000ff size=2>Alternatively you don't need to have it in geometry_columns
if you use this syntax</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=516511103-24072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=516511103-24072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV>DATA "the_geom FROM pai_vec_250<SPAN class=516511103-24072008> USING UNIQUE
gid USING SRID=4326</SPAN>"</DIV>
<DIV> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=516511103-24072008><FONT face=Arial color=#0000ff size=2>Where
gid has to be a field in your table that uniquely identifies each record.
I think Mapserver may put on the additional restriction that the field needs to
be an integer,</FONT></SPAN></DIV>
<DIV><SPAN class=516511103-24072008><FONT face=Arial color=#0000ff size=2>but
I've never tried it with a non-integer unique identifier so I could very well be
wrong.</FONT></SPAN></DIV>
<DIV><SPAN class=516511103-24072008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=516511103-24072008><FONT face=Arial color=#0000ff size=2>Hope
that helps,</FONT></SPAN></DIV>
<DIV><SPAN class=516511103-24072008><FONT face=Arial color=#0000ff
size=2>Regina</FONT></SPAN></DIV>
<DIV><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>jeviloria@cantv.net<BR><B>Sent:</B> Wednesday, July 23, 2008 8:34
PM<BR><B>To:</B> Postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] Need Help with Postgis<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV id=result_box dir=ltr>Hello friends, <BR>I try to run a MSW as
follows:<BR>http://www.sigtruj.org.ve/cgi-sys/mapserv?map=/home/sigtrujo/www
/map/prueba1.map&layers=mun_truj&mode=MAP<BR><BR>
<DIV id=result_box dir=ltr>map file, is as follows:<BR><PRE>MAP<BR> NAME
mun_t<BR> SIZE 400 400<BR> UNITS dd<BR> INTERLACE ON<BR> EXTENT -74.65
0.64 -56.89 12.19<BR> PROJECTION<BR> 'init=EPSG:4189'<BR> END<BR>
FONTSET '../fonts/fonts.txt'<BR> SYMBOLSET '../simbolo/simbolo.txt'<BR> #
Background color for the map canvas -- change as desired<BR> IMAGECOLOR
192 192 192<BR> IMAGEQUALITY 95<BR> STATUS on<BR> WEB<BR> TEMPLATE
"../plantilla.html"<BR> IMAGEPATH
"/home/sigtrujo/www/tmp/ms_tmp/"<BR> IMAGEURL "/tmp/ms_tmp/"<BR> #EMPTY
"http://www.sigtruj.org.ve/plantilla.html"<BR> LOG
"../mapservEdenWfsIow.log" <BR><BR> METADATA<BR> "wms_title" "WMS
Demo Server" ##REQUIRED - generates warning in xml output if
missing<BR> "wms_onlineresourse"
"http://localhost/cgi-bin/mapserver.exe"<BR> "wms_srs"
"init=epsg:24719" <BR> END <BR> END #end web<BR>LAYER<BR> NAME
"mun"<BR> TYPE POLYGON<BR> CONNECTIONTYPE postgis<BR> CONNECTION
"host=localhost port=5432 user=sigtrujo_test password=andrea08
dbname=sigtrujo_sigtruj"<BR> DATA "the_geom FROM pai_vec_250"<BR>
METADATA<BR> "wms_title" "pai_vec_250"<BR> END<BR> STATUS
DEFAULT<BR> TRANSPARENCY 45<BR> PROJECTION<BR>
"init=EPSG:4189"<BR> END<BR> LABELITEM "nombre"<BR> CLASS<BR>
NAME "pai_vec_250" <BR> STYLE<BR> SYMBOL 0 <BR>
OUTLINECOLOR 110 110 110<BR> COLOR 127 143 184<BR> END<BR>
LABEL <BR> SIZE MEDIUM<BR> COLOR 64 64 64<BR> OUTLINECOLOR
212 212 212<BR> POSITION CC<BR> PARTIALS FALSE<BR> FORCE
TRUE<BR> MINDISTANCE 0<BR> ANGLE 0<BR> BUFFER 4<BR>
ENCODING SJIS<BR> END <BR> END<BR> END<BR>IMAGETYPE
PNG<BR>OUTPUTFORMAT<BR> NAME PNG<BR> DRIVER "GD/PNG"<BR> MIMETYPE
"image/png"<BR> IMAGEMODE PC256<BR> EXTENSION "png"<BR> TRANSPARENT
ON<BR> END<BR>END</PRE>
<DIV id=result_box dir=ltr>This produces the following
error.</DIV></DIV>msDrawMap(): Image handling error. Failed to draw layer named
'mun'. prepare_database(): Query error. Error declaring cursor: ERROR:
find_srid() - couldnt find the corresponding SRID - is the geometry registered
in the GEOMETRY_COLUMNS table? Is there an uppercase/lowercase missmatch? With
query string: DECLARE mycursor BINARY CURSOR FOR SELECT
"nombre"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::tex t
from pai_vec_250 WHERE the_geom && setSRID('BOX3D(-74.65 -2.465,-56.89
15.295)'::BOX3D, find_srid('','pai_vec_250','the_geom') )<BR><BR>I can help
solve this problem?. <BR><BR>thanks<BR><BR>Jorge<BR><BR><BR></DIV></BODY></HTML>