]> git.openstreetmap.org Git - nominatim.git/log
nominatim.git
2 years agoMerge pull request #2585 from lonvia/name-mutations
Sarah Hoffmann [Wed, 19 Jan 2022 16:09:36 +0000 (17:09 +0100)]
Merge pull request #2585 from lonvia/name-mutations

Introduce character mutations to token analysis

2 years agodocs: add pointer to caddy deployment discussion
Sarah Hoffmann [Wed, 19 Jan 2022 14:28:01 +0000 (15:28 +0100)]
docs: add pointer to caddy deployment discussion

2 years agofix linting error
Sarah Hoffmann [Thu, 13 Jan 2022 08:30:31 +0000 (09:30 +0100)]
fix linting error

2 years agomove parsing of mutation config to setup phase
Sarah Hoffmann [Wed, 12 Jan 2022 18:41:16 +0000 (19:41 +0100)]
move parsing of mutation config to setup phase

2 years agoadd documentation for new mutation feature
Sarah Hoffmann [Wed, 12 Jan 2022 16:37:06 +0000 (17:37 +0100)]
add documentation for new mutation feature

2 years agointroduce mutation variants to generic token analyser
Sarah Hoffmann [Wed, 12 Jan 2022 15:25:47 +0000 (16:25 +0100)]
introduce mutation variants to generic token analyser

Mutations are regular-expression-based replacements that are applied
after variants have been computed. They are meant to be used for
variations on character level.

Add spelling variations for German umlauts.

2 years agomove variant configuration reading in separate file
Sarah Hoffmann [Wed, 12 Jan 2022 08:53:32 +0000 (09:53 +0100)]
move variant configuration reading in separate file

2 years agorefactor variant production to use generators
Sarah Hoffmann [Tue, 11 Jan 2022 16:51:05 +0000 (17:51 +0100)]
refactor variant production to use generators

2 years agoMerge pull request #2578 from lonvia/iso-3166-2
Sarah Hoffmann [Thu, 13 Jan 2022 13:54:35 +0000 (14:54 +0100)]
Merge pull request #2578 from lonvia/iso-3166-2

Make ISO3166-2 references searchable

2 years agoMerge pull request #2579 from geofabrik/doc-update-typo
Sarah Hoffmann [Thu, 13 Jan 2022 13:01:57 +0000 (14:01 +0100)]
Merge pull request #2579 from geofabrik/doc-update-typo

Fix typo in name of service. The rest of the docs call it nominatim-updateS

2 years agoFix typo in name of service. The rest of the docs call it nominatim-updateS
Amanda McCann [Thu, 13 Jan 2022 12:14:17 +0000 (13:14 +0100)]
Fix typo in name of service. The rest of the docs call it nominatim-updateS

2 years agomake ISO3166-2 references searchable
Sarah Hoffmann [Thu, 13 Jan 2022 08:44:42 +0000 (09:44 +0100)]
make ISO3166-2 references searchable

2 years agoMerge pull request #2571 from lonvia/ukrainian-apostrophe
Sarah Hoffmann [Tue, 11 Jan 2022 08:41:07 +0000 (09:41 +0100)]
Merge pull request #2571 from lonvia/ukrainian-apostrophe

Consider "modifier letter apostrophe" to be punctuation

2 years agoconsider "modifier letter apostrophe" to be punctuation
Sarah Hoffmann [Mon, 10 Jan 2022 16:40:03 +0000 (17:40 +0100)]
consider "modifier letter apostrophe" to be punctuation

While technically being a letter, the apostrophe is often replaced
with a normal apostrophe in writing which is a punctuation mark.
This makes sure that the modifier letter apostrophe yields the same
normalization results and thus is really interchangable.

Only has an effect after the next reimport.

Fixes #2569.

2 years agoMerge pull request #2570 from woodpeck/patch-3
Sarah Hoffmann [Mon, 10 Jan 2022 13:21:48 +0000 (14:21 +0100)]
Merge pull request #2570 from woodpeck/patch-3

Fix typos

2 years agoFix typos
Frederik Ramm [Mon, 10 Jan 2022 12:38:53 +0000 (13:38 +0100)]
Fix typos

2 years agoMerge pull request #2565 from lonvia/swap-wordset-order
Sarah Hoffmann [Thu, 6 Jan 2022 08:02:46 +0000 (09:02 +0100)]
Merge pull request #2565 from lonvia/swap-wordset-order

Swap order of query interpretation

2 years agoswap order of query interpretation
Sarah Hoffmann [Wed, 5 Jan 2022 14:21:14 +0000 (15:21 +0100)]
swap order of query interpretation

A forward interpretation of the form 'street, city, country' is
much more frequent than the reverse form 'country, city, street'.
Thus swap the order of interpretations that the forward order comes
first.

2 years agoMerge pull request #2562 from lonvia/copyright-headers
Sarah Hoffmann [Tue, 4 Jan 2022 22:10:37 +0000 (23:10 +0100)]
Merge pull request #2562 from lonvia/copyright-headers

Add consistent copyright headers

2 years agoadd consistent SPDX copyright headers
Sarah Hoffmann [Mon, 3 Jan 2022 15:23:58 +0000 (16:23 +0100)]
add consistent SPDX copyright headers

2 years agoMerge pull request #2559 from lonvia/disable-jit-in-queries
Sarah Hoffmann [Mon, 3 Jan 2022 14:13:57 +0000 (15:13 +0100)]
Merge pull request #2559 from lonvia/disable-jit-in-queries

Disable JIT and parallel workers on search frontend

3 years agodisable JIT and parallel workers on search frontend
Sarah Hoffmann [Wed, 22 Dec 2021 07:59:31 +0000 (08:59 +0100)]
disable JIT and parallel workers on search frontend

Bad query planning now also interferes with queries for search and
reverse.

3 years agoMerge pull request #2553 from lonvia/revert-street-matching-to-full-names
Sarah Hoffmann [Tue, 14 Dec 2021 14:52:34 +0000 (15:52 +0100)]
Merge pull request #2553 from lonvia/revert-street-matching-to-full-names

Revert street matching to full names

3 years agocorrectly match abbreviated addr:street
Sarah Hoffmann [Wed, 8 Dec 2021 20:58:43 +0000 (21:58 +0100)]
correctly match abbreviated addr:street

This only works when addr:street is abbreviated and the street
name isn't. It does not work the other way around.

3 years agoMerge pull request #2542 from lonvia/update-phpunit
Sarah Hoffmann [Tue, 7 Dec 2021 14:44:45 +0000 (15:44 +0100)]
Merge pull request #2542 from lonvia/update-phpunit

Update PHPUnit use to 9.5

3 years agorestrict PHPUnit to 9.5 version
Sarah Hoffmann [Tue, 7 Dec 2021 13:49:31 +0000 (14:49 +0100)]
restrict PHPUnit to 9.5 version

There are so many breaking changes with PHPUnit that it is
impossible to give any other guarantees.

3 years agoenable PHPUnit 9 for coverage
Sarah Hoffmann [Tue, 7 Dec 2021 11:07:17 +0000 (12:07 +0100)]
enable PHPUnit 9 for coverage

A couple of functions have been renamed.

3 years agophp unit: replace deprecated regex assert
Sarah Hoffmann [Tue, 7 Dec 2021 10:34:21 +0000 (11:34 +0100)]
php unit: replace deprecated regex assert

The regEx assertion has been renamed in PHPUnit 9.5
and causes deprecation warnings.

3 years agophp unit: don't enforce a name on the test database
Sarah Hoffmann [Tue, 7 Dec 2021 10:31:45 +0000 (11:31 +0100)]
php unit: don't enforce a name on the test database

Also gets rid of a PHPUnit deprecation warning.

3 years agophp test: class must be called like the file
Sarah Hoffmann [Tue, 7 Dec 2021 10:20:38 +0000 (11:20 +0100)]
php test: class must be called like the file

3 years agodisable codecov
Sarah Hoffmann [Tue, 7 Dec 2021 10:13:30 +0000 (11:13 +0100)]
disable codecov

Not working.

3 years agoMerge pull request #2540 from lonvia/remove-support-for-centos7
Sarah Hoffmann [Tue, 7 Dec 2021 08:17:29 +0000 (09:17 +0100)]
Merge pull request #2540 from lonvia/remove-support-for-centos7

Remove installation instructions for CentOS 7

3 years agoremove installation instructions for CentOS 7
Sarah Hoffmann [Mon, 6 Dec 2021 15:05:27 +0000 (16:05 +0100)]
remove installation instructions for CentOS 7

This ends official support for CentOS 7.

3 years agoremove some odd varaints of addr:street from the styles
Sarah Hoffmann [Mon, 6 Dec 2021 14:17:00 +0000 (15:17 +0100)]
remove some odd varaints of addr:street from the styles

Some import has added names in partial tags which confuse the
street name matching.

3 years agoskip most addr: tags with suffixes
Sarah Hoffmann [Mon, 6 Dec 2021 13:46:40 +0000 (14:46 +0100)]
skip most addr: tags with suffixes

Only one addr: tag can be processed currently, so make
sure it is the one without suffixes to not get odd data.
addr:street is the exception because it uses a different
matching mechanism.

3 years agoICU: matching any street name will do again
Sarah Hoffmann [Mon, 6 Dec 2021 13:26:08 +0000 (14:26 +0100)]
ICU: matching any street name will do again

3 years agorevert to using full names for street name matching
Sarah Hoffmann [Mon, 6 Dec 2021 10:38:38 +0000 (11:38 +0100)]
revert to using full names for street name matching

Using partial names turned out to not work well because there are
often similarly named streets next to each other. It also
prevents us from being able to take into account all addr:street:*
tags.

This change gets all the full term tokens for the addr:street tags
from the DB. As they are used for matching only, we can assume that
the term must already be there or there will be no match. This
avoid creating unused full name tags.

3 years agoMerge pull request #2539 from lonvia/clean-up-python-tests
Sarah Hoffmann [Fri, 3 Dec 2021 16:08:25 +0000 (17:08 +0100)]
Merge pull request #2539 from lonvia/clean-up-python-tests

Restructure and extend python unit tests

3 years agospecify text type in test SQL
Sarah Hoffmann [Fri, 3 Dec 2021 11:01:53 +0000 (12:01 +0100)]
specify text type in test SQL

Older version of postgres fail otherwise.

3 years agosplit cli tests by subcommand and extend coverage
Sarah Hoffmann [Thu, 2 Dec 2021 22:45:48 +0000 (23:45 +0100)]
split cli tests by subcommand and extend coverage

3 years agoremove unnecessary pass statements
Sarah Hoffmann [Thu, 2 Dec 2021 14:54:24 +0000 (15:54 +0100)]
remove unnecessary pass statements

3 years agomore unit tests for tokenizers
Sarah Hoffmann [Thu, 2 Dec 2021 14:46:36 +0000 (15:46 +0100)]
more unit tests for tokenizers

3 years agoextend API unit tests
Sarah Hoffmann [Wed, 1 Dec 2021 19:48:29 +0000 (20:48 +0100)]
extend API unit tests

3 years agoadd tests for migration
Sarah Hoffmann [Wed, 1 Dec 2021 19:27:40 +0000 (20:27 +0100)]
add tests for migration

3 years agomore testing for refresh functions
Sarah Hoffmann [Wed, 1 Dec 2021 13:58:54 +0000 (14:58 +0100)]
more testing for refresh functions

3 years agomore tests for exec utilities
Sarah Hoffmann [Wed, 1 Dec 2021 13:23:51 +0000 (14:23 +0100)]
more tests for exec utilities

3 years agoadd more tests for database import
Sarah Hoffmann [Wed, 1 Dec 2021 10:54:58 +0000 (11:54 +0100)]
add more tests for database import

3 years agoadd tests for adding additional data
Sarah Hoffmann [Wed, 1 Dec 2021 10:22:46 +0000 (11:22 +0100)]
add tests for adding additional data

Also adds checks that parameters for osm2pgsql are set
as expected.

3 years agoadd tests for flatten_config_file and other than yaml formats
Sarah Hoffmann [Wed, 1 Dec 2021 09:24:11 +0000 (10:24 +0100)]
add tests for flatten_config_file and other than yaml formats

3 years agotests: add fixture for making test project directory
Sarah Hoffmann [Tue, 30 Nov 2021 17:01:46 +0000 (18:01 +0100)]
tests: add fixture for making test project directory

3 years agogeneralize fixtures for cli tests
Sarah Hoffmann [Tue, 30 Nov 2021 13:07:39 +0000 (14:07 +0100)]
generalize fixtures for cli tests

3 years agopython test: move single-use fixtures to subdirectories
Sarah Hoffmann [Tue, 30 Nov 2021 11:03:16 +0000 (12:03 +0100)]
python test: move single-use fixtures to subdirectories

3 years agoremove unused test files
Sarah Hoffmann [Tue, 30 Nov 2021 10:23:00 +0000 (11:23 +0100)]
remove unused test files

3 years agoorganise python tests in subdirectories
Sarah Hoffmann [Tue, 30 Nov 2021 10:10:47 +0000 (11:10 +0100)]
organise python tests in subdirectories

The directories follow the same structure as the modules in
nominatim/.

3 years agoMerge pull request #2530 from lonvia/declassify-highway
Sarah Hoffmann [Thu, 25 Nov 2021 07:41:25 +0000 (08:41 +0100)]
Merge pull request #2530 from lonvia/declassify-highway

Change default rank for highway objects to 30

3 years agochange default rank for highway objects to 30
Sarah Hoffmann [Wed, 24 Nov 2021 13:40:23 +0000 (14:40 +0100)]
change default rank for highway objects to 30

The highway key is being used more and more for non-ways these
days. This clashes with Nominatim's assumption that essentially
everything that has a highway tag can be used as the street part
of the address.

Change the default rank of highway objects to 30 to avoid this.
Only the known values for streets keep the rank 26 and are now
listed explicitly.

3 years agoMerge pull request #2529 from lonvia/sort-street-results-by-tiger-housenumber
Sarah Hoffmann [Wed, 24 Nov 2021 15:23:41 +0000 (16:23 +0100)]
Merge pull request #2529 from lonvia/sort-street-results-by-tiger-housenumber

Take tiger housenumber into account when ranking street results

3 years agoadd migration for inclusive housenumber Tiger index
Sarah Hoffmann [Wed, 24 Nov 2021 10:05:04 +0000 (11:05 +0100)]
add migration for inclusive housenumber Tiger index

3 years agoadd index for Tiger housenumber queries
Sarah Hoffmann [Tue, 23 Nov 2021 19:24:08 +0000 (20:24 +0100)]
add index for Tiger housenumber queries

3 years agotake Tiger housenumbers into account when ranking street results
Sarah Hoffmann [Tue, 23 Nov 2021 19:04:50 +0000 (20:04 +0100)]
take Tiger housenumbers into account when ranking street results

Queries with a housenumber need to rank streets higher that
have the requested housenumber attached. We already do that for
ordinary housenumber objects and for interpolations. This
adds support for Tiger housenumbers as well.

Fixes #2501.

3 years agoMerge pull request #2528 from lonvia/allow-french-extra-housenumbers
Sarah Hoffmann [Sun, 21 Nov 2021 09:53:20 +0000 (10:53 +0100)]
Merge pull request #2528 from lonvia/allow-french-extra-housenumbers

Don't penalize French 'bis' housenumbers

3 years agoMerge pull request #2526 from lonvia/docs-moving-database
Sarah Hoffmann [Fri, 19 Nov 2021 20:14:53 +0000 (21:14 +0100)]
Merge pull request #2526 from lonvia/docs-moving-database

Add a section about moving the database to another machine

3 years agodon't penalize French 'bis' housenumbers
Sarah Hoffmann [Fri, 19 Nov 2021 20:12:17 +0000 (21:12 +0100)]
don't penalize French 'bis' housenumbers

House numbers of the form '9 bis' are usual in France. So
be a bit more lenient before adding penalties to house numbers
with letters in them.

Fixes #2527.

3 years agoMerge pull request #2525 from lonvia/fix-replication-indexer
Sarah Hoffmann [Fri, 19 Nov 2021 15:16:30 +0000 (16:16 +0100)]
Merge pull request #2525 from lonvia/fix-replication-indexer

Fix instantiation of indexer for replication

3 years agoadd a section about moving the database to another machine
Sarah Hoffmann [Fri, 19 Nov 2021 15:11:32 +0000 (16:11 +0100)]
add a section about moving the database to another machine

3 years agoonly instantiate indexer once for replication
Sarah Hoffmann [Fri, 19 Nov 2021 13:47:00 +0000 (14:47 +0100)]
only instantiate indexer once for replication

Also makes sure that indexer object exists everywhere were needed.

See #2518.

3 years agoMerge pull request #2517 from lonvia/transliteration-special-chars
Sarah Hoffmann [Thu, 11 Nov 2021 06:42:42 +0000 (07:42 +0100)]
Merge pull request #2517 from lonvia/transliteration-special-chars

ICU: avoid non-alphanumerical characters in transliteration

3 years agomake sure housenumbers are properly quoted
Sarah Hoffmann [Wed, 10 Nov 2021 16:15:34 +0000 (17:15 +0100)]
make sure housenumbers are properly quoted

3 years agoavoid special characters in word tokens
Sarah Hoffmann [Wed, 10 Nov 2021 16:14:13 +0000 (17:14 +0100)]
avoid special characters in word tokens

Transliteration should only consist of ASCII letters
and numbers. Avoid any other characters.

3 years agoMerge pull request #2516 from lonvia/test-for-website-dir
Sarah Hoffmann [Wed, 10 Nov 2021 12:27:09 +0000 (13:27 +0100)]
Merge pull request #2516 from lonvia/test-for-website-dir

Better error reporting when API script does not exist

3 years agobetter error reporting when API script does not exist
Sarah Hoffmann [Wed, 10 Nov 2021 08:42:49 +0000 (09:42 +0100)]
better error reporting when API script does not exist

Check if the API script exists on the expected location before
running php-cli. This way we can add a useful hint about the
project directory.

Fixes #2513.

3 years agoMerge pull request #2511 from lonvia/fix-combination-error-needs-address
Sarah Hoffmann [Sat, 6 Nov 2021 11:11:55 +0000 (12:11 +0100)]
Merge pull request #2511 from lonvia/fix-combination-error-needs-address

Fix boolean combination of NeedsAddress flag

3 years agofix combination of NeedsAddress flag
Sarah Hoffmann [Fri, 5 Nov 2021 21:18:37 +0000 (22:18 +0100)]
fix combination of NeedsAddress flag

When dealing with multiple partial terms, only keep the
flag, when all partial terms are so frequent as to need
an address.

Fixes #2510.

3 years agoprepare release 4.0.0 v4.0.0
Sarah Hoffmann [Mon, 1 Nov 2021 11:14:53 +0000 (12:14 +0100)]
prepare release 4.0.0

3 years agofix typo
Sarah Hoffmann [Tue, 2 Nov 2021 10:09:17 +0000 (11:09 +0100)]
fix typo

3 years agoMerge pull request #2502 from lonvia/improve-development-documentation
Sarah Hoffmann [Mon, 1 Nov 2021 15:12:23 +0000 (16:12 +0100)]
Merge pull request #2502 from lonvia/improve-development-documentation

Extend developer's documentation

3 years agodocs: add overview over indexing
Sarah Hoffmann [Mon, 1 Nov 2021 10:04:03 +0000 (11:04 +0100)]
docs: add overview over indexing

3 years agodocs: section about database layout
Sarah Hoffmann [Fri, 29 Oct 2021 10:03:22 +0000 (12:03 +0200)]
docs: section about database layout

Replaces the import description which basically was
table layout only now.

3 years agoMerge pull request #2498 from lonvia/ordering-for-unlisted-place-results
Sarah Hoffmann [Thu, 28 Oct 2021 13:28:47 +0000 (15:28 +0200)]
Merge pull request #2498 from lonvia/ordering-for-unlisted-place-results

Include unlisted places in ordering by housenumber

3 years agoMerge pull request #2497 from lonvia/docs-maintenance
Sarah Hoffmann [Thu, 28 Oct 2021 09:33:34 +0000 (11:33 +0200)]
Merge pull request #2497 from lonvia/docs-maintenance

docs: add new maintenance section

3 years agoinclude unlisted places in ordering by housenumber
Sarah Hoffmann [Thu, 28 Oct 2021 09:27:31 +0000 (11:27 +0200)]
include unlisted places in ordering by housenumber

When ordering results by the fact that they have a housenumber,
also take cases into account where the housenumber is on the
place itself. This may happen when the search includes the name
of the place and the housenumber or for addr:place addresses
where the place is unlisted.

3 years agodocs: add new maintenance section
Sarah Hoffmann [Wed, 27 Oct 2021 18:59:45 +0000 (20:59 +0200)]
docs: add new maintenance section

currently used for postcode updates, word count updates and
deleted relations.

3 years agoMerge pull request #2495 from lonvia/fix-normalization-in-php
Sarah Hoffmann [Wed, 27 Oct 2021 12:40:42 +0000 (14:40 +0200)]
Merge pull request #2495 from lonvia/fix-normalization-in-php

ICU: use correct normalization during search

3 years agoICU: use normalization from config in PHP
Sarah Hoffmann [Wed, 27 Oct 2021 08:07:19 +0000 (10:07 +0200)]
ICU: use normalization from config in PHP

The TERM_NORMALIZATION config option is no longer applicable.
That was already documented but not yet implemented.

3 years agobdd: add tests for non-latin scripts
Sarah Hoffmann [Tue, 26 Oct 2021 15:29:03 +0000 (17:29 +0200)]
bdd: add tests for non-latin scripts

3 years agoMerge pull request #2493 from lonvia/handle-frequent-partials
Sarah Hoffmann [Tue, 26 Oct 2021 15:00:43 +0000 (17:00 +0200)]
Merge pull request #2493 from lonvia/handle-frequent-partials

Tune search queries with frequent partial words

3 years agoadapt BDD tests to stricter partial search
Sarah Hoffmann [Tue, 26 Oct 2021 10:07:13 +0000 (12:07 +0200)]
adapt BDD tests to stricter partial search

3 years agodo not count words when in reverse-only mode
Sarah Hoffmann [Tue, 26 Oct 2021 09:42:42 +0000 (11:42 +0200)]
do not count words when in reverse-only mode

3 years agofurther refactor setup to keep function small
Sarah Hoffmann [Tue, 26 Oct 2021 08:57:51 +0000 (10:57 +0200)]
further refactor setup to keep function small

3 years agosearches for house numbers must have an address
Sarah Hoffmann [Tue, 26 Oct 2021 08:28:28 +0000 (10:28 +0200)]
searches for house numbers must have an address

3 years agodisallow search for partials without address
Sarah Hoffmann [Tue, 26 Oct 2021 08:23:55 +0000 (10:23 +0200)]
disallow search for partials without address

Very frequent partial terms take too long to look up and
do not return any valuable results unless the search is
further narrowed down by an address.

3 years agomake word count computation part of the import
Sarah Hoffmann [Tue, 26 Oct 2021 07:37:57 +0000 (09:37 +0200)]
make word count computation part of the import

Accurate word counts are now essential when using
the ICU tokenizer and don't hurt for the legacy one.

Adds about an hour import time.

3 years agoactions: move ICU tests into its own run
Sarah Hoffmann [Tue, 26 Oct 2021 08:32:43 +0000 (10:32 +0200)]
actions: move ICU tests into its own run

3 years agoMerge pull request #2486 from lonvia/fix-special-phrases
Sarah Hoffmann [Mon, 25 Oct 2021 19:45:08 +0000 (21:45 +0200)]
Merge pull request #2486 from lonvia/fix-special-phrases

Fix parsing of operator in special phrases

3 years agoICU: add an index over word_ids
Sarah Hoffmann [Mon, 25 Oct 2021 19:33:27 +0000 (21:33 +0200)]
ICU: add an index over word_ids

Needed for keyword lookup in the details response.

3 years agobe case-insensitve about special phrase operator
Sarah Hoffmann [Mon, 25 Oct 2021 17:51:20 +0000 (19:51 +0200)]
be case-insensitve about special phrase operator

3 years agofix parsing of operator in special phrases
Sarah Hoffmann [Mon, 25 Oct 2021 17:46:30 +0000 (19:46 +0200)]
fix parsing of operator in special phrases

Because of unstripped input, the operators wouldn't match.

3 years agoMerge pull request #2484 from lonvia/fix-index-use
Sarah Hoffmann [Mon, 25 Oct 2021 15:20:42 +0000 (17:20 +0200)]
Merge pull request #2484 from lonvia/fix-index-use

Reverse: add index hints

3 years agoMerge pull request #2483 from lonvia/fix-warming
Sarah Hoffmann [Mon, 25 Oct 2021 14:21:36 +0000 (16:21 +0200)]
Merge pull request #2483 from lonvia/fix-warming

Fix warming for ICU tokenizer

3 years agoreverse: add index hints
Sarah Hoffmann [Mon, 25 Oct 2021 12:55:15 +0000 (14:55 +0200)]
reverse: add index hints

The fairly complex where condition of idx_placex_geometry_placenode
won't always be matched by the query planner if the condition
part doesn't appear verbatim in the query.

Fixes #2480.