Hi,
The Problem may be either u don't have geom. Or find out whether geom.
Field is existed or not ? or you have to use SRID.Please check my map file
below I have given
MAP
NAME Test
STATUS ON
SIZE 650 400
UNITS dd
IMAGECOLOR 102 153 153
EXTENT 64.881 5.469 97.898 37.762
PROJECTION
'proj=longlat'
'ellps=WGS84'
'datum=WGS84'
'no_defs'
''
END
SYMBOL
NAME "border"
TYPE VECTOR
POINTS
0 0
1 0
1 0.8
0 0.8
0 0
END
STYLE
10 6 1 6
END
FILLED TRUE
END
# Background color for the map canvas -- change as desired
# IMAGECOLOR 192 192 192
IMAGEQUALITY 95
IMAGETYPE png
OUTPUTFORMAT
NAME jpeg
DRIVER "GD/JPEG"
MIMETYPE "image/jpeg"
IMAGEMODE RGB
EXTENSION "jpg"
END
SCALEBAR
INTERVALS 2
UNITS kilometers
STYLE 1
POSITION lc
STATUS embed
LABEL
SIZE small
COLOR 0 0 0
END
END
LAYER
NAME "India"
TYPE POLYGON
CONNECTIONTYPE POSTGIS
CONNECTION "host=localhost dbname=GIS password=administrator
user=postgres port=5432"
Data "the_geom from (select
gid,name,pincode,district,address,website,phnumber,areaname,category,longitu
de,latitude,metroname,the_geom from indiaparks) as Foo USING UNIQUE gid
USING 'srid=24047'"
STATUS ON
TRANSPARENCY 40
MinScale 7054330
LABELITEM "cntry_name" #label Item
CLASSITEM "cntry_name"
TEMPLATE "query.html"
CLASS
NAME 'India'
STYLE
SYMBOL "border"
SIZE 6
OUTLINECOLOR 0 0 0
COLOR 251 252 179
END
LABEL #label class start
POSITION auto #label Position
FONT sans
SIZE SMALL #lable size
COLOR 0 38 237 # label color
END # label end
END
END
END
END
Thanks
Venkat.
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of syed mohseen
Sent: Monday, March 16, 2009 11:01 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] cannot able to test the mapfile-database eror
hi all,
i am a new bie to fgs and i want to test one of my mapfile with
connecting to my database.
here is my mapfile
NAME "test"
SIZE 800 600
IMAGECOLOR 249 245 186
IMAGETYPE png
EXTENT -1.00 -1.00 1.00 1.00
LAYER
CONNECTIONTYPE postgis
NAME "test"
CONNECTION "user=postgres password=hellopostgres dbname=postgres
host=localhost"
DATA "geom FROM test"
STATUS ON
TYPE POINT
END
END
whenever i test the file as shp2img i get the following error
msDrawMap(): Image handling error. Failed to draw layer named 'test'.
prepare_database(): Query error. Error executing POSTGIS DECLARE (the actual
query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(geom)),'NDR'),OID::text from test WHERE
geom && setSRID('BOX3D(-1.3338898163606 -1,1.3338898163606 1)'::BOX3D,
find_srid('','test','geom') )'
Postgresql reports the error as 'ERROR: find_srid() - couldnt find the
corresponding SRID - is the geometry registered in the GEOMETRY_COLUMNS
table? Is there an uppercase/lowercase missmatch?
'
More Help:
Error with POSTGIS data variable. You specified 'check your .map file'.
Standard ways of specifiying are :
(1) 'geometry_column from geometry_table'
(2) 'geometry_column from (sub query) as foo using unique column name using
SRID=srid#'
Make sure you put in the 'using unique column name' and 'using SRID=#'
clauses in.
For more help, please see http://postgis.refractions.net/documentation/
Mappostgis.c - version of Jan 23/2004.
any solutions will be appreciated
regards
SyedMohseen
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users