Hi Sven,
the complex SQL statement is not the problem at all - it works fine when using
the non-UNION layer. This mapfile originates from the PostNAS project which is
rather complex.
I asked Armin already, his office is on my corridor. He doesn't know why it
doesn't work and in his opinion there is no error in the mapfile. Perhaps I
found a bug here?
Thanks also to Lars for your reply. Removing the German Umlaute didn't solve
the problem - but you're right that this shouldn't be in used in a mapfile!
Greetings,
Oliver
> Sven Schroeter <schroe...@netgis.de> hat am 21. Oktober 2019 um 08:57
> geschrieben:
>
>
>
> 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
> schroe...@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.schm...@vermkv.rlp.de
> > www.lvermgeo.rlp.de
> > _______________________________________________
> > mapserver-users mailing list
> > mapserver-users@lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
Sehr geehrte Damen und Herren,
Mit freundlichen Grüßen
Im Auftrag
Oliver Schmidt
--
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.schm...@vermkv.rlp.de
www.lvermgeo.rlp.de
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
