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

[PostGIS]

#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):

 Okay I think this one is a typo in tiger data.

 This query should give me all the streets that are around the right
 location of El Cajon Fremont, CA
 {{{
 SELECT f.*, e.lfromadd, e.ltoadd, e.rfromadd, e.zipl,
 ST_AsText(ST_Centroid(the_geom)) As b
         from tiger_data.ca_edges As e INNER JOIN tiger_data.ca_featnames
 AS f ON e.tlid = f.tlid where
 ST_DWithin(ST_GeomFromText('POINT(-122.024396
 37.558286)',4269),the_geom,0.005)
 order by ST_Distance(ST_GeomFromText('POINT(-122.024396
 37.558286)',4269),e.the_geom), f.fullname
 limit 10;
 }}}

 If I run the above query, the first match I get is

 El Canon Ave

 Looking at Google, I think that should be El Cajon.

 I haven't had a chance to look at your other entries -- does that file
 just contain all failures or is it a mishmush of failures and successes?

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