[postgis-devel] [PostGIS] #1148: Geocoder has poor results with correct inputs

PostGIS trac at osgeo.org
Thu Aug 4 17:34:10 PDT 2011


#1148: Geocoder has poor results with correct inputs
----------------------------+-----------------------------------------------
 Reporter:  darkblueb       |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  high            |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by robe):

 Brian,
 I looked at the others in this csv file, and all the other failures seem
 to be the result of incorrect normalization as mentioned in #1118.

 Interestingly you have this one in your list, which does geocode to the
 right location.

 {{{

 SELECT pprint_addy(addy), ST_AsText(ST_SnapToGrid(geomout,0.0001)) As
 coord, rating
         FROM geocode('5551 CORTE DEL CAJON, PLEASANTON, CA 94566',1) As g;
 }}}

 gives:

 {{{
 5551 del Cajon Corte, Pleasanton, CA 94566      POINT(-121.8895 37.6681)
 60
 }}}

 Which is right next to the google answer of: -121.889295, 37.668137
 and your Geocoder Y answer of: 37.667858  -121.889823

 (In fact google and tiger geocoder place it  on the same parcel and
 geocoder Y is one parcel away)
 But the rating it gives for the result is poor.  I presume you have this
 listed because the normalize/pretty print is wrong and/or the rating it
 gave is so low.

 This again is issue described in #1118 but just proves that even with this
 problem the geocoder sometimes gets the location right but displays the
 name wrong because the street type should go in front of the address
 instead of after.

 I think these two facts explain all the errors in the file
 1) Tiger data error (should be reported to Census)
 2) Pretypabbrev not being normalized correctly (is on my list to fix)

 Do you have other examples with poor results that don't fit case 2

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


More information about the postgis-devel mailing list