Ticket #1108 (new defect)

Opened 23 months ago

Last modified 8 weeks ago

normalize_address: Internal address prefix sometimes get caught in post dir

Reported by: robe Owned by: robe
Priority: high Milestone: PostGIS Future
Component: tiger geocoder Version: trunk
Keywords: Cc:

Description (last modified by robe) (diff)

-- 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

Changed 23 months ago by robe

  • description modified (diff)

Changed 23 months ago by robe

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

Changed 23 months ago by mikepease

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')

Changed 15 months ago by robe

  • milestone changed from PostGIS 2.0.0 to PostGIS 2.1.0

Changed 15 months ago by robe

  • milestone changed from PostGIS 2.1.0 to PostGIS 2.0.1

Changed 12 months ago by robe

  • milestone changed from PostGIS 2.0.1 to PostGIS 2.1.0

Changed 7 months ago by woodbri

  • cc woodbri added

Changed 5 months ago by woodbri

  • cc woodbri removed

Changed 8 weeks ago by robe

  • milestone changed from PostGIS 2.1.0 to PostGIS Future
Note: See TracTickets for help on using tickets.