[postgis-devel] [PostGIS] #1118: Street pretypes that aren't directional prefixes

[PostGIS]

#1118: Street pretypes that aren't directional prefixes
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  robe          
     Type:  defect          |      Status:  new           
 Priority:  medium          |   Milestone:  PostGIS Future
Component:  tiger geocoder  |     Version:  1.5.X         
 Keywords:                  |  
----------------------------+-----------------------------------------------
Changes (by jmarca):

 * cc: jmarca (added)


Comment:

 California examples:

 Wrong answer, right question:

 {{{
 #!sql
 select pprint_addy(addy), st_astext(geomout),rating FROM  geocode( 'Via
 Verde, Dana Point CA');
 }}}
 ||                   pprint_addy                   ||
 st_astext                 || rating ||
 || Via Verde Ct, Calabasas, CA 91302               ||
 POINT(-118.659995686466 34.1275841694006) ||     41   ||


 Right answer, wrong question:
 {{{
 #!sql
 select pprint_addy(addy), st_astext(geomout),rating FROM  geocode( 'Verde
 Via, Dana Point CA');
 }}}
 || pprint_addy            || st_astext || rating ||
 || Verde Via, Dana Point, CA 92624   || POINT(-117.672816628784
 33.4623777015046) ||     38 ||

 Wrong answer, right question:

 {{{
 #!sql
 select pprint_addy(addy), st_astext(geomout),rating FROM  geocode( 'Camino
 Las Ramblas, San Juan Capistrano CA');
 }}}

 ||            pprint_addy             ||                 st_astext
 || rating ||
 || Lago Cll, Dana Point, CA 92624     || POINT(-117.665451952078
 33.4629500870658) ||     60 ||
 || Lago Cll, San Clemente, CA 92672   || POINT(-117.629773684804
 33.4331286117088) ||     68 ||

 ...

 Right answer, wrong question

 {{{
 #!sql
 select pprint_addy(addy), st_astext(geomout),rating FROM  geocode( 'Las
 Ramblas Camino, San Juan Capistrano CA');
 }}}

 ||                  pprint_addy                   ||
 st_astext                 || rating ||
 || Cam Las Ramblas, San Juan Capistrano, CA 92675 ||
 POINT(-117.662978341711 33.4686616216608) ||     38 ||
 || Las Ramblas Dr, Concord, CA 94521              || POINT(-121.9494654272
 37.9565518802366)   ||     53 ||

 Variations on how Census treats text with "Las Ramblas"

 {{{
 #!sql
 select distinct fullname from addrfeat where fullname ~* 'Las Ramblas'
 limit 10;
 }}}

 ||     fullname    ||
 || Cam Las Ramblas ||
 || Via Las Ramblas ||
 || Cll Las Ramblas ||
 || Ave Las Ramblas ||
 || Las Ramblas Dr  ||
 || Las Ramblas     ||

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