[postgis-users] help with WMS query Mapserver and post
Richard Duivenvoorde
rdmailings at DUIF.NET
Sat Mar 10 14:26:11 EST 2007
Hi Edu, that shouldn't be neccesary as when a table is declared without
a schema name, it is put/looked up in the public schema anyway???
Though..., I myself am doing some testing and have a DATA string like:
DATA 'the_geom FROM (select *, oid from "public"."testpoints") as foo
using unique oid using SRID=28992'
(so I DO use the public schema string?), try and see.
Some other tests/things you can do:
- either in psql or in pgadmin3, connect to the same database as the
same user as you have in your mapfile and try to fire the DATA-query
select string and see if that results in your records/geometries.
- do you have something like:
CONNECTIONTYPE postgis
CONNECTION "host=localhost dbname=testgis password='xxxx' user=user"
in your mapfile? (probably anyway, otherwise you should get those
errormessages...)
- I 'wrote' my first postgresql-mapfile by using the free qgis
(http://qgis.org/) to connect to the database, and then use the option
'Export to Mapserver Map' to write a starting for a mapfile. It's a very
fine tool for viewing postgis data!
- you are sure you can see all functions and casts in the database you
are using? You have to use the scripts for every db you have. pgadmin3
shows you all functions and casts in a nice and easy way for a given
database.
Ok that's all I know :-) Good luck.
Richard
Edu Montaña wrote:
> 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
>>>>
>>>
>>>
>>>
>>
>
> _________________________________________________________________
> Grandes éxitos, superhéroes, imitaciones, cine y TV...
> http://es.msn.kiwee.com/ Lo mejor para tu móvil.
>
>
>
More information about the mapserver-users
mailing list