X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/afeafc8aa797a9051fc43a4482165c563a834a3f..bc7adbae2bc8ebc61bca3800155d070908502dd9:/lib-sql/functions/importance.sql diff --git a/lib-sql/functions/importance.sql b/lib-sql/functions/importance.sql index 44e8bc8b..9b2fb773 100644 --- a/lib-sql/functions/importance.sql +++ b/lib-sql/functions/importance.sql @@ -62,10 +62,6 @@ BEGIN WHILE langs[i] IS NOT NULL LOOP wiki_article := extratags->(case when langs[i] in ('english','country') THEN 'wikipedia' ELSE 'wikipedia:'||langs[i] END); IF wiki_article is not null THEN - wiki_article := regexp_replace(wiki_article,E'^(.*?)([a-z]{2,3}).wikipedia.org/wiki/',E'\\2:'); - wiki_article := regexp_replace(wiki_article,E'^(.*?)([a-z]{2,3}).wikipedia.org/w/index.php\\?title=',E'\\2:'); - wiki_article := regexp_replace(wiki_article,E'^(.*?)/([a-z]{2,3})/wiki/',E'\\2:'); - --wiki_article := regexp_replace(wiki_article,E'^(.*?)([a-z]{2,3})[=:]',E'\\2:'); wiki_article := replace(wiki_article,' ','_'); IF strpos(wiki_article, ':') IN (3,4) THEN wiki_article_language := lower(trim(split_part(wiki_article, ':', 1))); @@ -134,7 +130,7 @@ BEGIN -- Still nothing? Fall back to a default. IF result.importance is null THEN - result.importance := 0.75001 - (rank_search::float / 40); + result.importance := 0.40001 - (rank_search::float / 75); END IF; {% if 'secondary_importance' in db.tables %}