#5331 closed defect (fixed)

reverse geocoder sometimes doesn't return a street and address when it should

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 3.1.9
Component: tiger geocoder Version: 3.3.x
Keywords: Cc:

Description

There are a lot cases where reverse geocoder does not return an address, because tiger seems to have quite a few unnamed streets and many with no ranges, such as highways.

Planned fix is to prefer addressable ranges even if it isn't the closest as long as it's within 70 meters.

In my testing the new approach for this query:

SELECT pprint_addy(addy[1]), ST_ASText(intpt[1]) , (intpt[1]::geography <-> ST_SetSRID(var_pt,4269))::numeric(10,2) AS dist_m
FROM ST_Point( -122.077435,37.414167) AS var_pt, tiger.reverse_geocode_testing( var_pt );

Will give

                pprint_addy                 |                  st_astext                  | dist_m
---------------------------------------------+---------------------------------------------+--------
 1382 la Avenida St, Mountain View, CA 94043 | POINT(-122.0775952717109 37.41362206134327) |  62.23
(1 row)

vs. the old apprach

               pprint_addy                |                  st_astext                   | dist_m
-------------------------------------------+----------------------------------------------+--------
 N Shoreline Blvd, Mountain View, CA 94043 | POINT(-122.07799538107314 37.41415350501974) |  49.51
(1 row)

I'm going to test with several more. I had already deleted some unnamed streets from my set to avoid blank addresses being returned, so in many cases the situation is worse than this.

Change History (4)

comment:1 by Regina Obe <lr@…>, 23 months ago

In 58b3f23/git:

Prefer street segments that have a street name
and address range over those missing either piece,
as long as they are within 70 meters of reference point
References #5331 for PostGIS 3.4.0

comment:2 by Regina Obe <lr@…>, 21 months ago

In f31f63bb/git:

Prefer street segments that have a street name
and address range over those missing either piece,
as long as they are within 70 meters of reference point
References #5331 for PostGIS 3.3.3

comment:3 by Regina Obe <lr@…>, 19 months ago

In a9b8a40/git:

Prefer street segments that have a street name
and address range over those missing either piece,
as long as they are within 70 meters of reference point
References #5331 for PostGIS 3.2.4

comment:4 by Regina Obe <lr@…>, 19 months ago

Resolution: fixed
Status: newclosed

In c0eb7ae/git:

Prefer street segments that have a street name
and address range over those missing either piece,
as long as they are within 70 meters of reference point
Closes #5331 for PostGIS 3.1.9

Note: See TracTickets for help on using tickets.