[postgis-tickets] r14900 - Closes #3552 for PostGIS 2.2.3

[Regina Obe]

Author: robe
Date: 2016-05-12 12:11:52 -0700 (Thu, 12 May 2016)
New Revision: 14900

Modified:
   branches/2.2/extras/tiger_geocoder/geocode/reverse_geocode.sql
Log:
Closes #3552 for PostGIS 2.2.3

Modified: branches/2.2/extras/tiger_geocoder/geocode/reverse_geocode.sql
===================================================================
--- branches/2.2/extras/tiger_geocoder/geocode/reverse_geocode.sql	2016-05-12 19:05:45 UTC (rev 14899)
+++ branches/2.2/extras/tiger_geocoder/geocode/reverse_geocode.sql	2016-05-12 19:11:52 UTC (rev 14900)
@@ -127,7 +127,7 @@
 		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,
 		      n.sufdirabrv, e.zip, e.side, e.fromhn, e.tohn , e.center_pt,
-		          ST_Distance_Sphere(ST_SetSRID(e.center_pt,4326),ST_SetSRID(ref_geom,4326)) As dist
+		          ST_DistanceSphere(ST_SetSRID(e.center_pt,4326),ST_SetSRID(ref_geom,4326)) As dist
 				FROM ea AS e 
 					LEFT JOIN (SELECT featnames.* FROM featnames 
 			    WHERE featnames.statefp = ' || quote_literal(var_state) ||'   ) AS n ON (n.statefp =  e.statefp AND n.tlid = e.tlid)