<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font face="Helvetica, Arial, sans-serif">Hi Oliver,<br>
<br>
Even I'm not certain what exactly is going on but did you anyhow
test if the German Umlaut in the naming causes any conflicts? At
least that's different in the two examples. You use "ue" and "ü"
differently in the layers. I may be on the wrong track but I
really avoid using Umlaut in my settings cause you never know what
it does to you...<br>
</font>
<div class="moz-signature">
<p style="text-align: left;font-family: Helvetica, Arial;">Best</p>
<p style="text-align: left;font-family: Helvetica, Arial;">Lars<br>
</p>
<p style="text-align: left;font-family: Helvetica, Arial;"> Lars
Fricke<br>
Forschung & Entwicklung<br>
</p>
<p style="text-align: left;font-family: Helvetica, Arial;">
+49(0)39602-183097<br>
+49(0)39602-183098<br>
</p>
<p style="text-align: left;font-family: Helvetica, Arial;">
SkenData GmbH<br>
Mühlendamm 8B<br>
18055 Rostock<br>
<a class="moz-txt-link-abbreviated" href="http://www.skendata.de">www.skendata.de</a><br>
</p>
<p style="text-align: left;font-family: Helvetica, Arial;
font-size: small;"> <br>
<img src="cid:part1.8CEACF12.C0757D29@skendata.de" alt="Wert14"
title="Wert14 Auszeichnungen" px="" width="400"><br>
</p>
<p style="text-align: left;font-family: Helvetica, Arial;"> <br>
<a class="moz-txt-link-abbreviated" href="http://www.wert14.de">www.wert14.de</a><br>
</p>
<p style="text-align: left;font-family: Helvetica, Arial;
font-size: small"> Geschäftsführer: Jon Meis und Sven Jantzen<br>
Amtsgericht Rostock HRB 12937<br>
</p>
</div>
<div class="moz-cite-prefix">Am 18.10.19 um 13:56 schrieb Oliver
Schmidt:<br>
</div>
<blockquote type="cite"
cite="mid:1462079727.434864.1571399762850@groupware.vermkv.rlp">
<pre class="moz-quote-pre" wrap="">Hi list,
I tried with MapServer 7.0.4 and 7.4.2 to get labels on an UNION layer. The labels are OK when I loaded the source layer itself into QGIS, but the UNION layer returns an empty picture (using LABELITEM) or the name of the label field including the brackets is placed instead of the data (using TEXT inside LABEL).
Furthermore, the variable settings for ANGLE, FONT, SIZE and POSITION don't seem to be handled correctly in the UNION layer. The font size and the position aren't identical to the source layer. Layers with polygons and no labels are drawn correctly!
Does anyone got an idea what is going wrong here? One example with just one layer:
LAYER NAME "Beschriftung Flurstuecke"
CONNECTIONTYPE UNION
CONNECTION "bfn"
TYPE POINT
STATUS ON
STYLEITEM "AUTO"
EXTENT 250000 5420000 500000 5648000
MAXSCALEDENOM 25000
METADATA
wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
wms_layer_group "/Flurstueck"
wms_title "Beschriftung Flurstuecke"
END
CLASS END
PROJECTION "init=epsg:25832" END
END
.....
LAYER NAME "bfn" # Flurstücke / Nummern / Beschriftungen
CONNECTION "dbname='db' host=host port=5432 user='user'"
CONNECTIONTYPE POSTGIS
DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'L' WHEN 'rechtsbündig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Flurstücke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND point IS NOT NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
EXTENT 250000 5420000 500000 5648000
# LABELITEM "text"
MAXSCALEDENOM 5000
METADATA
wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
# wms_layer_group "/Flurstücke/Nummern"
wms_layer_group "/Flurstücke"
# wms_title "Beschriftungen (Punkte)"
wms_title "Beschriftungen (Flurstücke)"
# wms_enable_request "* !GetCapabilities"
END
PROCESSING "CLOSE_CONNECTION=DEFER"
PROJECTION "init=epsg:25832" END
SIZEUNITS INCHES
STATUS ON
SYMBOLSCALEDENOM 1000
TYPE POINT
UNITS METERS
CLASS
LABEL
ANGLE [drehwinkel_grad]
ANTIALIAS TRUE
FONT [font_umn]
SIZE [size_umn]
BUFFER 2
COLOR [color_umn]
FORCE TRUE
OUTLINECOLOR 255 255 255
OUTLINEWIDTH 2
POSITION [position_umn]
PRIORITY 10
TYPE TRUETYPE
TEXT '[text]'
END
END
END
--
Dipl.-Geogr. Oliver Schmidt
LANDESAMT FÜR VERMESSUNG UND GEOBASISINFORMATION RHEINLAND-PFALZ
Von-Kuhl-Straße 49
56070 Koblenz
Telefon 0261 492-346
Telefax 0261 492-492
<a class="moz-txt-link-abbreviated" href="mailto:oliver.schmidt@vermkv.rlp.de">oliver.schmidt@vermkv.rlp.de</a>
<a class="moz-txt-link-abbreviated" href="http://www.lvermgeo.rlp.de">www.lvermgeo.rlp.de</a>
_______________________________________________
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="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a></pre>
</blockquote>
<br>
</body>
</html>