Ticket #1108 (new defect)
normalize_address: Internal address prefix sometimes get caught in post dir
| Reported by: | robe | Owned by: | robe |
|---|---|---|---|
| Priority: | high | Milestone: | PostGIS Future |
| Component: | tiger geocoder | Version: | trunk |
| Keywords: | Cc: |
Description (last modified by robe) (diff)
-- this works
SELECT * FROM normalize_address('529 Main Street, Apt 201, Boston, MA 02129');
address | predirabbrev | streetname | streettypeabbrev | postdirabbrev | internal | location | stateabbrev | zip | parsed
---------+--------------+------------+------------------+---------------+----------+----------+-------------+-------+--------
529 | | Main | St | | Apt 201 | Boston | MA | 02129 | t
But this has Suite bleed into postdirabbrev because it starts with S
SELECT * FROM normalize_address('529 Main Street, Suite 201, Boston, MA 02129');
address | predirabbrev | streetname | streettypeabbrev | postdirabbrev | internal | location | stateabbrev | zip | parsed
---------+--------------+------------+------------------+---------------+-----------+----------+-------------+-------+--------
529 | | Main | St | S | Suite 201 | Boston | MA | 02129 | t
