[ka-Map-users] arcsde/PostGIS query and search fails

Sat May 26 07:02:45 EDT 2007

Hi,

I have a very similar problem except that I exchanged my shapefile with a PostGIS-database:
Using a shapefile search and queries on Kamap work. After converting this shapefile to PostGIS
and using this in Kamap-mapfile the PostGIS-Layer is drawn correctly and also the query-function 
works but the search-function always ends with "no matching results".

Any ideas why Kamap treats data from shapefiles and databases do different ?

This is my Layer / template. Are there any mistakes that I am not aware of ?

This is the template-html:

<html>
  <head><title>Sample Template</title></head>
  <body>
     <li> name is [name]

  </body>
</html>

This is the Layer

LAYER
    NAME "CTY-XL"
    GROUP "CTY"
    STATUS default
    DATA "the_geom from name"
    CONNECTION "user=postgres dbname=cities host=localhost port=5432"
    CONNECTIONTYPE postgis
    TYPE POINT
    CLASSITEM "Name"
    MAXSCALE 27683991
    MINSCALE 1689
    LABELITEM "name"
    SYMBOLSCALE 3460499
    CLASS
      TEMPLATE "template-city.html"
      NAME "CTY-XL"

      LABEL
        PARTIALS FALSE
        FORCE TRUE
        TYPE TRUETYPE
	  FONT arialbd
        SIZE 12
        MAXSIZE 12
        MINSIZE 10
        SHADOWCOLOR 0 0 0
	  SHADOWSIZE 4 4
        POSITION AUTO
        COLOR 255 255 255
        OUTLINECOLOR 0 0 255 
      END
      STYLE
        SYMBOL "quadrat_solid"
        COLOR 0 0 255
        SIZE 6
        MAXSIZE 8
      END
     STYLE
        SYMBOL "quadrat_solid"
        COLOR 255 255 0
        SIZE 4
        MAXSIZE 6
      END

    END

  METADATA
   "queryable" "true"
   "searchfield" "name"
   "fields" "name:name"
  END

  END

> -----Ursprüngliche Nachricht-----
> Von: "János Gonzales" <janos.gonzales at gmail.com>
> Gesendet: 25.05.07 21:45:22
> An: ka-map-users at lists.maptools.org
> Betreff: [ka-Map-users] arcsde query and search fails

> 
> Hello,
> 
> I have two kamap  maps. One has a shapefile source the other  has
> layers coming from ArcSDE.     In the shapefile application, I'm able
> to query and search the map without any problems and use the
> index_query.html template to create a highlight overlay of the
> selected item.
> 
> In the ArcSDE map, which is identical to the first map, except the
> data source is from arcsde, the search function does not work at all.
> It brings up no results.  The highlighting doesn't work at all, and
> the query function just works intermitently.  Queries on one layer
> work fine,  but on two layers they always give errors like:
> 
> Fatal error: [MapServer Error]: msSDELayerGetShape():
> SE_stream_fetch_row(): Invalid parameter value passed to function.
> (-66) in C:\ArcIMS\Website\kamap\htdocs\map_query_float.php on line
> 228
> 
> By 'query' i mean using the little i  tool.
> 
> Is this a kamap problem or a configuration problem ?
> 
> Thanks,
> Janos
> _______________________________________________
> ka-Map-users mailing list
> ka-Map-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/ka-map-users
> 

_______________________________________________________________
SMS schreiben mit WEB.DE FreeMail - einfach, schnell und
kostenguenstig. Jetzt gleich testen! http://f.web.de/?mc=021192