[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