[Geomoose-users] Identify service - database issue
Brent Fraser
bfraser at geoanalytic.com
Thu Mar 10 11:11:17 EST 2011
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
More information about the Geomoose-users
mailing list