From 7066b672e337e990f27fecd9daa5c47794a6bf48 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Tue, 7 Oct 2014 14:11:15 +0000 Subject: [PATCH] #2958 reverse_geocode erroring ERROR: invalid input syntax for type numeric: " " (revised patch to not return 0 for non-numbered roads) git-svn-id: http://svn.osgeo.org/postgis/trunk@13041 b70326c6-7e19-0410-871a-916f4a2858ee --- extras/tiger_geocoder/tiger_2011/geocode/reverse_geocode.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/extras/tiger_geocoder/tiger_2011/geocode/reverse_geocode.sql b/extras/tiger_geocoder/tiger_2011/geocode/reverse_geocode.sql index 158a0a4c4..50c7c5ab5 100644 --- a/extras/tiger_geocoder/tiger_2011/geocode/reverse_geocode.sql +++ b/extras/tiger_geocoder/tiger_2011/geocode/reverse_geocode.sql @@ -124,7 +124,7 @@ BEGIN ) SELECT * FROM (SELECT DISTINCT ON(tlid,side) foo.fullname, foo.predirabrv, foo.streetname, foo.streettypeabbrev, foo.zip, foo.center_pt, - side, to_number(CASE WHEN trim(fromhn) ~ ''^[0-9]+$'' THEN fromhn ELSE ''0'' END,''99999999'') As fromhn, to_number(CASE WHEN trim(tohn) ~ ''^[0-9]+$'' THEN tohn ELSE ''0'' END,''99999999'') As tohn, + side, to_number(CASE WHEN trim(fromhn) ~ ''^[0-9]+$'' THEN fromhn ELSE NULL END,''99999999'') As fromhn, to_number(CASE WHEN trim(tohn) ~ ''^[0-9]+$'' THEN tohn ELSE NULL END,''99999999'') As tohn, ST_GeometryN(ST_Multi(line),1) As line, dist FROM (SELECT e.tlid, e.the_geom As line, n.fullname, COALESCE(n.prequalabr || '' '','''') || n.name AS streetname, n.predirabrv, COALESCE(suftypabrv, pretypabrv) As streettypeabbrev, -- 2.50.1