[Users] Query joined tables by GetFeatureInfo

[Manuel Aymerich]

Hi Lucia,

 

Probably, the geoext users-list is not the right place to ask this type of
question.

To give you the right answer, we would need more information regarding the
technology and architecture you are using; please give us some technological
context if you want the right hint .

 

Anyway, assuming you are using mapserver and postgis for example, you could
implement a join directly in the mapfile like this:

CONNECTIONTYPE POSTGIS

CONNECTION "dbname=yourdatabasename user=yourdbusername"

DATA "the_geom from (select g.gid, g.the_geom, a.attr1, a.attr2 from
geotable g join attrtable a on g.gid = a.aid) as subquery unique gid using
srid=4326"

That should take care of the GetFeatureInfo join.

 

Regards,

 

Manuel Aymerich

 

R&D Project Manager

ARGONGRA, S.L.

Plaza San Juan de la Cruz, 7  ofic.2

28003 Madrid, SPAIN

maymerich at argongra.es <mailto:mjgarcia at argongra.com> 

www.argongra.com

(+34) - 91 129 96 35

 

 

 

--

Date: Tue, 29 Mar 2011 10:39:15 +0200
From: "Morper-Busch, Lucia" < <mailto:Lucia.Morper-Busch at sbg.ac.at>
Lucia.Morper-Busch at sbg.ac.at>
Subject: [Users] Query joined tables by GetFeatureInfo
To: < <mailto:users at geoext.org> users at geoext.org>
Message-ID:
        <
<mailto:7506863B0141334AA8B9FAAAC6D703B001F6A870 at MAIL2.plus.sbg.ac.at>
7506863B0141334AA8B9FAAAC6D703B001F6A870 at MAIL2.plus.sbg.ac.at>
Content-Type: text/plain; charset="us-ascii"

Hello GeoExt users,



do somebody have experiences with queries on joined tables via
GetFeatureInfo?

The intention is to get the description of a separate joined table
instead of only index values.



Is it possible to use the cql_filter?



Thank you

Lucia Morper-Busch



Dipl.-Geogr. Lucia Morper-Busch | Researcher

University of Salzburg | Centre for Geoinformatics - Z_GIS

Schillerstr.30 | Techno-Z, Block 15, 3rd floor | 5020 Salzburg, Austria

Phone +43 (0)662 8044 5298 | Fax +43 (0)662 8044 5260

> Z_GIS...experts for the spatial view < <http://www.zgis.at/research>
http://www.zgis.at/research>



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.geoext.org/pipermail/users/attachments/20110329/523d2ac8/attachment.htm