Opened 10 years ago

Last modified 7 years ago

#2848 closed defect

parse_address doesn't correctly handle Canada provinces — at Version 1

Reported by: robe Owned by: woobri
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 (1)

comment:1 by robe, 10 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.