From 4aeda6540aa330dbf1474b8cc7a229b9165dbd5a Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sat, 13 Apr 2013 07:15:18 +0000 Subject: [PATCH] #2260 - fix normalize discrepancy in pagc handling service drives git-svn-id: http://svn.osgeo.org/postgis/trunk@11290 b70326c6-7e19-0410-871a-916f4a2858ee --- .../tiger_geocoder/tiger_2011/pagc_normalize/pagc_tables.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/extras/tiger_geocoder/tiger_2011/pagc_normalize/pagc_tables.sql b/extras/tiger_geocoder/tiger_2011/pagc_normalize/pagc_tables.sql index c3fd682c3..e750dfd26 100644 --- a/extras/tiger_geocoder/tiger_2011/pagc_normalize/pagc_tables.sql +++ b/extras/tiger_geocoder/tiger_2011/pagc_normalize/pagc_tables.sql @@ -3799,6 +3799,9 @@ INSERT INTO pagc_lex (id, seq, word, stdword, token, is_custom) VALUES (1766, 1, INSERT INTO pagc_lex (id, seq, word, stdword, token, is_custom) VALUES (1769, 1, 'NORTHEAST', 'NE', 22, false); INSERT INTO pagc_lex (id, seq, word, stdword, token, is_custom) VALUES (1771, 1, 'NTH', 'N', 22, false); INSERT INTO pagc_lex (id, seq, word, stdword, token, is_custom) VALUES (1774, 1, 'NW', 'NW', 22, false); +INSERT INTO pagc_lex (id, seq, word, stdword, token, is_custom) VALUES (2931, 1, 'SERVICE DR', 'Svc Dr', 2, false); +INSERT INTO pagc_lex (id, seq, word, stdword, token, is_custom) VALUES (2932, 1, 'SERVICE DRIVE', 'Svc Dr', 2, false); +INSERT INTO pagc_lex (id, seq, word, stdword, token, is_custom) VALUES (2933, 1, 'SVC DR', 'Svc Dr', 2, false); SELECT pg_catalog.setval('pagc_lex_id_seq', (SELECT greatest((SELECT MAX(id) FROM pagc_lex),50000)), true); -- 2.50.1