<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:v = "urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META http-equiv=Content-Type content=text/html;charset=iso-8859-1>
<META content="MSHTML 6.00.6002.18357" name=GENERATOR>
<STYLE><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;}
span.E-MailFormatvorlage19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
p.HTMLconformatoprevio, li.HTMLconformatoprevio, div.HTMLconformatoprevio
{mso-style-name:"HTML con formato previo";
mso-style-link:"HTML con formato previo Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.HTMLconformatoprevioCar
{mso-style-name:"HTML con formato previo Car";
mso-style-priority:99;
mso-style-link:"HTML con formato previo";
font-family:"Courier New";}
span.E-MailFormatvorlage22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></STYLE>
</HEAD>
<BODY lang=DE-AT id=MailContainerBody
style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px" vLink=purple
link=blue leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT face=Arial size=2>if you have Geoserver 2.1+, then you can do this
via the new SQL Query layer type.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><A
href="http://underdark.wordpress.com/2010/12/02/layers-from-sql-query-with-geoserver-2-1/"><FONT
title="http://underdark.wordpress.com/2010/12/02/layers-from-sql-query-with-geoserver-2-1/ CTRL + Click to follow link"
color=#0066cc>http://underdark.wordpress.com/2010/12/02/layers-from-sql-query-with-geoserver-2-1/</FONT></A></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><A href="http://docs.geoserver.org/stable/en/user/data/sqlview.html"><FONT
color=#0066cc>http://docs.geoserver.org/stable/en/user/data/sqlview.html</FONT></A></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Matt Priour</FONT></DIV>
<DIV style="FONT: 10pt Tahoma">
<DIV><BR></DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A
title=Lucia.Morper-Busch@sbg.ac.at
href="mailto:Lucia.Morper-Busch@sbg.ac.at">Morper-Busch, Lucia</A> </DIV>
<DIV><B>Sent:</B> Tuesday, March 29, 2011 8:02 AM</DIV>
<DIV><B>To:</B> <A title=maymerich@argongra.es
href="mailto:maymerich@argongra.es">Manuel Aymerich</A> </DIV>
<DIV><B>Cc:</B> <A title=users@geoext.org
href="mailto:users@geoext.org">users@geoext.org</A> </DIV>
<DIV><B>Subject:</B> Re: [Users] Query joined tables by
GetFeatureInfo</DIV></DIV></DIV>
<DIV><BR></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN lang=EN-US style="COLOR: #1f497d">Hi
Manuel,<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US style="COLOR: #1f497d">thank you for your
answer:<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US style="COLOR: #1f497d">my architecture is
GeoExt – Geoserver – PostGIS.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US style="COLOR: #1f497d">I can create a view
with joined tables in PostGIS, but I don’t want to join the entire table, but
only the requested feature.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US style="COLOR: #1f497d">I don’t know if it’s
clear now.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US style="COLOR: #1f497d">Thank you
anyway.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="COLOR: #1f497d">lucia<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 1pt"><B><SPAN lang=EN-US
style="FONT-SIZE: 8pt; COLOR: #365f91; FONT-FAMILY: 'Verdana','sans-serif'">Dipl.-Geogr.
Lucia Morper-Busch</SPAN></B><B><SPAN lang=EN-US
style="FONT-SIZE: 8pt; COLOR: #1f497d; FONT-FAMILY: 'Verdana','sans-serif'"> |
</SPAN></B><B><SPAN lang=EN-US
style="FONT-SIZE: 8pt; COLOR: #c00000; FONT-FAMILY: 'Verdana','sans-serif'">Researcher</SPAN></B><B><SPAN
lang=EN-US
style="FONT-SIZE: 8pt; COLOR: #1f497d; FONT-FAMILY: 'Verdana','sans-serif'"><o:p></o:p></SPAN></B></P>
<P class=MsoNormal style="MARGIN-BOTTOM: 1pt"><SPAN lang=EN-US
style="FONT-SIZE: 8pt; COLOR: gray; FONT-FAMILY: 'Verdana','sans-serif'">University
of Salzburg | Centre for Geoinformatics - Z_GIS<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-BOTTOM: 1pt"><SPAN lang=EN-US
style="FONT-SIZE: 8pt; COLOR: gray; FONT-FAMILY: 'Verdana','sans-serif'">Schillerstr.30
| Techno-Z, Block 15, 3rd floor | 5020 Salzburg, Austria<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8pt; COLOR: gray; FONT-FAMILY: 'Verdana','sans-serif'">Phone
+43 (0)662 8044 5298 | Fax +43 (0)662 8044 5260<o:p></o:p></SPAN></P>
<P class=MsoNormal><B><I><SPAN lang=EN-US
style="FONT-SIZE: 8pt; COLOR: gray; FONT-FAMILY: 'Verdana','sans-serif'">> <A
href="http://www.zgis.at/research"><SPAN
style="COLOR: gray; TEXT-DECORATION: none">Z_GIS…experts for the spatial
view</SPAN></A><o:p></o:p></SPAN></I></B></P></DIV>
<P class=MsoNormal><SPAN lang=EN-US><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN lang=DE
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">Von:</SPAN></B><SPAN
lang=DE style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> Manuel
Aymerich [mailto:maymerich@argongra.es] <BR><B>Gesendet:</B> Dienstag, 29. März
2011 12:58<BR><B>An:</B> Morper-Busch, Lucia<BR><B>Cc:</B>
users@geoext.org<BR><B>Betreff:</B> Re: Query joined tables by
GetFeatureInfo<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN lang=EN-US style="FONT-SIZE: 10pt">Hi
Lucia,<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US style="FONT-SIZE: 10pt">Probably, the geoext
users-list is not the right place to ask this type of
question.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US style="FONT-SIZE: 10pt">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 .<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US style="FONT-SIZE: 10pt">Anyway, assuming you
are using mapserver and postgis for example, you could implement a join directly
in the mapfile like this:<o:p></o:p></SPAN></P>
<DIV
style="BORDER-RIGHT: #c6c9cb 1pt solid; PADDING-RIGHT: 8pt; BORDER-TOP: #c6c9cb 1pt solid; PADDING-LEFT: 8pt; PADDING-BOTTOM: 8pt; BORDER-LEFT: #c6c9cb 1pt solid; PADDING-TOP: 8pt; BORDER-BOTTOM: #c6c9cb 1pt solid">
<P class=MsoNormal
style="BACKGROUND: white; MARGIN-BOTTOM: 18pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 18.0pt"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; COLOR: #222222; FONT-FAMILY: 'Courier New'">CONNECTIONTYPE
POSTGIS<o:p></o:p></SPAN></P>
<P class=MsoNormal
style="BACKGROUND: white; MARGIN-BOTTOM: 18pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 18.0pt"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; COLOR: #222222; FONT-FAMILY: 'Courier New'">CONNECTION
"dbname=yourdatabasename user=yourdbusername"<o:p></o:p></SPAN></P>
<P class=MsoNormal
style="BACKGROUND: white; MARGIN-BOTTOM: 18pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; mso-margin-top-alt: 18.0pt"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; COLOR: #222222; FONT-FAMILY: 'Courier New'">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"<o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><SPAN lang=EN-US style="FONT-SIZE: 10pt">That should take
care of the GetFeatureInfo join.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Regards,<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US style="FONT-SIZE: 10pt">Manuel
Aymerich<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US style="FONT-SIZE: 10pt">R&D Project
Manager<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt; COLOR: #c00000">ARGONGRA, S.L.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=ES style="FONT-SIZE: 10pt">Plaza San Juan de la
Cruz, 7 ofic.2<SPAN style="COLOR: black"><o:p></o:p></SPAN></SPAN></P>
<P class=MsoNormal><SPAN lang=ES style="FONT-SIZE: 10pt">28003 Madrid,
SPAIN<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=ES style="FONT-SIZE: 10pt"><A
href="mailto:mjgarcia@argongra.com">maymerich@argongra.es</A><SPAN
style="COLOR: black"><o:p></o:p></SPAN></SPAN></P>
<P class=MsoNormal><SPAN lang=ES style="FONT-SIZE: 10pt"><A
href="http://www.argongra.com">www.argongra.com</A><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=ES style="FONT-SIZE: 10pt">(+34) - 91 129 96
35<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt">--<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Arial','sans-serif'">Date: Tue, 29 Mar 2011
10:39:15 +0200<BR>From: "Morper-Busch, Lucia" <</SPAN><SPAN lang=ES
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Arial','sans-serif'"><A
href="mailto:Lucia.Morper-Busch@sbg.ac.at"><SPAN
lang=EN-US>Lucia.Morper-Busch@sbg.ac.at</SPAN></A></SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Arial','sans-serif'">><BR>Subject:
[Users] Query joined tables by GetFeatureInfo<BR>To: <</SPAN><SPAN lang=ES
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Arial','sans-serif'"><A
href="mailto:users@geoext.org"><SPAN
lang=EN-US>users@geoext.org</SPAN></A></SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Arial','sans-serif'">><BR>Message-ID:<BR>
<</SPAN><SPAN lang=ES
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Arial','sans-serif'"><A
href="mailto:7506863B0141334AA8B9FAAAC6D703B001F6A870@MAIL2.plus.sbg.ac.at"><SPAN
lang=EN-US>7506863B0141334AA8B9FAAAC6D703B001F6A870@MAIL2.plus.sbg.ac.at</SPAN></A></SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Arial','sans-serif'">><BR>Content-Type:
text/plain; charset="us-ascii"<BR><BR>Hello GeoExt users,<BR><BR><BR><BR>do
somebody have experiences with queries on joined tables
via<BR>GetFeatureInfo?<BR><BR>The intention is to get the description of a
separate joined table<BR>instead of only index values.<BR><BR><BR><BR>Is it
possible to use the cql_filter?<BR><BR><BR><BR>Thank you<BR><BR>Lucia
Morper-Busch<BR><BR><BR><BR>Dipl.-Geogr. Lucia Morper-Busch |
Researcher<BR><BR>University of Salzburg | Centre for Geoinformatics -
Z_GIS<BR><BR>Schillerstr.30 | Techno-Z, Block 15, 3rd floor | 5020 Salzburg,
Austria<BR><BR>Phone +43 (0)662 8044 5298 | Fax +43 (0)662 8044 5260<BR><BR>>
Z_GIS...experts for the spatial view <</SPAN><SPAN lang=ES
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Arial','sans-serif'"><A
href="http://www.zgis.at/research"><SPAN
lang=EN-US>http://www.zgis.at/research</SPAN></A></SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Arial','sans-serif'">><o:p></o:p></SPAN></P></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>Users mailing
list<BR>Users@geoext.org<BR>http://www.geoext.org/cgi-bin/mailman/listinfo/users<BR></BODY></HTML>