[postgis-users] how can I do query postgis through mapserver.

[Lee Keel]

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Amrita p
Sent: Wednesday, November 14, 2007 12:35 AM
To: PostGIS Users Discussion
Subject: [postgis-users] how can I do query postgis through mapserver.

 

Hi All,

I want to use query layer function of MapServer with postgis. this function
working fine with shape file but not with postgis database.

Please answer soon if any one has any idea abt this.

Regards,
Amrita  

 

[Lee Keel] 

Amrita,

You probably are using the wrong list for this.  You should try
MAPSERVER-USERS at LISTS.UMN.EDU.  However below is an example:

 

In this sample below you can use this to use the name as a label and
the_geom is your geometry field for the feature.

CONNECTIONTYPE postgis

CONNECTION "user=mapreader dbname=testDB host=localhost" 

DATA "the_geom from (select prikey, name, the_geom from tbl) as foo using
srid=2236, using unique prikey"

PROCESSING "CLOSE_CONNECTION=DEFER"

 

Hope that helps.

-Lee

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071114/3e249704/attachment.html>