+-- SPDX-License-Identifier: GPL-2.0-only
+--
+-- This file is part of Nominatim. (https://nominatim.org)
+--
+-- Copyright (C) 2022 by the Nominatim developer community.
+-- For a full list of authors see the git log.
+
-- Functions for returning address information for a place.
DROP TYPE IF EXISTS addressline CASCADE;
END IF;
END LOOP;
- -- anything will do as a fallback - just take the first name type thing there is
- RETURN trim((avals(name))[1]);
+ -- as a fallback - take the last element since it is the default name
+ RETURN trim((avals(name))[array_length(avals(name), 1)]);
END;
$$
LANGUAGE plpgsql IMMUTABLE;
DECLARE
place addressdata_place;
location RECORD;
+ country RECORD;
current_rank_address INTEGER;
location_isaddress BOOLEAN;
BEGIN
END IF;
--then query tiger data
- -- %NOTIGERDATA% IF 0 THEN
+ {% if config.get_bool('USE_US_TIGER_DATA') %}
IF place IS NULL AND in_housenumber >= 0 THEN
SELECT parent_place_id as place_id, 'us' as country_code,
in_housenumber as housenumber, postcode,
WHERE place_id = in_place_id
AND in_housenumber between startnumber and endnumber;
END IF;
- -- %NOTIGERDATA% END IF;
-
- -- %NOAUXDATA% IF 0 THEN
- IF place IS NULL THEN
- SELECT parent_place_id as place_id, 'us' as country_code,
- housenumber, postcode,
- 'place' as class, 'house' as type,
- null as name, null as address,
- centroid
- INTO place
- FROM location_property_aux
- WHERE place_id = in_place_id;
- END IF;
- -- %NOAUXDATA% END IF;
+ {% endif %}
-- postcode table
IF place IS NULL THEN
-- POI objects in the placex table
IF place IS NULL THEN
SELECT parent_place_id as place_id, country_code,
- housenumber, postcode,
+ coalesce(address->'housenumber',
+ address->'streetnumber',
+ address->'conscriptionnumber')::text as housenumber,
+ postcode,
class, type,
name, address,
centroid
-- place we should be using instead.
IF place IS NULL THEN
select coalesce(linked_place_id, place_id) as place_id, country_code,
- housenumber, postcode,
+ null::text as housenumber, postcode,
class, type,
null as name, address,
null as centroid
-- --- Return the record for the base entry.
+ current_rank_address := 1000;
FOR location IN
SELECT placex.place_id, osm_type, osm_id, name,
coalesce(extratags->'linked_place', extratags->'place') as place_type,
WHERE place_id = place.place_id
LOOP
--RAISE WARNING '%',location;
+ -- mix in default names for countries
+ IF location.rank_address = 4 and place.country_code is not NULL THEN
+ FOR country IN
+ SELECT coalesce(name, ''::hstore) as name FROM country_name
+ WHERE country_code = place.country_code LIMIT 1
+ LOOP
+ place.name := country.name || place.name;
+ END LOOP;
+ END IF;
+
IF location.rank_address < 4 THEN
-- no country locations for ranks higher than country
place.country_code := NULL::varchar(2);
FOR location IN
SELECT placex.place_id, osm_type, osm_id, name, class, type,
coalesce(extratags->'linked_place', extratags->'place') as place_type,
- admin_level, fromarea, isaddress,
+ admin_level, fromarea, isaddress and linked_place_id is NULL as isaddress,
CASE WHEN rank_address = 11 THEN 5 ELSE rank_address END as rank_address,
distance, country_code, postcode
FROM place_addressline join placex on (address_place_id = placex.place_id)
OR placex.country_code = place.country_code)
ORDER BY rank_address desc,
(place_addressline.place_id = in_place_id) desc,
- (fromarea and place.centroid is not null and not isaddress
- and (place.address is null or avals(name) && avals(place.address))
- and ST_Contains(geometry, place.centroid)) desc,
- isaddress desc, fromarea desc,
- distance asc, rank_search desc
+ (CASE WHEN coalesce((avals(name) && avals(place.address)), False) THEN 2
+ WHEN isaddress THEN 0
+ WHEN fromarea
+ and place.centroid is not null
+ and ST_Contains(geometry, place.centroid) THEN 1
+ ELSE -1 END) desc,
+ fromarea desc, distance asc, rank_search desc
LOOP
-- RAISE WARNING '%',location;
location_isaddress := location.rank_address != current_rank_address;
-- If the place had a postcode assigned, take this one only
-- into consideration when it is an area and the place does not have
-- a postcode itself.
- IF location.fromarea AND location.isaddress
+ IF location.fromarea AND location_isaddress
AND (place.address is null or not place.address ? 'postcode')
THEN
place.postcode := null; -- remove the less exact postcode
-- If no country was included yet, add the name information from country_name.
IF current_rank_address > 4 THEN
FOR location IN
- SELECT name FROM country_name WHERE country_code = place.country_code LIMIT 1
+ SELECT name || coalesce(derived_name, ''::hstore) as name FROM country_name
+ WHERE country_code = place.country_code LIMIT 1
LOOP
--RAISE WARNING '% % %',current_rank_address,searchcountrycode,countryname;
RETURN NEXT ROW(null, null, null, location.name, 'place', 'country', NULL,
location := ROW(null, null, null, hstore('ref', place.postcode), 'place',
'postcode', null, null, false, true, 5, 0)::addressline;
RETURN NEXT location;
+ ELSEIF place.address is not null and place.address ? 'postcode'
+ and not place.address->'postcode' SIMILAR TO '%(,|;)%' THEN
+ location := ROW(null, null, null, hstore('ref', place.address->'postcode'), 'place',
+ 'postcode', null, null, false, true, 5, 0)::addressline;
+ RETURN NEXT location;
END IF;
RETURN;
projects / nominatim.git / blobdiff