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

PostGIS trac at osgeo.org
Fri Jul 18 22:47:48 PDT 2014


#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:                       |  
---------------------------------+------------------------------------------
 {{{
 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?

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