directional as a street name should not be abbreviated

[robe]

Currently tiger geocoder expects pref directions to be abbreviated, but street names should not be.

pagc_normalize_address unfortunately does this:

SELECT predirabbrev, streetname, streettypeabbrev
FROM pagc_normalize_address('41 north st, boston, ma 02109');
-- not okay would prefer streetname = 'NORTH'
 predirabbrev | streetname | streettypeabbrev
--------------+------------+------------------
              | N          | ST

Though this works as hoped

SELECT predirabbrev, streetname, streettypeabbrev
FROM pagc_normalize_address('41 north washington st, boston, ma 02109');

 predirabbrev | streetname | streettypeabbrev
--------------+------------+------------------
 N            | WASHINGTON | ST

[robe]

Doing this seems to do the trick though need to test some more before I commit.

-- define NORTH and SOUTH as regular words 
INSERT INTO pagc_lex(seq, word, stdword, token, is_custom)
SELECT seq, word, stdword, token, false
FROM (VALUES ( 2, 'NORTH', 'NORTH', 1),
 (2, 'SOUTH', 'SOUTH', 1) ) As f(seq,word,stdword,token);

-- now that we have north and south are regular words if they are seen with 
-- an additional word we want it treated as directional token (unfortunately the 
-- word token ranks higher causing this one to always be ignored -- so up this one

UPDATE pagc_rules SET RULE = '0 22 1 2 -1 1 2 5 6 -1 1 17' WHERE rule = '0 22 1 2 -1 1 2 5 6 -1 1 16';

-- may want to consider lowering the 0 1 2 -1 1 5 6 -1 1    rule -

So after the above change I have:

{{{SELECT predirabbrev, streetname, streettypeabbrev FROM pagc_normalize_address('41 north st, boston, ma 02109');

predirabbrev | streetname | streettypeabbrev

---

| NORTH | ST

predirabbrev | streetname | streettypeabbrev

---

N | WASHINGTON | ST

}}}

[robe]

Let me try that again:

-- define NORTH and SOUTH as regular words 
INSERT INTO pagc_lex(seq, word, stdword, token, is_custom)
SELECT seq, word, stdword, token, false
FROM (VALUES ( 2, 'NORTH', 'NORTH', 1),
 (2, 'SOUTH', 'SOUTH', 1) ) As f(seq,word,stdword,token);

-- now that we have north and south are regular words if they are seen with 
-- an additional word we want it treated as directional token (unfortunately the 
-- word token ranks higher causing this one to always be ignored -- so up this one

UPDATE pagc_rules SET RULE = '0 22 1 2 -1 1 2 5 6 -1 1 17' WHERE rule = '0 22 1 2 -1 1 2 5 6 -1 1 16';

-- may want to consider lowering the 0 1 2 -1 1 5 6 -1 1

SELECT predirabbrev, streetname, streettypeabbrev FROM pagc_normalize_address('41 north st, boston, ma 02109'); 

predirabbrev | streetname | streettypeabbrev
-------------+------------+------------------
             | NORTH      | ST

SELECT predirabbrev, streetname, streettypeabbrev
FROM pagc_normalize_address('41 north washington st, boston, ma 02109');

 predirabbrev | streetname | streettypeabbrev
--------------+------------+------------------
 N            | WASHINGTON | ST

[robe]

This still needs work now makes North Street -- N street which is wrong:

SELECT predirabbrev, streetname, streettypeabbrev FROM pagc_normalize_address('41 north st, boston, ma 02109'); 

 predirabbrev | streetname | streettypeabbrev
--------------+------------+------------------
              | N          | ST

[robe]

fixed at r13963