[postgis-tickets] r14899 - references #3552 get rid of depecated calls for PostGIS 2.3

[Regina Obe]

Author: robe
Date: 2016-05-12 12:05:45 -0700 (Thu, 12 May 2016)
New Revision: 14899

Modified:
   trunk/extras/tiger_geocoder/geocode/reverse_geocode.sql
Log:
references #3552 get rid of depecated calls for PostGIS 2.3

Modified: trunk/extras/tiger_geocoder/geocode/reverse_geocode.sql
===================================================================
--- trunk/extras/tiger_geocoder/geocode/reverse_geocode.sql	2016-05-12 18:58:28 UTC (rev 14898)
+++ trunk/extras/tiger_geocoder/geocode/reverse_geocode.sql	2016-05-12 19:05:45 UTC (rev 14899)
@@ -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)