[Geomoose-users] Identify service - database issue

[Efstathios Arapostathis]

Hi,

   I'm not sure that I understand for what the term "view" stands..
Stathis

On Mon, Mar 7, 2011 at 12:06 AM, Brian Fischer <bfischer at houstoneng.com>wrote:

>  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
>
> https://lists.sourceforge.net/lists/listinfo/geomoose-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20110309/cbc536b9/attachment.html