<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hello,<br>
<br>
I've read this and I'm confused of how it can work...<br>
ONE-TO-ONE or ONE-TO-MANY or ... I want to have a solution
*scream* If both layers are queried it should be one table,
because the date is the same. Only the class item differs.<br>
<img src="cid:part1.06070901.07010505@tds-net.de" alt=""><br>
<br>
Example Mapfile:<br>
<small><tt> LAYER</tt><tt><br>
</tt><tt> STATUS on</tt><tt><br>
</tt><tt> NAME "Trinkwasserversorgung"</tt><tt><br>
</tt><tt> TYPE POLYGON</tt><tt><br>
</tt><tt> DATA "wv_wilster_84.shp"</tt><tt><br>
</tt><tt> DUMP true</tt><tt><br>
</tt><tt> TOLERANCE 3</tt><tt><br>
</tt><tt> TOLERANCEUNITS pixels</tt><tt><br>
</tt><tt> CLASSITEM "TW"</tt><tt><br>
</tt><tt><br>
</tt><tt> HEADER "templates/header.html"</tt><tt><br>
</tt><tt> TEMPLATE "templates/template.html"</tt><tt><br>
</tt><tt> FOOTER "templates/footer.html"</tt><tt><br>
</tt><tt><br>
</tt><tt> JOIN </tt><tt><br>
</tt><tt> NAME "Wasser" </tt><tt><br>
</tt><tt> TABLE "wv_wilster_84.dbf" </tt><tt><br>
</tt><tt> FROM "Id" </tt><tt><br>
</tt><tt> TO "Id" </tt><tt><br>
</tt><tt> TYPE ONE-TO-ONE </tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt><br>
</tt><tt> CLASS</tt><tt><br>
</tt><tt> NAME "Trinkwasser"</tt><tt><br>
</tt><tt> EXPRESSION "Trinkwasser"</tt><tt><br>
</tt><tt> STYLE</tt><tt><br>
</tt><tt> COLOR 130 192 255</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt> STYLE</tt><tt><br>
</tt><tt> OUTLINECOLOR 120 120 120</tt><tt><br>
</tt><tt> WIDTH 2</tt><tt><br>
</tt><tt> ANTIALIAS TRUE</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt><br>
</tt><tt> CLASS</tt><tt><br>
</tt><tt> NAME "Selbstversorger"</tt><tt><br>
</tt><tt> STYLE</tt><tt><br>
</tt><tt> SYMBOL "im_schraffur"</tt><tt><br>
</tt><tt> END </tt><tt><br>
</tt><tt> EXPRESSION "Selbstversorger"</tt><tt><br>
</tt><tt> STYLE</tt><tt><br>
</tt><tt> OUTLINECOLOR 120 120 120</tt><tt><br>
</tt><tt> WIDTH 2</tt><tt><br>
</tt><tt> ANTIALIAS TRUE</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt><br>
</tt><tt> PROJECTION</tt><tt><br>
</tt><tt> "init=epsg:4326"</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt><br>
</tt><tt> METADATA</tt><tt><br>
</tt><tt> "wms_title" "Verbandsgebiet"</tt><tt><br>
</tt><tt> "wms_title metadata" ""</tt><tt><br>
</tt><tt> "wms_include_items" "all"</tt><tt><br>
</tt><tt> "wms_srs" "EPSG:4326
EPSG:54004 EPSG:41001 EPSG:31467 EPSG:31468"</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt><br>
</tt><tt> LAYER</tt><tt><br>
</tt><tt> STATUS on</tt><tt><br>
</tt><tt> NAME "Abwasserentsorgung"</tt><tt><br>
</tt><tt> TYPE POLYGON</tt><tt><br>
</tt><tt> DATA "wv_wilster_84.shp"</tt><tt><br>
</tt><tt> DUMP true</tt><tt><br>
</tt><tt> TOLERANCE 3</tt><tt><br>
</tt><tt> TOLERANCEUNITS pixels</tt><tt><br>
</tt><tt> CLASSITEM "AW"</tt><tt><br>
</tt><tt><br>
</tt><tt> HEADER "templates/header.html"</tt><tt><br>
</tt><tt> TEMPLATE "templates/template.html"</tt><tt><br>
</tt><tt> FOOTER "templates/footer.html"</tt><tt><br>
</tt><tt><br>
</tt><tt> JOIN </tt><tt><br>
</tt><tt> NAME "Wasser" </tt><tt><br>
</tt><tt> TABLE "wv_wilster_84.dbf" </tt><tt><br>
</tt><tt> FROM "Id" </tt><tt><br>
</tt><tt> TO "Id" </tt><tt><br>
</tt><tt> TYPE ONE-TO-ONE </tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt><br>
</tt><tt> CLASS</tt><tt><br>
</tt><tt> NAME "Abwasser"</tt><tt><br>
</tt><tt> EXPRESSION "Abwasser"</tt><tt><br>
</tt><tt> STYLE</tt><tt><br>
</tt><tt> COLOR 255 128 0</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt> STYLE</tt><tt><br>
</tt><tt> OUTLINECOLOR 120 120 120</tt><tt><br>
</tt><tt> WIDTH 2</tt><tt><br>
</tt><tt> ANTIALIAS TRUE</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt><br>
</tt><tt> CLASS</tt><tt><br>
</tt><tt> NAME "Diverse Abwasseraufgaben"</tt><tt><br>
</tt><tt> STYLE</tt><tt><br>
</tt><tt> SYMBOL "schraffur_orange"</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt> EXPRESSION "Diverse Abwasseraufgaben"</tt><tt><br>
</tt><tt> STYLE</tt><tt><br>
</tt><tt> OUTLINECOLOR 120 120 120</tt><tt><br>
</tt><tt> WIDTH 2</tt><tt><br>
</tt><tt> ANTIALIAS TRUE</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt><br>
</tt><tt> CLASS</tt><tt><br>
</tt><tt> NAME "Kein Abwasser"</tt><tt><br>
</tt><tt> EXPRESSION "Kein Abwasser"</tt><tt><br>
</tt><tt> STYLE</tt><tt><br>
</tt><tt> OUTLINECOLOR 120 120 120</tt><tt><br>
</tt><tt> WIDTH 2</tt><tt><br>
</tt><tt> ANTIALIAS TRUE</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt><br>
</tt><tt> PROJECTION</tt><tt><br>
</tt><tt> "init=epsg:4326"</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt><br>
</tt><tt> METADATA</tt><tt><br>
</tt><tt> "wms_title" "Abwasser"</tt><tt><br>
</tt><tt> "wms_title metadata" ""</tt><tt><br>
</tt><tt> "wms_include_items" "all"</tt><tt><br>
</tt><tt> "wms_srs" "EPSG:4326
EPSG:54004 EPSG:41001 EPSG:31467 EPSG:31468"</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt><tt> END</tt><tt><br>
</tt></small><br>
<br>
<br>
<div class="moz-signature">Bye, TDS
<hr>
<font size="-1">
<a class="moz-txt-link-freetext" href="mailto:tds@tds-net.de">mailto:tds@tds-net.de</a><br>
</font>
<hr>
<font size="-1">
1+1=10<br>
You have a question? - 42 or RTFM.
</font>
</div>
Am 26.03.2014 21:50, schrieb <a class="moz-txt-link-abbreviated" href="mailto:jt@mapmedia.de">jt@mapmedia.de</a>:<br>
</div>
<blockquote cite="mid:7429cab1e41acd8c9d5cbfec4770b2b8@mapmedia.de"
type="cite">
<p>Hi,</p>
<p>Referring to your signatur: rtfm ;)</p>
<p>Try <a class="moz-txt-link-freetext" href="http://mapserver.org/de/mapfile/join.htm">http://mapserver.org/de/mapfile/join.htm</a></p>
<p>Join streets_main with the dbf of streets_sub. Read the doc
carefuly, it's a bit tricky.</p>
<p>You may find a working example under
<a class="moz-txt-link-freetext" href="http://mapmedia.de/downloads/viewcategory/5-vortraege">http://mapmedia.de/downloads/viewcategory/5-vortraege</a> (</p>
<p>Workshop_umn...)</p>
<p>Jörg</p>
<p> </p>
<p>On Wed, 26 Mar 2014 20:58:17 +0100, TDS wrote:</p>
<blockquote type="cite" style="padding-left:5px;
border-left:#1010ff 2px solid; margin-left:5px; width:100%"><span
style="font-family: sans-serif; font-size: medium;">
<blockquote style="display: inline !important;">Hello,</blockquote>
</span></blockquote>
<blockquote type="cite" style="padding-left:5px;
border-left:#1010ff 2px solid; margin-left:5px; width:100%"><br>
is it possible to join two layers in GetFeatureInfo with same
template and same shape file to output only one combined html
file?<br>
<br>
Example:<br>
Streets_Main => streets.shp => template.html<br>
Streets_Sub => streets.shp => template.html<br>
<br>
OUTPUT:<br>
<br>
Current:<br>
Output for Streets_Mains<br>
Output for Streets_Sub<br>
<br>
Wish:<br>
<br>
Streets_Mains unique id Streets_sub (e.g. main street and sub
street have both id=1 in shape file)<br>
<br>
<br>
</blockquote>
<blockquote type="cite" style="padding-left:5px;
border-left:#1010ff 2px solid; margin-left:5px; width:100%">
<div class="moz-signature">-- <br>
Bye, TDS
<hr>
<span> <a moz-do-not-send="true"
class="moz-txt-link-freetext" href="mailto:tds@tds-net.de">mailto:tds@tds-net.de</a><br>
</span>
<hr>
<span> 1+1=10<br>
You have a question? - 42 or RTFM. </span></div>
</blockquote>
<p> </p>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
mapserver-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></pre>
</blockquote>
<br>
</body>
</html>