[postgis-tickets] [PostGIS] #1604: normalize_address() confused by internal component
PostGIS
trac at osgeo.org
Tue Apr 2 11:08:14 PDT 2013
#1604: normalize_address() confused by internal component
----------------------------------+-----------------------------------------
Reporter: mikepease | Owner: robe
Type: defect | Status: closed
Priority: medium | Milestone: PostGIS 2.1.0
Component: pagc_address_parser | Version: trunk
Resolution: fixed | Keywords:
----------------------------------+-----------------------------------------
Changes (by robe):
* status: new => closed
* version: 1.5.X => trunk
* resolution: => fixed
Comment:
Seems to work well:
{{{
SELECT pprint_addy(a), a.internal
FROM pagc_normalize_address('901 Mainstreet Fl 1 Hopkins MN 55343') As
a;
}}}
Yields:
{{{
pprint_addy | internal
----------------------------------------------+-----------
901 MAINSTREET, # FLOOR 1, HOPKINS, MN 55343 | # FLOOR 1
}}}
-- this one might have been caused by my over abbreviating --
{{{
SELECT pprint_addy(a), a.streetname, a.location, a.stateabbrev
FROM pagc_normalize_address('2301 BEACH FRONT LN SW, Rochester, MN
55902') AS a;
-- but still acceptable --
pprint_addy | streetname | location |
stateabbrev
-------------------------------------------+------------+-----------+-------------
2301 BCH FRONT Ln SW, ROCHESTER, MN 55902 | BCH FRONT | ROCHESTER | MN
SELECT pprint_addy(a), a.streetname, a.location, a.stateabbrev,
a.predirabbrev, a.postdirabbrev
FROM pagc_normalize_address('2301 BEACH FRONT LN Southwest, Rochester,
MN 55902') AS a;
pprint_addy | streetname | location |
stateabbre
v | predirabbrev | postdirabbrev
-------------------------------------------+------------+-----------+-----------
--+--------------+---------------
2301 BCH FRONT Ln SW, ROCHESTER, MN 55902 | BCH FRONT | ROCHESTER | MN
| | SW
}}}
Anyrate will consider it a non-issue now.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1604#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.
More information about the postgis-tickets
mailing list