[Mapserver-users] Please help with Querying a Map (Postgis-Layer)

Antje Rosse antje.rosse at itc-halle.de
Fri Sep 12 07:37:05 EDT 2003 

The Error:

<!-- MapServer version 3.6.6 OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
SUPPORTS=TTF INPUT=TIFF INPUT=EPPL7 INPUT=JPEG INPUT=POSTGIS
INPUT=SHAPEFILE --> <BODY BGCOLOR="#FFFFFF">
msPOSTGISLayerGetShape(): Query error. Error executing POSTGIS  SQL
statement (in FETCH ALL): EXPLAIN VERBOSE SELECT * FROM punkte_tabelle
-
Error with POSTGIS data variable. You specified ''.<br> Standard ways of
specifiying are : <br>
(1) 'geometry_column from geometry_table' <br>
(2) 'geometry_column from (&lt;sub query&gt;) as foo using unique
&lt;column name&gt; using SRID=&lt;srid#&gt;' <br><br>

Make sure you put in the 'using unique  &lt;column name&gt;' and 'using
SRID=#' clauses in.

Table punkte_tabelle with index punkte_tabelle_oid_idx (oid).

My Layer-Definition:

LAYER
  CONNECTIONTYPE postgis
  NAME pers_punkte
  CONNECTION "user=postgres password=ppp dbname=test_db"
  DATA 'the_geom from punkte_tabelle using unique oid using SRID=-1'
  TYPE POINT
  STATUS ON
  HEADER
"/srv/www/htdocs/mapserver/test_mapplet/java/mapplet/halgis_pers_pkt_hea
der.html"
  FOOTER "halgis_alle_footer.html"
  CLASS
    NAME 'Punkte'
    TEMPLATE
"/srv/www/htdocs/mapserver/test_mapplet/java/mapplet/halgis_pers_pkt.htm
l"
    OUTLINECOLOR 0 0 220
    COLOR 0 0 220
    SYMBOL 'circle'
    size 12
  END
END

Thanks very much!

 mfg. Antje Rosse
 
------------------------------------------------------------------------
--
 IT-Consult Halle GmbH
 Bornknechtstraße 5, 06108 Halle (Saale)
 Sitz: Große Nikolaistr. 8
 Tel.: +49 345 221 4227, Fax: +49 345 221 4236
 Funk: +49 160 715 4526
 antje.rosse at itc-halle.de
 http://www.itc-halle.de

More information about the mapserver-users mailing list