<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:12.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
font-size:12.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
span.E-MailFormatvorlage19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:16589764;
mso-list-type:hybrid;
mso-list-template-ids:1420753350 -1029931406 67567619 67567621 67567617 67567619 67567621 67567617 67567619 67567621;}
@list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-font-family:Calibri;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l1
{mso-list-id:107968033;
mso-list-template-ids:995775784;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2
{mso-list-id:1392732133;
mso-list-template-ids:-31701766;}
@list l3
{mso-list-id:2091928714;
mso-list-type:hybrid;
mso-list-template-ids:935883044 67567631 67567619 67567621 67567617 67567619 67567621 67567617 67567619 67567621;}
@list l3:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l3:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l3:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l3:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l3:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l3:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l3:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l3:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l3:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style></head><body lang=DE link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt'>Einen lieben Gruß an die Liste,</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'>Ich habe folgendes Problem und würde mich freuen, wenn mir jemand aus der Liste helfen könnte.</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'>Mit besten Grüßen und vielen Dank im Voraus an alle Unterstützer,</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'>David Schneider</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> </span><o:p></o:p></p><p class=MsoNormal><b><span style='font-size:11.0pt'>Setup:</span></b><o:p></o:p></p><ul style='margin-top:0cm' type=disc><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo3'><span style='font-size:11.0pt'>Mapbender Version 3.085 (auch bereits auf einem Testsystem mit 3.2 probiert)</span><o:p></o:p></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo3'><span style='font-size:11.0pt'>Windows Server</span><o:p></o:p></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo3'><span style='font-size:11.0pt'>GEOSERVER V </span><span style='font-size:11.0pt;mso-fareast-language:DE'>2.17.0</span><o:p></o:p></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo3'><span style='font-size:11.0pt'>PostgreSQL 9.6.18</span><o:p></o:p></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo3'><span style='font-size:11.0pt'>Library libpq-10.dll</span><o:p></o:p></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo3'><span style='font-size:11.0pt'>Mapbender-App mit EPSG:25833 (im Element Map </span><span style='font-size:11.0pt;font-family:Wingdings'></span><span style='font-size:11.0pt'> SRS)</span><o:p></o:p></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo3'><span style='font-size:11.0pt'>Karte per WMS Datenquelle (Geoserver, Postgis Datenspeicher) mit EPSG:25833 (Darstellung der Flurstücke erfolgt als Karte auch korrekt in EPSG:25833)</span><o:p></o:p></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo3'><span style='font-size:11.0pt'>Search Router mit Suche in Postgre DB (Element unten in Volltext, DB-Verbindung funktioniert)</span><o:p></o:p></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo3'><span style='font-size:11.0pt'>Tabelle in der Postgre DB in EPSG:25833</span><o:p></o:p></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo3'><span style='font-size:11.0pt'>Config und parameters </span><span style='font-size:11.0pt;font-family:Wingdings'></span><span style='font-size:11.0pt'> siehe unten in Auszug</span><o:p></o:p></li></ul><p class=MsoNormal><span style='font-size:11.0pt'> </span><o:p></o:p></p><p class=MsoNormal><b><span style='font-size:11.0pt'>Problem:</span></b><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'>Bei der Suche über den Search Router in Postgre DB werden die Elemente gefunden aber die Geometrien der Ergebnisse in EPSG:25832 dargestellt, obwohl die Tabelle als EPSG:25833 definiert ist und die Darstellung über die Karte (WMS per Geoserver) auch korrekt erfolgt. Der Search Router scheint trotz dessen, das alles im richtigen Referenzsystem ist, dieses bei der Darstellung der Suche zu ignorieren, weshalb der Rechtswert falsch ausgegeben wird. Geometrien, die eigentlich auf Höhe Sachsen liegen sollten, werden daher in NRW dargestellt. Eventuell gibt es die Möglichkeit, dem Search Router, ähnlich wie dem Digitizer, SRS vorzugeben/zu erzwingen. Ich habe bereits ausprobiert, die einstellung für srs in den Serach Router zu schreiben, wie er im Digitizer ist </span><span style='font-size:11.0pt;font-family:Wingdings'></span><span style='font-size:11.0pt'> das funktioniert scheinbar nicht. Kennt jemand eine Möglichkeit hierfür oder erkennt eventuell das Problem? In der Dokumentation habe ich dazu nichts gefunden.</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> </span><o:p></o:p></p><p class=MsoNormal><b><span style='font-size:11.0pt'>Vorschlag für zukünftiges Release/Dokumentation:</span></b><o:p></o:p></p><ol style='margin-top:0cm' start=1 type=1><li class=MsoListParagraph style='margin-left:0cm;mso-list:l3 level1 lfo6'><span style='font-size:11.0pt'>Sollte es eine Möglichkeit geben, das Referenzsystem im Search Router anzugeben, könnte man dies in die Dokumentation mit aufnehmen.</span><o:p></o:p></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l3 level1 lfo6'><span style='font-size:11.0pt'>Sollte es noch keine solche Möglichkeit geben, wäre es gut, dies in einem zukünftigen Release mit zu integrieren.</span><o:p></o:p></li></ol><p class=MsoNormal><span style='font-size:11.0pt'> </span><o:p></o:p></p><p class=MsoNormal><b><span style='font-size:11.0pt'>Konfigurationen:</span></b><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'>Search Router Element:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'><< </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'>class: Mapbender\CoreBundle\Component\SQLSearchEngine</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'>class_options:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> connection: nassn</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> relation: public.ax_flurstueck</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> attributes:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> - ogc_fid</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> - nenner</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> - zaehler</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> - wkb_geometry</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> geometry_attribute: wkb_geometry</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'>form:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> zaehler:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> type: text</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> options:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> required: false</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> </span><span style='font-size:11.0pt'>label: Zähler</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> nenner:</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> type: text</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> options:</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> </span><span lang=EN-US style='font-size:11.0pt'>required: false</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> label: Nenner</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> attr:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> data-autocomplete: 'on'</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> data-autocomplete-distinct: 'on'</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> compare: exact</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'>results:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> view: table</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> count: true</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> </span><span style='font-size:11.0pt'>headers:</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> ogc_fid: ID</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> zaehler: Zähler</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> nenner: Nenner</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> wkb_geometry: Geom.</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> </span><span lang=EN-US style='font-size:11.0pt'>callback:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> event: click</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> options:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> buffer: 100</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt'> </span><span style='font-size:11.0pt'>minScale: null</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> maxScale: 1000000</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'>>> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'>parameters.yml:</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt'><< </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;color:black;mso-fareast-language:DE'> database2_driver: pdo_pgsql</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;color:black;mso-fareast-language:DE'> database2_host: localhost</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;color:black;mso-fareast-language:DE'> database2_port: 5432</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;color:black;mso-fareast-language:DE'> database2_name: </span><span lang=EN-US style='font-size:11.0pt;color:red;mso-fareast-language:DE'>XXX</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;color:black;mso-fareast-language:DE'> database2_path: ~</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;color:black;mso-fareast-language:DE'> database2_user: </span><span lang=EN-US style='font-size:11.0pt;color:red;mso-fareast-language:DE'>XXX</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;color:black;mso-fareast-language:DE'> database2_password: </span><span lang=EN-US style='font-size:11.0pt;color:red;mso-fareast-language:DE'>XXX</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'>>> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'>config.yml:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'><< </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> nassn:</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> driver: %database2_driver%</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> host: %database2_host%</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> port: %database2_port%</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> dbname: %database2_name%</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> path: %database2_path%</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> user: %database2_user%</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> password: %database2_password%</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> charset: UTF8</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> logging: %kernel.debug%</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> profiling: %kernel.debug%</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'>>> </span><o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US style='font-size:10.5pt;color:black;mso-fareast-language:DE'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;mso-fareast-language:DE'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US> </span><o:p></o:p></p></div></body></html>