[postgis-devel] [PostGIS] #1051: Tiger Geocoder 2010 normalize_address bug - postDirAbbrev doesn't parse

[PostGIS]

#1051: Tiger Geocoder 2010 normalize_address bug - postDirAbbrev doesn't parse
-----------------------------+----------------------------------------------
  Reporter:  mikepease       |       Owner:  robe         
      Type:  defect          |      Status:  reopened     
  Priority:  critical        |   Milestone:  PostGIS 2.0.0
 Component:  tiger geocoder  |     Version:  1.5.X        
Resolution:                  |    Keywords:               
-----------------------------+----------------------------------------------
Changes (by mikepease):

  * status:  closed => reopened
  * resolution:  worksforme =>


Comment:

 Hi, Regina.  Thanks for looking into this.
 Unfortunately, it's still not working for me.

 I did an SVN update for this repository at:
 http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010

 It downloaded a few changed files.
 I then edited upgrade_geocoder.bat to have my database connection info in
 it.
 And then I ran it in a command prompt window.  All appeared to run
 properly.
 But, my normalize_address() queries are still not finding the
 postdirabbrev properly.

 Is there a way for me to easily verify that I'm running the same version
 you are?
 Any comment in the SQL functions or something?

 Could there be an issue that I'm running this on Postgres 8.4.8 and
 PostGIS 1.5.2 instead of Postrgres 9.0 / PostGIS 2.0?

 Here's some sample queries.  First the type the doesn't work and then
 variations that do work. Seems to parse the postdirabbrev if there is no
 street type or if there is an "internal" component (e.g. suite number).

 --doesn't get postdirabbrev
 select * from normalize_address('212 3rd Ave N, Minneapolis, MN 55401') ;
 --this works
 select * from normalize_address('212 3rd N, Minneapolis, MN 55401') ;
 --this works
 select * from normalize_address('212 3rd Ave N Suite 560, Minneapolis, MN
 55401') ;
 --this works
 select * from normalize_address('212 N 3rd Ave, Minneapolis, MN 55401') ;

 Thanks for the help.  I hope I can get this working.  If not, I probably
 can't use the Tiger Geocoder for my project because my database has lots
 of addresses with "N/S" suffixes.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1051#comment:4>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.