<div dir="ltr"><div>Great! This should be helpful for all building their first search router.<br><br></div>Uwe<br><div> <br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2017-01-18 11:24 GMT+01:00 Astrid Emde <span dir="ltr"><<a href="mailto:astrid.emde@wheregroup.com" target="_blank">astrid.emde@wheregroup.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello Uwe and thanks for the suggestion.<br>
<br>
I added a note about the projection of the geom<br>
<br>
"Note: projection of geom has to be the same as map-Element projection"<br>
<br>
Have a look at:<br>
<a href="http://doc.mapbender3.org/en/bundles/Mapbender/CoreBundle/elements/search_router.html#yaml-definition" rel="noreferrer" target="_blank">http://doc.mapbender3.org/en/b<wbr>undles/Mapbender/CoreBundle/el<wbr>ements/search_router.html#yaml<wbr>-definition</a><br>
<br>
Astrid<span class=""><br>
<br>
Am 2017-01-18 09:53, schrieb Uwe Seher:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
Hello!<br>
<br>
The projection didn't match. The layer is a UTM layer from a view with<br>
a special projection from GK. In the search router i had referenced<br>
the original layer. Now it works great. Maybe this topic could be<br>
mentioned in the documentation or in a comment in the config.<br>
Thank you all for your help and your work!<br>
<br>
Best regards<br>
<br>
Uwe<br>
<br>
2017-01-18 8:58 GMT+01:00 Astrid Emde <<a href="mailto:astrid.emde@wheregroup.com" target="_blank">astrid.emde@wheregroup.com</a>>:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hello,<br>
<br>
here is another link to the documentation.<br>
<br>
<br>
</blockquote>
<a href="http://doc.mapbender3.org/en/bundles/Mapbender/CoreBundle/elements/search_router.html#yaml-definition" rel="noreferrer" target="_blank">http://doc.mapbender3.org/en/b<wbr>undles/Mapbender/CoreBundle/el<wbr>ements/search_router.html#yaml<wbr>-definition</a><br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
[1]<div><div class="h5"><br>
<br>
geometry_attribute: geom<br>
Make sure that your geometry_attribute is in the same projection as<br>
your map. This is an error that often is made.<br>
<br>
What is your EPSG-code? What are the units of your search?<br>
<br>
buffer: 1000<br>
Keep in mind that buffer is calutated in the units of your<br>
projection.<br>
<br>
Astrid<br>
<br>
Am 2017-01-17 16:15, schrieb Uwe Seher:<br>
<br>
Hello!<br>
<br>
Cleaning the cache made the trick, nor the result is shown. Thank<br>
you.<br>
But now the next problem:<br>
I interpret the documentation of the search router eleet, that the<br>
results are shown and you can click on it, then the map zooms to the<br>
element and shows the found geometry/element in the configurated<br>
colors.<br>
If i click now on my found result it zooms sometimes to an more or<br>
less erratic place (or does nothing) and no selected elements are<br>
shown. Clearing the cache after changing something didn't help here.<br>
The configuration is the same as above. I just post the results<br>
area:<br>
<br>
results:<br>
view: table<br>
count: true<br>
headers:<br>
objectid: ID<br>
name: Name<br>
callback:<br>
event: click<br>
options:<br>
buffer: 1000<br>
minScale: null<br>
maxScale: null<br>
styleMap:<br>
default:<br>
strokeColor: '#00ff00'<br>
strokeOpacity: 1<br>
fillOpacity: 1<br>
select:<br>
strokeColor: '#ff0000'<br>
fillColor: '#ff0000'<br>
fillOpacity: 0.8<br>
<br>
Any hint on the config or if i make some errors here would be great.<br>
<br>
Thank you<br>
<br>
Uwe<br>
<br>
2017-01-16 18:01 GMT+01:00 Axel Schaefer<br>
<<a href="mailto:axel.schaefer@wheregroup.com" target="_blank">axel.schaefer@wheregroup.com</a>><wbr>:<br>
<br>
Hi Uwe.<br>
<br>
After changes in parameters.yml and config.yml you have to clear the<br>
Mapbender cache directory.<br>
<br>
The contents in: <mapbender>/(application)/app/<wbr>cache.<br>
Not the cache-directory itself, but the contents of the directory.<br>
<br>
Maybe that's the missing point. Your configuration looks ok.<br>
<br>
Axel<br>
<br>
Uwe Seher writes:<br>
<br>
Hello again!<br>
<br>
I an trying to set up a search function in my application with the<br>
search<br>
router element.<br>
For this i had setup an additional database connection following<br>
teh<br>
desctioption in the documentation with the following parameters:<br>
<br>
parameters.yml:<br>
<br>
parameters:<br>
# Default-Datenbank<br>
database_driver: pdo_pgsql<br>
database_host: 192.168.1.3<br>
database_port: 5432<br>
database_name: mapbender3<br>
database_path: ~<br>
database_user: mapbender<br>
database_password: xxxx<br>
<br>
# Rhein-Datenbank<br>
database1_driver: pdo_pgsql<br>
database1_host: 192.168.1.3<br>
database1_port: 5432<br>
database1_name: rhein<br>
database1_path: ~<br>
database1_user: gdi_user<br>
database1_password: xxxx<br>
<br>
config.yml:<br>
<br>
doctrine:<br>
dbal:<br>
default_connection: default<br>
connections:<br>
default:<br>
driver: %database_driver%<br>
host: %database_host%<br>
port: %database_port%<br>
dbname: %database_name%<br>
path: %database_path%<br>
user: %database_user%<br>
password: %database_password%<br>
charset: UTF8<br>
logging: %kernel.debug%<br>
profiling: %kernel.debug%<br>
rhein:<br>
driver: %database1_driver%<br>
host: %database1_host%<br>
port: %database1_port%<br>
dbname: %database1_name%<br>
path: %database1_path%<br>
user: %database1_user%<br>
password: %database1_password%<br>
charset: UTF8<br>
logging: %kernel.debug%<br>
profiling: %kernel.debug%<br>
orm:<br>
auto_generate_proxy_classes: %kernel.debug%<br>
auto_mapping: true<br>
<br>
The search-dialog parameters look like this:<br>
<br>
class: Mapbender\CoreBundle\Component<wbr>\SQLSearchEngine<br>
class_options:<br>
connection: rhein<br>
relation: mrh_1509.engstellen<br>
attributes:<br>
- objectid<br>
- name<br>
geometry_attribute: geom<br>
form:<br>
name:<br>
type: choice<br>
options:<br>
empty_value: 'Bitte wählen'<br>
required: true<br>
choices:<br>
1: 'Reg.Bereich 1'<br>
2: 'Reg.Bereich 2'<br>
3: 'Reg.Bereich 3'<br>
4: 'Reg.Bereich 3'<br>
5: 'Reg.Bereich 5'<br>
6: 'Reg.Bereich 6'<br>
7: 'Reg.Bereich 6'<br>
results:<br>
view: table<br>
count: true<br>
headers:<br>
objectid: ID<br>
name: Name<br>
callback:<br>
event: click<br>
options:<br>
buffer: 10<br>
minScale: null<br>
maxScale: null<br>
<br>
The dialog itself works fine, but no results are found. In the<br>
logfile i<br>
found this entry:<br>
<br>
[2017-01-13 08:45:04] request.CRITICAL: Uncaught PHP Exception<br>
</div></div></blockquote><div><div class="h5">
Symfony\Component\DependencyI<wbr>njection\Exception\ServiceNotF<wbr>oundException:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
"You have requested a non-existent service<br>
"doctrine.dbal.rhein_connectio<wbr>n". Did you mean this:<br>
"doctrine.dbal.default_connect<wbr>ion"?" at<br>
/srv/www/htdocs/mapbender3-3.0<wbr>.5.3/app/bootstrap.php.cache line<br>
</blockquote>
2063<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
{"exception":"[object]<br>
</blockquote></blockquote>
<br>
(Symfony\\Component\\Dependenc<wbr>yInjection\\Exception\\Service<wbr>NotFoundException(code:<br>
<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
0): You have requested a non-existent service<br>
\"doctrine.dbal.rhein_connecti<wbr>on\". Did you mean this:<br>
\"doctrine.dbal.default_connec<wbr>tion\"? at<br>
/srv/www/htdocs/mapbender3-3.0<wbr>.5.3/app/bootstrap.php.cache:2<wbr>063)"}<br>
</blockquote>
[]<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
So i think, the second database connection is not etablished. If i<br>
</blockquote>
use the<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
parameters with other applications or psql everything works.<br>
</blockquote>
Restarting<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
apache has no effect. It would be great if someone has a hint what<br>
</blockquote>
i missed<br>
<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
here.<br>
<br>
Thanks in advance<br>
<br>
Uwe Seher<br>
______________________________<wbr>_________________<br>
Mapbender_users mailing list<br>
<a href="mailto:Mapbender_users@lists.osgeo.org" target="_blank">Mapbender_users@lists.osgeo.or<wbr>g</a><br>
</div></div><a href="http://lists.osgeo.org/mailman/listinfo/mapbender_users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman<wbr>/listinfo/mapbender_users</a> [2] [1]<br>
</blockquote><span class="">
<br>
--<br>
Axel Schaefer<br>
WhereGroup GmbH & Co. KG<br>
Eifelstraße 7<br>
53119 Bonn<br>
Germany<br>
<br></span>
Fon: +49 (0)228 / 90 90 38 [3] - 23 [2] (neue Durchwahl!)<br>
Fax: +49 (0)228 / 90 90 38 [3] - 11 [3]<br>
<br>
<a href="mailto:axel.schaefer@wheregroup.com" target="_blank">axel.schaefer@wheregroup.com</a><br>
<a href="http://www.meldemax.com" rel="noreferrer" target="_blank">www.meldemax.com</a> [4] [4]<br>
<a href="http://www.wheregroup.com" rel="noreferrer" target="_blank">www.wheregroup.com</a> [5] [5]<span class=""><br>
Amtsgericht Bonn, HRA 6788<br>
------------------------------<wbr>-<br>
Komplementärin:<br>
WhereGroup Verwaltungs GmbH<br>
vertreten durch:<br>
Olaf Knopp, Peter Stamm<br>
------------------------------<wbr>-<br>
______________________________<wbr>_________________<br>
Mapbender_users mailing list<br>
<a href="mailto:Mapbender_users@lists.osgeo.org" target="_blank">Mapbender_users@lists.osgeo.or<wbr>g</a><br>
</span><a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/mapbender_users</a> [6] [6]<br>
</blockquote><span class="">
<br>
Links:<br>
------<br>
[1] <a href="http://lists.osgeo.org/mailman/listinfo/mapbender_users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman<wbr>/listinfo/mapbender_users</a> [2]<br>
[2] tel:%2B49%20%280%29228%20%2F%2<wbr>090%2090%2038%20-%2023<br>
[3] tel:%2B49%20%280%29228%20%2F%2<wbr>090%2090%2038%20-%2011<br>
[4] <a href="http://www.meldemax.com" rel="noreferrer" target="_blank">http://www.meldemax.com</a><br>
[5] <a href="http://www.wheregroup.com" rel="noreferrer" target="_blank">http://www.wheregroup.com</a><br></span>
[6] <a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/mapbender_users</a> [6]<span class=""><br>
______________________________<wbr>_________________<br>
Mapbender_users mailing list<br>
<a href="mailto:Mapbender_users@lists.osgeo.org" target="_blank">Mapbender_users@lists.osgeo.or<wbr>g</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/mapbender_users</a> [6]<br>
<br></span><span class="">
--<br>
Mit freundlichen Grüßen<br>
<br>
Astrid Emde<br>
GIS-Consultant<br>
<br>
******************************<wbr>***************************<br>
FOSS Academy Winterschule 2017<br>
</span><a href="tel:20.-24.03.2017" value="+12024032017" target="_blank">20.-24.03.2017</a> [7] in Bonn<span class=""><br>
Alles Wichtige zur Erstellung einer GDI in nur 5 Tagen!<br>
******************************<wbr>***************************<br>
<br>
Astrid Emde<br>
WhereGroup GmbH & Co.KG<br>
Eifelstraße 7<br>
53119 Bonn<br>
Germany<br>
<br></span>
Fon: <a href="tel:%2B49%280%29228%2090%2090%2038" value="+49228909038" target="_blank">+49(0)228 90 90 38</a> - 22 [8]<br>
Fax: <a href="tel:%2B49%280%29228%2090%2090%2038" value="+49228909038" target="_blank">+49(0)228 90 90 38</a> - 11 [9]<br>
<br>
<a href="mailto:astrid.emde@wheregroup.com" target="_blank">astrid.emde@wheregroup.com</a><br>
<a href="http://www.wheregroup.com" rel="noreferrer" target="_blank">www.wheregroup.com</a> [5]<span class=""><br>
<br>
Folgen Sie der WhereGroup auf twitter:<br>
</span><a href="http://twitter.com/WhereGroup_com" rel="noreferrer" target="_blank">http://twitter.com/WhereGroup_<wbr>com</a> [10]<span class=""><br>
<br>
Amtsgericht Bonn, HRA 6788<br>
------------------------------<wbr>-<br>
Komplementärin:<br>
WhereGroup Verwaltungs GmbH<br>
vertreten durch:<br>
Olaf Knopp, Peter Stamm<br>
------------------------------<wbr>-<br>
pgp-public key:<br></span>
<a href="http://pgp.mit.edu:11371/pks/lookup?search=0x06DA52D72D515284" rel="noreferrer" target="_blank">http://pgp.mit.edu:11371/pks/<wbr>lookup?search=0x06DA52D72D5152<wbr>84</a> [11]<span class=""><br>
Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen<br>
Signed and/or encrypted mail is highly appreciated<br>
<br>
<br>
<br></span>
Links:<br>
------<br>
[1]<br>
<a href="http://doc.mapbender3.org/en/bundles/Mapbender/CoreBundle/elements/search_router.html#yaml-definition" rel="noreferrer" target="_blank">http://doc.mapbender3.org/en/b<wbr>undles/Mapbender/CoreBundle/el<wbr>ements/search_router.html#yaml<wbr>-definition</a><br>
[2] <a href="http://lists.osgeo.org/mailman/listinfo/mapbender_users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman<wbr>/listinfo/mapbender_users</a><br>
[3] tel:%2B49%20%280%29228%20%2F%2<wbr>090%2090%2038<span class=""><br>
[4] <a href="http://www.meldemax.com" rel="noreferrer" target="_blank">http://www.meldemax.com</a><br>
[5] <a href="http://www.wheregroup.com" rel="noreferrer" target="_blank">http://www.wheregroup.com</a><br>
[6] <a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/mapbender_users</a><br></span>
[7] tel:<a href="tel:20.-24.03.2017" value="+12024032017" target="_blank">20.-24.03.2017</a><br>
[8] tel:%2B49%280%29228%2090%2090%<wbr>2038%20-%2022<br>
[9] tel:%2B49%280%29228%2090%2090%<wbr>2038%20-%2011<br>
[10] <a href="http://twitter.com/WhereGroup_com" rel="noreferrer" target="_blank">http://twitter.com/WhereGroup_<wbr>com</a><br>
[11] <a href="http://pgp.mit.edu:11371/pks/lookup?search=0x06DA52D72D515284" rel="noreferrer" target="_blank">http://pgp.mit.edu:11371/pks/l<wbr>ookup?search=0x06DA52D72D51528<wbr>4</a><br>
</blockquote><div class="HOEnZb"><div class="h5">
<br>
-- <br>
Mit freundlichen Grüßen<br>
<br>
Astrid Emde<br>
GIS-Consultant<br>
<br>
******************************<wbr>***************************<br>
FOSS Academy Winterschule 2017<br>
<a href="tel:20.-24.03.2017" value="+12024032017" target="_blank">20.-24.03.2017</a> in Bonn<br>
Alles Wichtige zur Erstellung einer GDI in nur 5 Tagen!<br>
******************************<wbr>***************************<br>
<br>
Astrid Emde<br>
WhereGroup GmbH & Co.KG<br>
Eifelstraße 7<br>
53119 Bonn<br>
Germany<br>
<br>
Fon: <a href="tel:%2B49%280%29228%2090%2090%2038%20-%2022" value="+4922890903822" target="_blank">+49(0)228 90 90 38 - 22</a><br>
Fax: <a href="tel:%2B49%280%29228%2090%2090%2038%20-%2011" value="+4922890903811" target="_blank">+49(0)228 90 90 38 - 11</a><br>
<br>
<a href="mailto:astrid.emde@wheregroup.com" target="_blank">astrid.emde@wheregroup.com</a><br>
<a href="http://www.wheregroup.com" rel="noreferrer" target="_blank">www.wheregroup.com</a><br>
<br>
Folgen Sie der WhereGroup auf twitter: <a href="http://twitter.com/WhereGroup_com" rel="noreferrer" target="_blank">http://twitter.com/WhereGroup_<wbr>com</a><br>
<br>
Amtsgericht Bonn, HRA 6788<br>
------------------------------<wbr>-<br>
Komplementärin:<br>
WhereGroup Verwaltungs GmbH<br>
vertreten durch:<br>
Olaf Knopp, Peter Stamm<br>
------------------------------<wbr>-<br>
pgp-public key:<br>
<a href="http://pgp.mit.edu:11371/pks/lookup?search=0x06DA52D72D515284" rel="noreferrer" target="_blank">http://pgp.mit.edu:11371/pks/<wbr>lookup?search=0x06DA52D72D5152<wbr>84</a><br>
Signierte und/oder verschlüsselte Nachrichten sind sehr willkommen<br>
Signed and/or encrypted mail is highly appreciated<br>
</div></div></blockquote></div><br></div>