directional prefix ending up in directional postprefix (at least for highways)

[robe]

This is something I notices with brian's examples in #1077. I haven't added these to regress, since they don't behave right.

So for example:

SELECT pprint_addy(addy) As pp, addy.* FROM normalize_address('18208 N COUNTY ROAD 241, ALACHUA, FL 32615') AS addy;


                  pp                  | address | predirabbrev | streetname | streettypeabbrev | postdirabbrev | internal | location | stateabbrev |  zip  | parsed 
--------------------------------------+---------+--------------+------------+------------------+---------------+----------+----------+-------------+-------+--------
 18208 Co Rd 241 N, ALACHUA, FL 32615 |   18208 |              | 241        | Co Rd            | N             |          | ALACHUA  | FL          | 32615 | t

When the N should be in the predirabbrev column

[robe]

note I'm pushing all these to 2.1. I'm changing 2.1 significantly so it wil be hard to patch back to 2.0.1 and besides who wants to use 2010 data when they can use 2011 data.

[woodbri]

PAGC tools handle this.

[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

[robe]

nevermind. Figured it out.

[robe]

pagc handles this right so closing out.