[postgis-tickets] r15137 - tiger normalize, pagc_normalize integer out of range

[Regina Obe]

Author: robe
Date: 2016-09-24 20:54:32 -0700 (Sat, 24 Sep 2016)
New Revision: 15137

Modified:
   branches/2.2/NEWS
   branches/2.2/extras/tiger_geocoder/normalize/normalize_address.sql
   branches/2.2/extras/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql
Log:
tiger normalize, pagc_normalize integer out of range
closes #3641 for PostGIS 2.2.3

Modified: branches/2.2/NEWS
===================================================================
--- branches/2.2/NEWS	2016-09-25 03:41:38 UTC (rev 15136)
+++ branches/2.2/NEWS	2016-09-25 03:54:32 UTC (rev 15137)
@@ -30,6 +30,7 @@
            (Christian Quest / Dan Baston)
   - #3501 use ST_Union instead of ST_Collect to compute 
           raster max extent constraint
+  - #3641 tiger normalize, pagc_normalize integer out of range
   - Numerous documentation corrections from ruvyn
 
 

Modified: branches/2.2/extras/tiger_geocoder/normalize/normalize_address.sql
===================================================================
--- branches/2.2/extras/tiger_geocoder/normalize/normalize_address.sql	2016-09-25 03:41:38 UTC (rev 15136)
+++ branches/2.2/extras/tiger_geocoder/normalize/normalize_address.sql	2016-09-25 03:54:32 UTC (rev 15137)
@@ -697,7 +697,7 @@
   END IF;
 
  -- For address number only put numbers and stop if reach a non-number e.g. 123-456 will return 123
-  result.address := to_number(substring(addressString, '[0-9]+'), '99999999999');
+  result.address := to_number(substring(addressString, '[0-9]+'), '99999999');
    --get rid of extraneous spaces before we return
   result.zip := trim(zipString);
   result.streetName := trim(result.streetName);

Modified: branches/2.2/extras/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql
===================================================================
--- branches/2.2/extras/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql	2016-09-25 03:41:38 UTC (rev 15136)
+++ branches/2.2/extras/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql	2016-09-25 03:54:32 UTC (rev 15137)
@@ -31,7 +31,7 @@
    COALESCE(', ' || var_parse_rec.city,'') || COALESCE(', ' || var_parse_rec.state, '') || COALESCE(' ' || var_parse_rec.zip,'')  ) ;
  
  -- For address number only put numbers and stop if reach a non-number e.g. 123-456 will return 123
-  result.address := to_number(substring(var_rec.house_num, '[0-9]+'), '99999999999');
+  result.address := to_number(substring(var_rec.house_num, '[0-9]+'), '99999999');
    --get rid of extraneous spaces before we return
   result.zip := COALESCE(var_rec.postcode,result.zip);
   result.streetName := trim(var_rec.name);