[postgis-tickets] [PostGIS] #886: Fix normalizing of multi street number range addresses and fractional street numbers

[PostGIS]

#886: Fix normalizing of multi street number range addresses and fractional
street numbers
-----------------------------+---------------------------
  Reporter:  robe            |      Owner:  robe
      Type:  defect          |     Status:  closed
  Priority:  medium          |  Milestone:  PostGIS 2.4.0
 Component:  tiger geocoder  |    Version:  trunk
Resolution:  fixed           |   Keywords:
-----------------------------+---------------------------
Changes (by robe):

 * status:  new => closed
 * resolution:   => fixed
 * milestone:  PostGIS Fund Me => PostGIS 2.4.0


Comment:

 This actually got fixed in 2.4.0 well close enough because Leo kept on
 nagging me about his street numbers being mangled so

 So new output in normalize_address, and pagc_address outputs a new column
 address_alphanumeric which preserves the original street number.  I forget
 when I change the streetnumber to just take the first part.  I think that
 was before 2.4


 {{{
 SELECT j.key, j.value FROM
 json_each_text(to_json(normalize_address('123-125 Washington Avenue,
 Boston MA 02130'))) AS j;

          key          |   value
 ----------------------+------------
  address              | 123
  predirabbrev         | NULL
  streetname           | Washington
  streettypeabbrev     | Ave
  postdirabbrev        | NULL
  internal             | NULL
  location             | Boston
  stateabbrev          | MA
  zip                  | 02130
  parsed               | true
  zip4                 | NULL
  address_alphanumeric | 123-125
 (12 rows)

 SELECT j.key, j.value FROM
 json_each_text(to_json(pagc_normalize_address('123-125 Washington Avenue,
 Boston MA 02130'))) AS j;

          key          |   value
 ----------------------+------------
  address              | 123
  predirabbrev         | NULL
  streetname           | WASHINGTON
  streettypeabbrev     | AVE
  postdirabbrev        | NULL
  internal             | NULL
  location             | BOSTON
  stateabbrev          | MA
  zip                  | 02130
  parsed               | true
  zip4                 | NULL
  address_alphanumeric | 123 125
 (12 rows)
 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/886#comment:6>
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.