Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#1856 closed enhancement (fixed)

reverse geocoder rating setting for prefer numbered highway name

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 2.1.0
Component: tiger geocoder Version: master
Keywords: history Cc:

Description

Many highways have a local name and a numbered state, county, interstate number. When the reverse geocoder returns an address on one of these, currently it arbitrarily picks one alias preferring ones that have names and higher alphabetically. Some people don't like that (like the company paying me for this change).

This will be a new entry in geocode_settings table called: reverse_geocode_numbered_roads

Which will be an integer that has value 0, 1 , 2

0 - don't care just give me some name for this road 1 - Prefer the numbered alias 2 - Prefer the local state or county name for road

This will also require change to reverse_geocode function to check this setting and act accordingly.

Change History (2)

comment:1 by robe, 12 years ago

Resolution: fixed
Status: newclosed

completed at r9861. To prefer numbered name you would do

SELECT set_geocode_setting('reverse_geocode_numbered_roads', '1');
SELECT pprint_addy((reverse_geocode('POINT(-71.355863 42.602466)'::geometry)).addy[1])

Gives output of:

I- 495, Chelmsford, MA 01824

To prefer local name

SELECT set_geocode_setting('reverse_geocode_numbered_roads', '2');
SELECT pprint_addy((reverse_geocode('POINT(-71.355863 42.602466)'::geometry)).addy[1])

Example:

SELECT pprint_addy((reverse_geocode('POINT(-71.355863 42.602466)'::geometry)).addy[1]);
Hwy Blue Star Memorial, Chelmsford, MA 01824

comment:2 by robe, 12 years ago

Keywords: history added
Note: See TracTickets for help on using tickets.