[Geomoose-users] Identify service - database issue

[Brian Fischer]

We will typically just create a view that has all the information that you want to use for identify results in it.  MapServer connects to views just like tables.

The join would work as well.

Brian Fischer, CFM  GIS Manager
Houston Engineering, Inc.
Phone: Direct: 763-493-6664 / W: 763.493.4522 / M: 763.229.2734

From: Brent Fraser [mailto:bfraser at geoanalytic.com]
Sent: Sunday, March 06, 2011 12:59 PM
To: Efstathios Arapostathis
Cc: geomoose-users at lists.sourceforge.net
Subject: Re: [Geomoose-users] Identify service - database issue

Stathis

Have a look at the mapserver documentation on PostGIS (http://mapserver.org/input/vector/postgis.html), especially the examples showing a "join"


Best Regards,

Brent Fraser

On 3/6/2011 5:32 AM, Efstathios Arapostathis wrote:
    Hi,

   I have a PostGIS database with two tables:

   The first table is called "Averofdata" and has geometry information and some other attributes. Primary key for that table is column "gid"
The second table is called "Events" and has additional information regarding table "Averofdata". Primary key for that table is columd "eventid"

A have created a "New foreign key" constraint with these two keys.


    My question is:

How could I display information from table "Events" in Geomoose using the identify

Thanks!


Best regards,
Stathis Arapostathis
Student:
PHD Candidate,
Harokopion University of Athens





------------------------------------------------------------------------------

What You Don't Know About Data Connectivity CAN Hurt You

This paper provides an overview of data connectivity, details

its effect on application quality, and explores various alternative

solutions. http://p.sf.net/sfu/progress-d2d





_______________________________________________

Geomoose-users mailing list

Geomoose-users at lists.sourceforge.net<mailto:Geomoose-users at lists.sourceforge.net>

https://lists.sourceforge.net/lists/listinfo/geomoose-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20110306/5f7ed432/attachment.html