[postgis-devel] [PostGIS] #1068: Some addresses are very slow to Geocode

[PostGIS]

#1068: Some addresses are very slow to Geocode
----------------------------+-----------------------------------------------
 Reporter:  mikepease       |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  1.5.X        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 Most of the time, my 2Ghz 3.5GB RAM Windows Vista laptop with Postgres
 8.4.8/ PostGIS 1.5 will do a reasonably quick geocode taking from about
 0.1 seconds to about 6 seconds.

 But, a small handful of addresses take a very long time.
 About 2 to 4 minutes.

 There appears to be a pattern of incorrectly spelled street names
 correlating to these long searches.

 Here's some scenarios that appear in my data:[[BR]]

 1) Incorrect ordinal suffix used on street number (e.g. TH instead of RD)

 2) Street numbers with a 1/2 (e.g. 33 1/2 St)

 3) Pre-direction with a period (e.g. W. instead of W)

 Here's a listing of specific addresses that took a long time to run:


 Seconds Rating  Original_Address        Geocoded_Address[[BR]]

 151.856 10              "3937 43TH AVE S, MINNEAPOLIS, MN 55406"
 "3937 40th Ave S, Minneapolis, MN 55406"[[BR]]

 147.047 10              "6285 143TH LANE NW, RAMSEY, MN 55303-4635"
 "6285 145th Ln NW, Ramsey, MN 55303"[[BR]]

 152.608 10              "6015 2  1/2 ST NE, FRIDLEY, MN 55432"  "6015 2
 1/2 St NE, Fridley, MN 55432"[[BR]]

 146.024 10              "3504 33TH AVE S, MINNEAPOLIS, MN 55406"
 "3504 34th Ave S, Minneapolis, MN 55406"[[BR]]

 146.475 10              "3317 32TH AVE S, MINNEAPOLIS, MN 55406"
 "3317 39th Ave S, Minneapolis, MN 55406"[[BR]]

 151.847 10              "3937 43TH AVE S, MINNEAPOLIS, MN 55406"
 "3937 40th Ave S, Minneapolis, MN 55406"[[BR]]

 141.642 10              "6020 6TTH ST NE, FRIDLEY, MN 55432"    "6020 6th
 St NE, Fridley, MN 55432"[[BR]]

 134.803 10              "2441 131TH AVE NW, COON RAPIDS, MN 55448-2554"
 "2441 130th Ave NW, Coon Rapids, MN 55448"[[BR]]

 130.096 10              "200 W. 46TH ST, MINNEAPOLIS, MN 55400" "200 W
 46th St, Minneapolis, MN 55419"[[BR]]

 150.210 10              "6015 2  1/2 ST NE, FRIDLEY, MN 55432"  "6015 2
 1/2 St NE, Fridley, MN 55432"[[BR]]

 134.722 10              "2441 131TH AVE NW, COON RAPIDS, MN 55448-2554"
 "2441 130th Ave NW, Coon Rapids, MN 55448"[[BR]]

 128.609 10              "105 W. 35TH ST, MINNEAPOLIS, MN 55408" "105 W
 35th St, Minneapolis, MN 55408"[[BR]]

 129.624 10              "105 W. 35TH ST, MINNEAPOLIS, MN 55408" "105 W
 35th St, Minneapolis, MN 55408"[[BR]]

 129.164 10              "105 W. 35TH ST, MINNEAPOLIS, MN 55408" "105 W
 35th St, Minneapolis, MN 55408"[[BR]]

 136.992 10              "11 621/2 WAY, FRIDLEY, MN 55432"       "11 62 1/2
 Way NE, Fridley, MN 55432"[[BR]]

 138.750 12              "2011 122TH ST E, BURNSVILLE, MN 55337-4177"
 "2011 E 125th St, Burnsville, MN 55337"[[BR]]

 128.056 12              "171 63TH WAY NE, FRIDLEY, MN 55432"    "64th Way
 NE, Fridley, MN 55432"[[BR]]

 147.613 15              "12775 73TH PL N, MAPLE GROVE, MN 55369"
 "f"[[BR]]

 139.056 23              "322 W 59 1/2 St, Minneapolis, MN 55419"
 "f"[[BR]]

 153.953 24              "5900 25 1/2 ST W, ST. LOUIS PARK, MN 55416"
 "f"[[BR]]

 142.701 26              "3808 26 1/2 AVE N, ROBBINSDALE, MN 55422"
 "f"[[BR]]

 148.425 29              "7008 74 1/2 AVE N, BROOKLYN PARK, MN 55428"
 "f"[[BR]]

 146.929 29              "6601 75 1/2 AVE N, BROOKLYN PARK, MN 55428"
 "f"[[BR]]

 122.078 30              "501 1/2 6TH ST, NEWPORT, MN 55055"     "501 12th
 St, Newport, MN 55055"[[BR]]

 174.816 31              "7017-21 74 1/2 AVE N, BROOKLYN PARK, MN 55428"
 "f"[[BR]]

 174.876 31              "7016-20 74 1/2 AVE N, BROOKLYN PARK, MN 55428"
 "f"[[BR]]

 129.264 33              "317 1/2 8TH ST SE, MINNEAPOLIS, MN 55414"
 "f"[[BR]]

 137.373 35              "7353 1/2 15th St N, Oakdale, MN 55128" "f"[[BR]]

 142.824 40              "2515 1/2 16TH AVE S, MINNEAPOLIS, MN
 55404"  "f"[[BR]]

 147.729 40              "3026 1/2 36TH AVE S, MINNEAPOLIS, MN 55406"
 "3026 36th Ave S, Minneapolis, MN 55406"[[BR]]

 147.313 40              "3026 1/2 36TH AVE S, MINNEAPOLIS, MN 55406"
 "3026 36th Ave S, Minneapolis, MN 55406"[[BR]]

 131.022 40              "142 1/2 27TH AVE SE, MINNEAPOLIS, MN 55414-3436"
 "142 27th Ave SE, Minneapolis, MN 55414"[[BR]]

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