[postgis-tickets] [PostGIS] #2848: parse_address doesn't correctly handle Canada provinces

[PostGIS]

#2848: parse_address doesn't correctly handle Canada provinces
---------------------------------+------------------------------------------
 Reporter:  robe                 |       Owner:  woobri       
     Type:  defect               |      Status:  new          
 Priority:  medium               |   Milestone:  PostGIS 2.2.0
Component:  pagc_address_parser  |     Version:  trunk        
 Keywords:                       |  
---------------------------------+------------------------------------------
Description changed by robe:

Old description:

> {{{
> 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?

New description:

 {{{
 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

--

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2848#comment:1>
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.