-- 
Peter Freimuth  Muskauer Str. 11   10997 Berlin
Location:http://www.berlinonline.de/citymap/map.asp?start.x=5&plz=10997&str=Muskauer+Str.+11&grid=dedatlas10
========================================================================================================
Tel:+49(0)30-69816610  Mobil:+49(0)175-8434074  Firma:+49(0)3381-8904327
========================================================================================================
mailto:[email protected]  
skype:pfreimuth
msn:[email protected]

--- Begin Message ---
owsu...@map2:~> /srv/www/cgi-bin/mapserv -v
MapServer version 5.4.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP 
OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV 
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT 
SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=THREADS SUPPORTS=GEOS 
INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=MYGIS INPUT=SHAPEFILE

MAP
...
    
#-----------------------------------------------------------------------------------------------------------------------------------
    # Index and Raster Layer for all requested "service_products"
    # duplicate the template below and modify the Product Shortname in the sql 
query and rename the layer itself
    
#-----------------------------------------------------------------------------------------------------------------------------------
    LAYER
        NAME "service_product_gc_idx"
        STATUS OFF
        #DEBUG ON
        TYPE POLYGON
        PROCESSING "CLOSE_CONNECTION=DEFER"
        CONNECTIONTYPE POSTGIS  
        CONNECTION "user=ows_user password=xxx dbname=ows_customer_nnn host=db2 
port=5432"
        DATA "wkb_geom FROM (SELECT * FROM 
ows_customer.tileindex_service_products tsp JOIN ows_customer.analysis_units au 
ON (au.unit_id=tsp.unit_id) JOIN ows_customer.service_product_types spt ON 
(tsp.product_type_id=spt.product_type_id) WHERE spt.name = 'GC' ) foo USING 
UNIQUE service_product_id USING SRID=3785"
        PROJECTION
            "init=epsg:3785"
        END
        METADATA
            "ows_title" "service_product_gc_idx"
            "wms_srs"   "EPSG:3785 EPSG:4269 EPSG:4326 EPSG:32610 EPSG:32611 
EPSG:32612 EPSG:32613 EPSG:32614 EPSG:26710 EPSG:26711 EPSG:26712 EPSG:26713 
EPSG:26714 EPSG:900913" #output
            #"ows_extent" "380000 5230000 530000 5390000"
        END
    END
    # Raster Layer
    LAYER
        NAME "serv_prod_gc20090415"
        #GROUP "service_products"
        TYPE RASTER
        STATUS ON
        #DEBUG ON
        #TRANSPARENCY 70
        OFFSITE 255 255 255
        TILEITEM "location_path" #location_path is a column in above referenced 
POSTGIS table "tileindex_service_products" that stores the filepath to each 
image
        TILEINDEX "service_product_gc_idx" 
        PROJECTION
            "init=epsg:3785"
        END
        METADATA
            "ows_title" "Groundcover Map - April 2009"
            #"ows_group_title" "Service Products WS 2009"
            "wms_srs"   "EPSG:3785 EPSG:4269 EPSG:4326 EPSG:32610 EPSG:32611 
EPSG:32612 EPSG:32613 EPSG:32614 EPSG:26710 EPSG:26711 EPSG:26712 EPSG:26713 
EPSG:26714 EPSG:900913" #output
            #"ows_extent" "380000 5230000 530000 5390000"
            "ows_timeextent" "2009-04-15/2009-12-15"
            "ows_timeitem" "product_date" #yearmoda is our date column in shape 
of type date
            "ows_timedefault" "2009-04-15"
        END
        CLASS
            NAME "GCMap"
            KEYIMAGE "/srv/www/htdocs/nnn/GroundCover.png"
        END
    END
    LAYER
        NAME "serv_prod_gc20090515"
        #GROUP "service_products"
        TYPE RASTER
        STATUS ON
        #DEBUG ON
        #TRANSPARENCY 70
        OFFSITE 255 255 255
        TILEITEM "location_path" #location_path is a column in above referenced 
POSTGIS table "tileindex_service_products" that stores the filepath to each 
image
        TILEINDEX "service_product_gc_idx" 
        PROJECTION
            "init=epsg:3785"
        END
        METADATA
            "ows_title" "Groundcover Map - May 2009"
            "wms_srs"   "EPSG:3785 EPSG:4269 EPSG:4326 EPSG:32610 EPSG:32611 
EPSG:32612 EPSG:32613 EPSG:32614 EPSG:26710 EPSG:26711 EPSG:26712 EPSG:26713 
EPSG:26714 EPSG:900913" #output
            #"ows_extent" "380000 5230000 530000 5390000"
            "ows_timeextent" "2009-04-15/2009-12-15"
            "ows_timeitem" "product_date" #yearmoda is our date column in shape 
of type date
            "ows_timedefault" "2009-05-15"
        END
        CLASS
            NAME "GCMap"
            KEYIMAGE "/srv/www/htdocs/nnn/GroundCover.png"
        END
    END
    LAYER
        NAME "serv_prod_gc20090615"
        #GROUP "service_products"
        TYPE RASTER
        STATUS ON
        #DEBUG ON
        #TRANSPARENCY 70
        OFFSITE 255 255 255
        TILEITEM "location_path" #location_path is a column in above referenced 
POSTGIS table "tileindex_service_products" that stores the filepath to each 
image
        TILEINDEX "service_product_gc_idx" 
        PROJECTION
            "init=epsg:3785"
        END
        METADATA
            "ows_title" "Groundcover Map - June 2009"
            "wms_srs"   "EPSG:3785 EPSG:4269 EPSG:4326 EPSG:32610 EPSG:32611 
EPSG:32612 EPSG:32613 EPSG:32614 EPSG:26710 EPSG:26711 EPSG:26712 EPSG:26713 
EPSG:26714 EPSG:900913" #output
            #"ows_extent" "380000 5230000 530000 5390000"
            "ows_timeextent" "2009-04-15/2009-12-15"
            "ows_timeitem" "product_date" #yearmoda is our date column in shape 
of type date
            "ows_timedefault" "2009-06-15"
        END
        CLASS
            NAME "GCMap"
            KEYIMAGE "/srv/www/htdocs/nnn/GroundCover.png"
        END
    END
    LAYER
        NAME "serv_prod_gc20090715"
        #GROUP "service_products"
        TYPE RASTER
        STATUS ON
        #DEBUG ON
        #TRANSPARENCY 70
        OFFSITE 255 255 255
        TILEITEM "location_path" #location_path is a column in above referenced 
POSTGIS table "tileindex_service_products" that stores the filepath to each 
image
        TILEINDEX "service_product_gc_idx" 
        PROJECTION
            "init=epsg:3785"
        END
        METADATA
            "ows_title" "Groundcover Map - July 2009"
            "wms_srs"   "EPSG:3785 EPSG:4269 EPSG:4326 EPSG:32610 EPSG:32611 
EPSG:32612 EPSG:32613 EPSG:32614 EPSG:26710 EPSG:26711 EPSG:26712 EPSG:26713 
EPSG:26714 EPSG:900913" #output
            #"ows_extent" "380000 5230000 530000 5390000"
            "ows_timeextent" "2009-04-15/2009-12-15"
            "ows_timeitem" "product_date" #yearmoda is our date column in shape 
of type date
            "ows_timedefault" "2009-07-15"
        END
        CLASS
            NAME "GCMap"
            KEYIMAGE "/srv/www/htdocs/nnn/GroundCover.png"
        END
    END
...

https://10.20.2.45/map2/ows/allianz_brazil?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&WIDTH=1000&HEIGHT=1000&BBOX=-52,-23.8,-50,-13.55&SRS=EPSG:4326&FORMAT=image/jpeg&STYLES=&LAYERS=serv_prod_gc20090415,service_product_gc_idx


[Mon Oct 12 10:45:12 2009].604172 msWMSLoadGetMapParams(): WMS server error. 
Invalid layer(s) given in the LAYERS parameter.
[Mon Oct 12 10:45:45 2009].724205 msPostGISLayerWhichShapes(): Query error. 
Error (ERROR:  syntax error at or near ")"
LINE 1: ...and date_trunc('day', product_date) = '2009-04-15') and (dat...
                                                             ^
) executing query: select 
"product_date","location_path",encode(AsBinary(force_collection(force_2d("wkb_geom")),'NDR'),'base64')
 as geom,"service_product_id" from (SELECT * FROM 
ows_customer.tileindex_service_products tsp JOIN ows_customer.analysis_units au 
ON (au.unit_id=tsp.unit_id) JOIN ows_customer.service_product_types spt ON 
(tsp.product_type_id=spt.product_type_id) WHERE spt.name = 'GC' ) foo where 
wkb_geom && GeomFromText('POLYGON((-5788613.52125023 
-2729056.10763308,-5788613.52125023 -1522639.17855836,-5565974.53966368 
-1522639.17855836,-5565974.53966368 -2729056.10763308,-5788613.52125023 
-2729056.10763308))',3785) and date_trunc('day', product_date) = '2009-04-15') 
and (date_trunc('day', product_date) = '2009-05-15') and (date_trunc('day', 
product_date) = '2009-06-15') and (date_trunc('day', product_date) = 
'2009-07-15'
[Mon Oct 12 10:45:45 2009].724297 msDrawMap(): Image handling error. Failed to 
draw layer named 'serv_prod_gc20090415'.

Kind regards,
Peter
-- 
_______________________________________________________________________   

Peter Freimuth                          phone: +49 3381 8904327
Product Development                     fax:   +49 3381 8904101
RapidEye AG                             email: [email protected]
Molkenmarkt 30
14776 Brandenburg an der Havel          http://www.rapideye.de
Germany
_______________________________________________________________________   

PRIVILEGE AND CONFIDENTIALITY NOTICE:
The information in this email is intended for the named recipients 
only. It may contain privileged and confidential information.  If you 
have received this communication in error, any use, copying or 
dissemination of its contents is strictly prohibited.  Please erase all 
copies of the message along with any included attachments and notify 
RapidEye AG or the sender immediately by telephone at the number 
indicated on this page.
_______________________________________________________________________

RapidEye AG
Molkenmarkt 30
14776 Brandenburg an der Havel
Germany

Follow us on Twitter! www.twitter.com/rapideye_ag

Head Office/Sitz der Gesellschaft: Brandenburg an der Havel
Management Board/Vorstand: Wolfgang G. Biedermann
Chairman of Supervisory Board/Vorsitzender des Aufsichtsrates:
Juergen Breitkopf
Commercial Register/Handelsregister Potsdam HRB 17 796
Tax Number/Steuernummer: 048/100/00053
VAT-Ident-Number/Ust.-ID: DE 199331235
DIN EN ISO 9001 certified

*************************************************************************
Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
E-Mail irrtuemlich erhalten haben, informieren Sie bitte sofort den
Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie
die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.

The information in this e-mail is intended for the named recipients
only. It may contain privileged and confidential information. If you
have received this communication in error, any use, copying or
dissemination of its contents is strictly prohibited. Please erase all
copies of the message along with any included attachments and notify
RapidEye AG or the sender immediately by telephone at the number
indicated on this page.


--- End Message ---
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to