[postgis-devel] [PostGIS] #1068: Some addresses are very slow to Geocode
PostGIS
trac at osgeo.org
Mon Jun 27 11:59:36 PDT 2011
#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.
More information about the postgis-devel
mailing list