Opened 10 years ago

Closed 10 years ago

#2694 closed defect (duplicate)

Saint vs St in street names

Reported by: mattybe Owned by: robe
Priority: medium Milestone:
Component: tiger geocoder Version: 2.1.x
Keywords: Cc:

Description

Geocoder seems unable to handle "Saint" spelled out in a street name if the underlying data is stored as "St" (note that the first result is in Long Island) 

spatial=> select g.* from geocode('769 Saint Marks Ave, Brooklyn, NY 11213', 1) as g;
                      addy                      |                      geomout                       | rating
------------------------------------------------+----------------------------------------------------+--------
 (769,,"Saint Marks",Ave,,,Bellmore,NY,11710,t) | 0101000020AD1000003ECC9E12D76152C0A2B40FAE42554440 |      9
(1 row)

spatial=> select g.* from geocode('769 St Marks Ave, Brooklyn, NY 11213', 1) as g;
                     addy                      |                      geomout                       | rating
-----------------------------------------------+----------------------------------------------------+--------
 (769,,"St Marks",Ave,,,"New York",NY,11213,t) | 0101000020AD10000063606369957C52C05DC05D086A564440 |      8
(1 row)

spatial=> select g.* from geocode('769 St Marks Ave, New York, NY 11213', 1) as g;
                     addy                      |                      geomout                       | rating
-----------------------------------------------+----------------------------------------------------+--------
 (769,,"St Marks",Ave,,,"New York",NY,11213,t) | 0101000020AD10000063606369957C52C05DC05D086A564440 |      0
(1 row)

Change History (1)

comment:1 by robe, 10 years ago

Resolution: → duplicate
Status: new → closed

this is a duplicate of #1110

Note: See TracTickets for help on using tickets.