[mapserver-users] Expression and nquery with sde issue
Steve Lime
sdlime at gmail.com
Fri Jul 15 07:23:54 PDT 2011
On issue one, what version are you using? MapServer shouldn't be rounding the value. The comparison should be being done as a double. It might be helpful to see a sample dataset although if this is SDE I can't test on my end. One thing to try to help diagnose the problem would be to create a sample mapfile that draws your layer and uses the area attribute for labeling. What shows up for labels?
Steve
Sent from my iPad
On Jul 15, 2011, at 5:14 AM, Mario Franco <mario.franco at ydreams.com> wrote:
> Hi,
>
> I having two issues with mapserver if anyone can help me I would be appreciated.
>
> The first has to do with an Expression in a class:
>
> I have a shape with an attribute with the 172060.0937 but when add to the class:
>
>> EXPRESSION ( [AREA] = 172060.0937 )
>
> The problem is that this expression returns false because mapserver is rounding the double value from the database. If I compare with:
>
>> EXPRESSION ( [AREA] = 172060)
>
> it works. There is any way to turn this off or to increase the precision?
>
>
>
> The second issue is:
>
> I'm using this url (http://localhost:82/cgi-bin/mapserv.exe?map=D%3a\projects\Inag\InterSIG+II\InterSIG+Website\Trunk\InterSIG+ASP.NET\Maps%2fintersig_281.map&qlayer=Concelhos&layers=Concelhos&MAPSIZE=629%20467&MINX=-232614.525612302&MINY=-49761.6088409424&MAXX=676601.080299802&MAXY=625284&mode=NQUERY&MAPSHAPE=POLYGON%28%28-232614%20-49761,%20-232614%20625284,%20676601%20625284,%20676601%20-49761,%20-232614%20-49761%29%29) to execute a nquery but I always get the error "msSDELayerGetShape(): SDE error. SE_stream_fetch_row(): Invalid parameter value passed to function. (-66) "
>
> The log doesn't help that much:
>
>> [Fri Jul 15 10:47:19 2011].20000 msSDELayerOpen(): Layer Concelhos opened from scratch.
>> [Fri Jul 15 10:47:23 2011].35000 msConnPoolRegister(Concelhos,ydinag2,port:5151,sde,sde,sde,01D6BCC0)
>> [Fri Jul 15 10:47:23 2011].35000 msSDELayerOpen(): Layer Concelhos specified version SDE.DEFAULT.
>> [Fri Jul 15 10:47:23 2011].42000 msSDEGetLayerInfo(): Looking for layer by SDE.CONCELH_PTCONT_2008_0_596, SHAPE, ydinag2,port:5151,sde,sde,sde
>> [Fri Jul 15 10:47:23 2011].42000 msSDEGetLayerInfo(): No cached layerid found.
>> [Fri Jul 15 10:47:23 2011].63000 msSDELCacheAdd(): Caching id for SDE.CONCELH_PTCONT_2008_0_596, SHAPE, ydinag2,port:5151,sde,sde,sde
>> [Fri Jul 15 10:47:23 2011].72000 Getting all column information in msSDELayerInitItemInfo
>> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for DICO
>> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for CONCELHO
>> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for DI
>> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for DISTRITO
>> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for CCDR
>> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for NUT3
>> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for NUT3_NOME
>> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for NUT2
>> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for NUT2_NOME
>> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for AREA2008_1
>> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for objectid
>> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for SHAPE
>> [Fri Jul 15 10:47:23 2011].79000 Column information has already been gotten... returning from msSDELayerInitItemInfo
>> [Fri Jul 15 10:47:43 2011].122000 msSDELayerGetShape(): SDE error. SE_stream_fetch_row(): Invalid parameter value passed to function. (-66)
>> [Fri Jul 15 10:47:43 2011].126000 msFreeMap(): freeing map at 01D3EFE8.
>> [Fri Jul 15 10:47:43 2011].126000 msSDELayerCloseConnection(): Closing connection for layer Concelhos.
>> [Fri Jul 15 10:47:43 2011].126000 msConnPoolRelease(Concelhos,ydinag2,port:5151,sde,sde,sde,01D6BCC0)
>> [Fri Jul 15 10:47:43 2011].126000 msConnPoolClose(ydinag2,port:5151,sde,sde,sde,01D6BCC0)
>> [Fri Jul 15 10:47:43 2011].156000 msSDELayerClose(): Closing layer Concelhos.
>> [Fri Jul 15 10:47:43 2011].156000 msConnPoolRelease(Concelhos,ydinag2,port:5151,sde,sde,sde,00000000)
>> [Fri Jul 15 10:47:43 2011].156000 msConnPoolRelease(): Unable to find handle for layer 'Concelhos'.
>> [Fri Jul 15 10:47:43 2011].156000 msConnPoolRelease(): General error message. Unable to find handle for layer 'Concelhos'.
>
>
> Here part of my configuration:
>> LAYER
>> NAME "Concelhos"
>> METADATA
>> "wms_title" "Concelhos" # required
>> "wfs_title" "Concelhos" # required
>> "gml_featureid" "ID" ## REQUIRED
>> "gml_geometries" "geom"
>> "gml_geom_type" "polygon"
>> "gml_include_items" "all" # Optional (serves all attributes for layer)
>> "gml_exclude_items" "GEOMETRY,OBJECTID"
>> "ows_include_items" "all"
>> "ows_exclude_items" "GEOMETRY,OBJECTID"
>> END
>> DUMP true
>> TOLERANCE 10
>> TOLERANCEUNITS meters
>>
>> TYPE polygon
>>
>> #CONNECTIONTYPE SDE
>> CONNECTIONTYPE PLUGIN
>> PLUGIN "D:/ms4w/Apache/specialplugins/msplugin_sde_92.dll"
>> CONNECTION "ydinag2,port:5151,sde,sde,sde"
>>
>> DATA "SDE.CONCELH_PTCONT_2008_0_596,SHAPE,SDE.DEFAULT"
>>
>> PROJECTION
>> "init=EPSG:3763" #--sistema de coordenadas desta layer na origem
>> END
>>
>> STATUS ON
>> OPACITY 100
>> TEMPLATE '../Templates/Identify/t.html'
>
> I'm using Mapserver 5.6.3, I know it's not the latest but I didn't updated yet.
>
> Any help would be useful and thx in advance.
>
> Mário Franco
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20110715/0c211193/attachment.htm>
More information about the MapServer-users
mailing list