<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>
      that's the problem. The user should select one or both of them. If
      both, all two layer names are send in the QUERY_LAYERS inquiry -
      like it should.<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 27.03.2014 13:58, schrieb Jörg Thomsen:<br>
    </div>
    <blockquote cite="mid:53342076.6090102@mapmedia.de" type="cite">
      <pre wrap="">Hi,

okay, join is not what you need, sorry.
Would it work for you if only one of the two layers is queryable?

At the moment I have no idea...

Jörg

Am 27.03.2014 11:57, schrieb TDS:
</pre>
      <blockquote type="cite">
        <pre wrap="">Hello,

I've read this and I'm confused of how it can work...
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.


Example Mapfile:
    LAYER
        STATUS    on
        NAME    "Trinkwasserversorgung"
        TYPE    POLYGON
        DATA    "wv_wilster_84.shp"
        DUMP    true
        TOLERANCE        3
        TOLERANCEUNITS    pixels
        CLASSITEM        "TW"

        HEADER            "templates/header.html"
        TEMPLATE        "templates/template.html"
        FOOTER            "templates/footer.html"

        JOIN
            NAME "Wasser"
            TABLE "wv_wilster_84.dbf"
            FROM "Id"
            TO "Id"
            TYPE ONE-TO-ONE
        END

           CLASS
            NAME  "Trinkwasser"
            EXPRESSION  "Trinkwasser"
            STYLE
                COLOR   130  192  255
            END
            STYLE
                OUTLINECOLOR   120 120 120
                WIDTH 2
                ANTIALIAS TRUE
            END
        END

        CLASS
            NAME  "Selbstversorger"
            STYLE
                SYMBOL "im_schraffur"
            END       
            EXPRESSION  "Selbstversorger"
            STYLE
                OUTLINECOLOR   120 120 120
                WIDTH 2
                ANTIALIAS TRUE
            END
        END

        PROJECTION
            "init=epsg:4326"
        END

        METADATA
            "wms_title"                "Verbandsgebiet"
            "wms_title metadata"    ""
            "wms_include_items"        "all"
            "wms_srs"                "EPSG:4326 EPSG:54004 EPSG:41001
EPSG:31467 EPSG:31468"
        END
    END

    LAYER
        STATUS    on
        NAME    "Abwasserentsorgung"
        TYPE    POLYGON
        DATA    "wv_wilster_84.shp"
        DUMP    true
        TOLERANCE        3
        TOLERANCEUNITS    pixels
        CLASSITEM        "AW"

        HEADER            "templates/header.html"
        TEMPLATE        "templates/template.html"
        FOOTER            "templates/footer.html"

        JOIN
            NAME "Wasser"
            TABLE "wv_wilster_84.dbf"
            FROM "Id"
            TO "Id"
            TYPE ONE-TO-ONE
        END

        CLASS
            NAME  "Abwasser"
            EXPRESSION  "Abwasser"
            STYLE
                COLOR   255 128 0
            END
            STYLE
                OUTLINECOLOR   120 120 120
                WIDTH 2
                ANTIALIAS TRUE
            END
        END

        CLASS
            NAME  "Diverse Abwasseraufgaben"
            STYLE
                SYMBOL "schraffur_orange"
            END
            EXPRESSION  "Diverse Abwasseraufgaben"
            STYLE
                OUTLINECOLOR   120 120 120
                WIDTH 2
                ANTIALIAS TRUE
            END
        END

        CLASS
            NAME  "Kein Abwasser"
            EXPRESSION  "Kein Abwasser"
            STYLE
                OUTLINECOLOR   120 120 120
                WIDTH 2
                ANTIALIAS TRUE
            END
        END

        PROJECTION
            "init=epsg:4326"
        END

        METADATA
            "wms_title"                "Abwasser"
            "wms_title metadata"    ""
            "wms_include_items"        "all"
            "wms_srs"                "EPSG:4326 EPSG:54004 EPSG:41001
EPSG:31467 EPSG:31468"
        END
    END



Bye, TDS
------------------------------------------------------------------------
<a class="moz-txt-link-freetext" href="mailto:tds@tds-net.de">mailto:tds@tds-net.de</a>
------------------------------------------------------------------------
1+1=10
You have a question? - 42 or RTFM.
Am 26.03.2014 21:50, schrieb <a class="moz-txt-link-abbreviated" href="mailto:jt@mapmedia.de">jt@mapmedia.de</a>:
</pre>
        <blockquote type="cite">
          <pre wrap="">
Hi,

Referring to your signatur: rtfm ;)

Try <a class="moz-txt-link-freetext" href="http://mapserver.org/de/mapfile/join.htm">http://mapserver.org/de/mapfile/join.htm</a>

Join streets_main with the dbf of streets_sub. Read the doc carefuly,
it's a bit tricky.

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> (

Workshop_umn...)

Jörg

 

On Wed, 26 Mar 2014 20:58:17 +0100, TDS wrote:

</pre>
          <blockquote type="cite">
            <pre wrap="">    Hello,


is it possible to join two layers in GetFeatureInfo with same
template and same shape file to output only one combined html file?

Example:
Streets_Main => streets.shp => template.html
Streets_Sub => streets.shp => template.html

OUTPUT:

Current:
Output for Streets_Mains
Output for Streets_Sub

Wish:

Streets_Mains unique id Streets_sub (e.g. main street and sub street
have both id=1 in shape file)


-- 
Bye, TDS
------------------------------------------------------------------------
<a class="moz-txt-link-freetext" href="mailto:tds@tds-net.de">mailto:tds@tds-net.de</a>
------------------------------------------------------------------------
1+1=10
You have a question? - 42 or RTFM.
</pre>
          </blockquote>
          <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>
        <pre wrap="">
</pre>
      </blockquote>
      <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>