QUERYMAP and postgis

[Peter Huis in 't Veld]

Bart,

Your right about the oid column, this is part of my dataset. I replaced 
the geom column by the oid.  The result is still the same.

Postgis   1.0.4
Postgres 8.03
MapServer 4.6

The problem I encounter are related to selecting the right coordinates 
on the map. I have debugged the queries and I did  forget to provide the 
tablename with a schema prefix (public). So, I only have to resolve the 
problem of pin pointing the right poi. Any suggestions? Can I switch on 
the display of the coordinates in my browser?

Peter



Bart van den Eijnden (OSGIS) wrote:

> Peter,
>
> I would never suggest using the geometry column as the unique column. 
> The default used is oid, but as you might know as of PostgreSQL 8.1 
> this is not created anymore automatically. Older PostgreSQL versions 
> do have it standard, so just leave out your USING UNIQUE in that case 
> from the DATA statement. Is there not a primary key on your table 
> which you can use otherwise instead of the geometry column?
>
> I would suggest getting some debug information out of Mapserver using 
> the practices described here:
>
> http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?DebuggingMapserver
>
> or just log the queries which Mapserver sends at the PostgreSQL level 
> (PostgreSQL logging).
>
> In order to solve this, tt might help also providing some version info 
> (which Mapserver version, which PostgreSQL version, which PostGIS 
> version etc.).
>
> Best regards,
> Bart
>
> Peter Huis in 't Veld wrote:
>
>> Hello
>>
>> I've the question: How can I show the attributes of a a postgis query 
>> using mapserver. At the moment I've GIS layer showing me all the 
>> object in the spatial database, so the query isn't isn't the problem. 
>> Changing the mode into query mode Ik get the following message:
>>
>> msQueryByPoint(): Search returned no results. No matching record(s) 
>> found.
>>
>> I've seen the remark on the mapserver web-site by Bart vd Eijnden, 
>> but this doesn't give me any additional info. I made the following 
>> changes
>> to the code in order to query the Map file by clicking on the map item:
>>
>> *QUERYMAP
>>   STATUS ON
>>   STYLE HILITE
>>   COLOR 0 255 0
>> END
>> *
>>
>> LAYER
>>    CONNECTIONTYPE POSTGIS
>>    CONNECTION  ....
>>    DATA "object_geom  from  (SELECT a, b, c, object_geom  from table) 
>> as myquery using unique object_geom"
>>    *TOLERANCE 5*
>>    CLASS
>>        LABEL
>>           ...
>>        END             END
>>  *  TEMPLATE "query_result.html"*
>>    PROJECTION
>>             ......
>>    END
>> END
>>
>> The query_result.html looks like:
>>
>>  <table>
>>     <tr>
>>       <td>[lrn]</td>
>>       <td>[a]</td>
>>       <td>[b]</td>
>>       <td>[c]</td>
>>     </tr>
>>  </table>
>>
>> Should the query_result.html be in a specific directory? I've places 
>> it in htdocs where my index.html is present.
>>
>> Thanks for any help!
>>
>> Peter
>>
>>
>
>