[postgis-tickets] [PostGIS] #1110: Saint Paul vs. St. Paul

[PostGIS]

#1110: Saint Paul vs. St. Paul
----------------------------+-----------------------------------------------
 Reporter:  mikepease       |       Owner:  robe          
     Type:  defect          |      Status:  new           
 Priority:  high            |   Milestone:  PostGIS Future
Component:  tiger geocoder  |     Version:  1.5.X         
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by mattybe):

 Thanks, Steve. I also found a workaround following the advice you gave
 here:  http://lists.osgeo.org/pipermail/postgis-
 users/2014-April/039096.html


 {{{
 spatial=# select (addy).*, g.rating from geocode('200 East Washington
 Street, Indianapolis, IN 46204') as g;
  address | predirabbrev | streetname | streettypeabbrev | postdirabbrev |
 internal |          location           | stateabbrev |  zip  | parsed |
 rating
 ---------+--------------+------------+------------------+---------------+----------+-----------------------------+-------------+-------+--------+--------
      200 | E            | Washington | St               |               |
 | Indianapolis city (balance) | IN          | 46204 | t      |     15
      300 | E            | Washington | St               |               |
 | Indianapolis city (balance) | IN          | 46202 | t      |     24

 spatial=# CREATE TABLE tiger_data.IN_place_add(CONSTRAINT pk_IN_place_add
 PRIMARY KEY (plcidfp) , CONSTRAINT chk_statefp CHECK (statefp::text =
 '18'::text)) INHERITS(place);
 spatial=# insert into tiger_data.IN_place_add select * from place where
 name like 'Indianapolis%';
 spatial=# update tiger_data.IN_place_add set name='Indianapolis',
 namelsad='Indianapolis';
 spatial=#  SELECT install_missing_indexes();
 spatial=# select (addy).*, g.rating from geocode('200 East Washington
 Street, Indianapolis, IN 46204') as g;
  address | predirabbrev | streetname | streettypeabbrev | postdirabbrev |
 internal |   location   | stateabbrev |  zip  | parsed | rating
 ---------+--------------+------------+------------------+---------------+----------+--------------+-------------+-------+--------+--------
      200 | E            | Washington | St               |               |
 | Indianapolis | IN          | 46204 | t      |      0
 (1 row)
 }}}

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