[postgis-users] Re: help with WMS query Mapserver and post
Edu Montaña
edumon20 at hotmail.com
Sat Mar 10 09:46:59 PST 2007
Hello Steven and Richard, thanks for yours quick responses.
In answer to Steven, yes I have in my .map file the WEB sentence like
following:
WEB
METADATA
"wms_title" "Map File 01"
"wms_fees" "none"
"wms_onlineresource"
"http://127.0.0.1:81/cgi-bin/mapserv40/mapserv?map=/usr/local/apache2/htdocs/mapfile_01.map&"
"wms_latlonboundingbox" "-180,-180,180,180"
"wms_formatlist"
"image/gif,image/png,image/jpg,image/jpeg,image/tif,image/bmp"
END
IMAGEPATH "/tmp/"
LOG "/usr/local/apache2/logs/mapserver.log"
END
In answer to Richard, yes when I installed postgis, I executed:
psql -d [yourdatabase] -f lwpostgis.sql
and
psql -d [yourdatabase] -f spatial_ref_sys.sql
Watching several post with errors similar to mine , I don't know if it can
be because I don't have append in front of the table name the schema public:
DATA "the_geom from layer_07"
I have't been able to prove this last one.
Best regards,
Edu
>From: Richard Duivenvoorde <rdmailings at duif.net>
>To: edumon20 at hotmail.com
>CC: Steven De Vriendt <gisaalter at GMAIL.COM>, MAPSERVER-USERS at LISTS.UMN.EDU
>Subject: Re: [UMN_MAPSERVER-USERS] [postgis-users] help with WMS query
>Mapserver and postgis
>Date: Sat, 10 Mar 2007 15:33:40 +0100
>
>Hi Edu,
>
>did you run the proper scripts in the debian postgresql-8.1-postgis
>package, as described in the README.Debian.gz? :
>
>quote:
>
>NOTE: To install PostGIS you must run the lwpostgis.sql script in each
> PostgreSQL database you want PostGIS in as the PostgreSQL superuser
> (generally the 'postgres' user)! The Debian utilities do not do
> this automatically as they can't be sure what state your database is in,
> what database(s) you would want PostGIS installed in, or how to
> authenticate as the PostgreSQL superuser to your database. It is likely
> that a PostGIS user would also want the Spatial References installed and
> so it is recommended that the spatial_ref_sys.sql also be run in each
> database you have PostGIS installed in.
>
>For me it looks like you either miss the spatial functions, or casts which
>are defined in these scripts? See the error:
>'ERROR: function setsrid(box3d, integer) does not exist HINT: No function
>matches the given name and argument types. You may need to add explicit
>type casts. '
>
>Hope this helps.
>
>Richard
>
>Steven De Vriendt wrote:
>>Edu,
>>
>>Have you declared the WEB-parameter in your map-file ?
>>Should be something like this:
>>
>>WEB
>> IMAGEPATH "c:/ms4w/tmp/ms_tmp/"
>> IMAGEURL "/ms_tmp/"
>>METADATA
>> "wms_title" "Aalter_WMS"
>> "wms_onlineresource"
>>"http://localhostcgi-bin/mapserv.exe?map=/ms4w/apps/chameleon/samples/map/wmsserver.map&"
>>
>> "wms_srs" "EPSG:31300"
>>END
>>END
>>
>>You have to define this before using mapserver as WMS-server.
>>
>>Regards,
>>Steven
>>
>>On 3/10/07, Edu Montaña <edumon20 at hotmail.com> wrote:
>>>Hello, I'm newbie in mapserver and postgis, and I have a problem that I
>>>don't know how to fix it. I have installed mapserver in a debian system
>>>with
>>>postgis, but when I make a request WMS I obtain the following error:
>>>
>>>msDrawMap(): Image handling error. Failed to draw layer named 'layer_07'.
>>>prepare_database(): Query error. Error executing POSTGIS DECLARE (the
>>>actual
>>>query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
>>>asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from
>>>layer_07
>>>WHERE the_geom && setSRID('BOX3D(63208.0999421528
>>>4203763.49990343,404291.899999981 4487999.99999998)'::BOX3D,
>>>find_srid('','layer_07','the_geom') )' Postgresql reports the error as
>>>'ERROR: function setsrid(box3d, integer) does not exist HINT: No function
>>>matches the given name and argument types. You may need to add explicit
>>>type
>>>casts. ' 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.
>>>
>>>I don't understand this error because I have defined in my database the
>>>function setsrid.
>>>I tried to define in the data declaration in my .map file the following:
>>> DATA "the_geom from layer_07 using unique the_geom using
>>>SRID=23030"
>>>but it doesn't work.
>>>My WMS query is:
>>>http://192.168.0.66:80/cgi-bin/mapserv40/mapserv?map=/usr/local/apache2/htdocs/mapservertest.mapSERVICE=WMS&Request=GetMap&LAYERS=layer_07&format=image/jpeg&bbox=222966.0,4416557.0,223027.0,4416597.0&srs=EPSG:23030&styles=default&VERSION=1.1.1&Height=600&Width=500
>>>
>>>My layer declaration on the .map file is the following:
>>>
>>> LAYER
>>> NAME "layer_07"
>>> TYPE POLYGON
>>> STATUS ON
>>> CONNECTIONTYPE POSTGIS
>>> CONNECTION "host=192.168.0.147 dbname=testdb
>>>user=postgres
>>>password=postgres port=5432"
>>> DATA "the_geom from layer_07"
>>> TRANSPARENCY 25
>>>
>>> CLASS
>>> NAME 'layer_07'
>>> COLOR 188 229 193
>>> OUTLINECOLOR 0 0 0
>>> END
>>>
>>> METADATA
>>> "wms_name" "layer_07"
>>> "wms_title" "Layer 07."
>>> END
>>>
>>> PROJECTION
>>> "init=epsg:23030"
>>> END
>>> END
>>>
>>>
>>>I hope that your can help me, it very urgent.
>>>
>>>Thanks in advance
>>>
>>>P.D.: Sorry for my poor english
>>>
>>>_________________________________________________________________
>>>Acepta el reto MSN Premium: Protección para tus hijos en internet.
>>>Descárgalo y pruébalo 2 meses gratis.
>>>http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados_proteccioninfantil
>>>
>>>
>>>_______________________________________________
>>>postgis-users mailing list
>>>postgis-users at postgis.refractions.net
>>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>
>>
>>
>
_________________________________________________________________
Dale rienda suelta a tu tiempo libre. Mil ideas para exprimir tu ocio con
MSN Entretenimiento. http://entretenimiento.msn.es/
More information about the postgis-users
mailing list