[ka-Map-users] queries with postgis

[Lorenzo Becchi]

Hola Augustina,

first a ka-map search metadata issue.
http://ka-map.ominiverdi.org/wiki/index.php/Mapfile_Metadata_Configuration#Mapfile_LAYER_Section

see "fields"

you should set

METADATA
    "fields" "lrn:myAlias1,adm0:myAlias2"
    ...
END

you can set the TEMPLATE as "foo.bar" because it is not used by ka-map.



then a mapserver/postgis issue.

how can you ask for some fields if  your query returns only the geom?

DATA "the_geom FROM argentina1"

you should do a query like this:
DATA "the_geom from (SELECT landuse.object_id, landuse.area,
forest.type, forest.the_geom FROM landuse INNER JOIN forest ON
landuse.gid = forest.gid) as foo using unique gid using
SRID=4326"

got from:
http://www.mapbender.org/presentations/Spatial_Data_Management_Arnulf_Christl/Spatial_Data_Management_Arnulf_Christl.pdf


but I guess ka-Map query has still an issue with this kind of postgis 
queries and need a fix.

Is there anybody that solved this problem?

ciao
Lorenzo