[postgis-tickets] [PostGIS] #1127: directional prefix ending up in directional postprefix (at least for highways)

[PostGIS]

#1127: directional prefix ending up in directional postprefix (at least for
highways)
---------------------------------+------------------------------------------
 Reporter:  robe                 |       Owner:  robe         
     Type:  defect               |      Status:  new          
 Priority:  medium               |   Milestone:  PostGIS 2.1.0
Component:  pagc_address_parser  |     Version:  1.5.X        
 Keywords:                       |  
---------------------------------+------------------------------------------

Comment(by robe):

 This works, except I can't figure out how to get North to be N.  What
 table to change gaz or lex.


 {{{
 SELECT 'basic' As parser, pprint_addy(addy) As pp, addy.* FROM
 normalize_address('18208 N COUNTY ROAD 241, ALACHUA, FL 32615') AS addy
 UNION ALL
 SELECT 'pagc' As parser, pprint_addy(addy) As pp, addy.* FROM
 pagc_normalize_address('18208 N COUNTY ROAD 241, ALACHUA, FL 32615') AS
 addy;
 }}}

 Yields:

 {{{
  parser |                    pp                    | address |
 predirabbrev | streetname | streettypeabbrev | postdirabbrev | internal |
 location | stateabbrev
 |  zip  | parsed
 --------+------------------------------------------+---------+--------------+---
 ---------+------------------+---------------+----------+----------+-------------+-------+--------
  basic  | 18208 Co Rd 241 N, ALACHUA, FL 32615     |   18208 |
 | 24
 1        | Co Rd            | N             |          | ALACHUA  | FL
 | 32615 | t
  pagc   | 18208 NORTH Co Rd 241, ALACHUA, FL 32615 |   18208 | NORTH
 | 24
 1        | Co Rd            |               |          | ALACHUA  | FL
 | 32615 | t
 }}}

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