Opened 10 years ago

Closed 7 years ago

#2848 closed defect (wontfix)

parse_address doesn't correctly handle Canada provinces

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 2.4.0
Component: pagc_address_parser Version: master
Keywords: Cc:

Description (last modified by robe)

SELECT (each(hstore(p))).* FROM parse_address('1207 Douglas Street, Suite 202, Victoria, BC, Canada V8W2E7') As p;

-- I'm using hstore cause there are too many fields to output horizontally. Outputs:

   key    |                    value
----------+----------------------------------------------
 num      | 1207
 zip      | V8W2E7
 city     | Canada
 state    |
 street   | Douglas Street, Suite 202, Victoria, BC
 country  | CA
 street2  |
 zipplus  |
 address1 | 1207 Douglas Street, Suite 202, Victoria, BC

Should BC be in State and Victoria the City

Change History (4)

comment:1 by robe, 10 years ago

Description: modified (diff)

comment:2 by robe, 9 years ago

Milestone: PostGIS 2.2.0PostGIS 2.3.0
Owner: changed from woobri to robe

I'll try to dsee if I can fix in 2.2, but may not be able to.

comment:3 by robe, 8 years ago

Milestone: PostGIS 2.3.0PostGIS 2.4.0

comment:4 by robe, 7 years ago

Resolution: wontfix
Status: newclosed
Note: See TracTickets for help on using tickets.