[mapserver-users] - Tile index

[Rahkonen Jukka (Tike)]

Hi Scott,

I managed to get PostGIS tileindex work as follows with Mapserver 6.5-dev:

	                CONNECTIONTYPE OGR
	                CONNECTION "PG:dbname=xxx host=yyy port=5432 user='zzz' password='xyz'"        
	                DATA "select * from tindextest"
	              #  FILTER "geom is not null"

and with native connection as
                CONNECTIONTYPE postgis
                CONNECTION "dbname=xxx host=yyy port=5432 user=zzz password='xyz'"        
                DATA "geom FROM tindextest USING UNIQUE gid USING srid=3067"
                #FILTER "geom is not null"

With both connection types I got this error before I commented the FILTER out:
 "msEvalExpression(): General error message. Cannot evaluate expression, no item index defined."

This feels like a bug that could be a side effect of new development made with filters. Make a ticket to Github if you can verify.

-Jukka Rahkonen-



scott159 at free.fr
 
> Hi,
> 
> I transfer this question to mapserver-users :
> I want to use mapserver with spatial index in postgres/postgis. The mapfile looks
> like :
> 
> ......
> 
>           LAYER
>                 NAME "footprint"
>                 STATUS ON
>                 TYPE POLYGON
>                 EXTENT -180 -90 180 90
>                 CONNECTIONTYPE postgis
>                 CONNECTION "dbname=test host=X.X.X.X port=5432 user='usr'
> password='pwd'"
>                 DATA "the_geom FROM view USING UNIQUE id USING srid=4326"
>                 FILTER "the_geom is not null"
>                 PROCESSING "CLOSE_CONNECTION=DEFER"
>                 OPACITY 100
>                 PROJECTION
>                         "init=epsg:4326"
>                 END
>                 CLASS
>                         NAME 'footprint1'
>                         STYLE
>                                 WIDTH 2
>                                 OUTLINECOLOR 0 0 0
>                                 OPACITY 10
>                         END
>                 END
>                 CLASS
>                         NAME 'footprint2'
>                         STYLE
>                                 WIDTH 2
>                                 OUTLINECOLOR 0 0 0
>                         END
>                 END
>         END
> 
>         LAYER
>                 DEBUG 3
>                 NAME "raster"
>                 STATUS ON
>                 TYPE RASTER
>                 OFFSITE 0 0 0
>                 OPACITY 100
>                 PROJECTION
>                         "init=epsg:4326"
>                 END
>                 TILEITEM "the_path"
>                 TILEINDEX "footprint"
>         END
> ......
> 
> With 6.4.1, everything is ok, raster layer is visible and there is no error in log file.
> But when I try to use this mapfile with 6.5-dev on x64 wheezy, only footprint
> layer is visible. The raster layer is not visible and it seems non item index is
> defined cf log file below :
> 
> ......
> msDrawRasterLayerLow(raster): entering.
> msEvalExpression(): General error message. Cannot evaluate expression, no
> item index defined.
> ......
> 
> How to defined item index with 6.5-dev ?
> 
> Cheers
> 
> 
> 
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users