[postgis-devel] [PostGIS] #1074: Matching on different street spelling?
PostGIS
trac at osgeo.org
Thu Jul 7 09:02:36 PDT 2011
#1074: Matching on different street spelling?
----------------------------+-----------------------------------------------
Reporter: mikepease | Owner: robe
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.0.0
Component: tiger geocoder | Version: 1.5.X
Keywords: |
----------------------------+-----------------------------------------------
Comment(by mikepease):
Hopefully this is more helpful than annoying.
Here's 3 more example cases of this issue:
1701 Main Street, Hopkins, MN 55343 -> (works with Mainstreet)
1421 ENERGY PARK DR, ST. PAUL, MN 55108 -> (works with ENERGYPARK DR)
4343 MEADOW BROOK BLVD, ST. LOUIS PARK, MN 55416 -> (works with
MEADOWBROOK BLVD)
--works
select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon, *
from geocode('1701 MainStreet, Hopkins, MN 55343')
--doesn't work
select abs(ST_X(geomout)::numeric(8,5)) || 'W, ' ||
ST_Y(geomout)::numeric(8,5) || 'N' as lat_lon, *
from geocode('1701 Main Street, Hopkins, MN 55343')
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1074#comment:5>
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