[postgis-devel] [PostGIS] #1052: Tiger Geocoder 2010 Geocode() to even/odd side of street

[PostGIS]

#1052: Tiger Geocoder 2010 Geocode() to even/odd side of street
-------------------------+--------------------------------------------------
 Reporter:  mikepease    |       Owner:  pramsey      
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.0.0
Component:  postgis      |     Version:  1.5.X        
 Keywords:               |  
-------------------------+--------------------------------------------------
 I've been comparing the results of the Tiger Geocoder to Google's
 Geocoder.  I sent in a list of about 70,000 addresses in Minnesota.
 I'm getting about 89% successful results where Google's geocode and
 Tiger's geocode produce similar results.  Not bad.


 One difference that I'd love to see in the Tiger Geocoder would be to
 place an address point either on the even or odd side of the street.  It
 appears that the geocodes are all placed on the center line of the street.
 Is that correct?


 It would be super cool if you could determine which side of the street an
 address is on and then shift the geocode to that side, say by 20 meters
 (65 feet).  Now, determining which angle to translate the point can be a
 trick, for sure.

 I did a similar operation in the past by grabbing a short line segment
 from the street and rotating it 90 degrees in order to find the even/odd
 side offsets from the center line.  That code looked like this:

 rotate_oncenter(
 MakeLine(ST_Line_Interpolate_Point(ST_GeometryN(the_geom,1),
 offset_percent1 ),
 ST_Line_Interpolate_Point(ST_GeometryN(the_geom,1), offset_percent2 ))
                         , 90) as rotated_line

 ...
 then you could use the end points of this rotated segment to get the
 even/odd odd side of the street.
 ST_Line_Interpolate_Point(rotated_line,0) --even side of street
 ST_Line_Interpolate_Point(rotated_line,1) --odd side of street

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1052>
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.