[mapserver-users] Problem with UNION layer and labelling

[Sven Schroeter]

Hi Oliver,
this is a complex SQL statement and I would always store such things in 
a view on the database. Then you can visually check if all data comes as 
it should.
Otherwise it could be due to the encoding of the data records, I 
sometimes had problems with it in the past.
By the way, you can just ask Armin Retterath in your house, he will find 
every error ;-)
Greetings also to Armin
Sven

**************************************
NETGIS GbR
Benediktinerstr. 32a
54292 Trier
Tel.: 0651-1704731
Fax: 0651-1704733
schroeter at netgis.de
www.netgis.de


Am 18.10.2019 um 13:56 schrieb Oliver Schmidt:
> 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
> oliver.schmidt at vermkv.rlp.de
> www.lvermgeo.rlp.de
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users