Opened 13 years ago

Closed 9 years ago

#1108 closed defect (fixed)

normalize_address: Internal address prefix sometimes get caught in post dir

Reported by: robe Owned by: robe
Priority: high Milestone: PostGIS 2.2.0
Component: tiger geocoder Version: master
Keywords: Cc:

Description (last modified by robe)

— this works

SELECT * FROM normalize_address('529 Main Street, Apt 201, Boston, MA 02129');

 address | predirabbrev | streetname | streettypeabbrev | postdirabbrev | internal | location | stateabbrev |  zip  | parsed 
---------+--------------+------------+------------------+---------------+----------+----------+-------------+-------+--------
     529 |              | Main       | St               |               | Apt 201  | Boston   | MA          | 02129 | t

But this has Suite bleed into postdirabbrev because it starts with S

SELECT * FROM normalize_address('529 Main Street, Suite 201, Boston, MA 02129');
 address | predirabbrev | streetname | streettypeabbrev | postdirabbrev | internal  | location | stateabbrev |  zip  | parsed 
---------+--------------+------------+------------------+---------------+-----------+----------+-------------+-------+--------
     529 |              | Main       | St               | S             | Suite 201 | Boston   | MA          | 02129 | t

Change History (10)

comment:1 by robe, 13 years ago

Description: modified (diff)

comment:2 by robe, 13 years ago

Also # leaves out internal address.

SELECT * FROM normalize_address('529 Main Street, #201, Boston, MA 02129');

 address | predirabbrev | streetname | streettypeabbrev | postdirabbrev | internal | location | stateabbrev |  zip  | parsed 
---------+--------------+------------+------------------+---------------+----------+----------+-------------+-------+--------
     529 |              | Main       | St               |               |          | Boston   | MA          | 02129 | t

comment:3 by mikepease, 13 years ago

This seems like another example of the internal component confusing the normalizer.

—doesn't work

select abs(ST_X(geomout)::numeric(8,5))
'W, ' ST_Y(geomout)::numeric(8,5) 'N' as lat_lon, *

from geocode('155 Wabasha St S Ste 129, St. Paul, MN 55107')

—works!

select abs(ST_X(geomout)::numeric(8,5))
'W, ' ST_Y(geomout)::numeric(8,5) 'N' as lat_lon, *

from geocode('155 Wabasha St S Suite 129, St. Paul, MN 55107')

comment:4 by robe, 12 years ago

Milestone: PostGIS 2.0.0PostGIS 2.1.0

comment:5 by robe, 12 years ago

Milestone: PostGIS 2.1.0PostGIS 2.0.1

comment:6 by robe, 12 years ago

Milestone: PostGIS 2.0.1PostGIS 2.1.0

comment:7 by woodbri, 11 years ago

Cc: woodbri added

comment:8 by woodbri, 11 years ago

Cc: woodbri removed

comment:9 by robe, 11 years ago

Milestone: PostGIS 2.1.0PostGIS Future

comment:10 by robe, 9 years ago

Milestone: PostGIS FuturePostGIS 2.2.0
Resolution: fixed
Status: newclosed

This seems to work fine now. Not sure what changed. Put in a regression test to verify at r13987 for built-in normalize_address, and r13988 for address_standardizer augmented pagc_normalize_address

Note: See TracTickets for help on using tickets.