[Geomoose-users] Identify service - database issue

[Brent Fraser]

Stathis,

   Brian is talking about a database view, an object you can access the 
same way as a table, but is dynamic as it "refers" to one or more tables 
instead of duplicating the data in them.  Have a look at your databse 
documentation for more information.

Best Regards,
Brent Fraser


On 3/9/2011 1:06 PM, Efstathios Arapostathis wrote:
> 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 <mailto: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
>     <mailto:bfraser at geoanalytic.com>]
>     *Sent:* Sunday, March 06, 2011 12:59 PM
>     *To:* Efstathios Arapostathis
>     *Cc:* geomoose-users at lists.sourceforge.net
>     <mailto: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/20110310/cb1556ee/attachment.html