[postgis-tickets] [PostGIS] #1075: Too much info in address breaks geocoder

[PostGIS]

#1075: Too much info in address breaks geocoder
----------------------------+-----------------------------------------------
 Reporter:  mikepease       |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.1.0
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------
Changes (by robe):

  * version:  1.5.X => trunk
  * milestone:  PostGIS Future => PostGIS 2.1.0


Comment:

 Steven,

 thanks for the work on the parser, got it to compile and install on my
 ming32. Haven't tried yet on my ming64 but I assume since that is what you
 are using, there should be no issue.  I'm a bit puzzled by the
 standardizer.  How do I get it to give the abbreviated.

 e.g

 {{{
 select * from standardize_address(
         'select seq, word::text, stdword::text, token from lex order by
 id',
         'select seq, word::text, stdword::text, token from gaz order by
 id',
         'select * from rules order by id',
         'select 0::int4 as id, ''156 Galewski Dr Airport Industrial
 Park''::text as micro, ''Winona, MN 55987''::text as macro');

 }}}

 Yields:


 {{{
 id |        building         | house_num | predir | qual | pretype |
 name   |
 suftype | sufdir | ruralroute | extra |  city  |   state   | country |
 postcode
 | box | unit
 ---+-------------------------+-----------+--------+------+---------+----------+
 --------+--------+------------+-------+--------+-----------+---------+---------
 +-----+------
  0 | AIRPORT INDUSTRIAL PARK | 156       |        |      |         |
 GALEWSKI |
 DRIVE   |        |            |       | WINONA | MINNESOTA |         |
 55987
 |     |
 }}}


 Anyway going to start putting in tickets to integrate the PAGC parser.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1075#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.