From 2d150eaaadfd23551e5ee66ea9abe41e2aa786d4 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sat, 28 May 2011 23:32:41 +0000 Subject: [PATCH] Get rid of deprecated call to centroid git-svn-id: http://svn.osgeo.org/postgis/trunk@7283 b70326c6-7e19-0410-871a-916f4a2858ee --- extras/tiger_geocoder/tiger_2010/geocode/geocode_location.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/extras/tiger_geocoder/tiger_2010/geocode/geocode_location.sql b/extras/tiger_geocoder/tiger_2010/geocode/geocode_location.sql index d6ae4a669..8650174ba 100644 --- a/extras/tiger_geocoder/tiger_2010/geocode/geocode_location.sql +++ b/extras/tiger_geocoder/tiger_2010/geocode/geocode_location.sql @@ -18,7 +18,7 @@ BEGIN SELECT coalesce(zip.city)::varchar as place, zip.zip as zip, - centroid(zcta500.the_geom) as address_geom, + ST_Centroid(zcta500.the_geom) as address_geom, stusps as state, 100::integer + coalesce(levenshtein_ignore_case(coalesce(zip.city), parsed.location),0) as in_rating FROM @@ -53,7 +53,7 @@ BEGIN stmt := 'SELECT ' || ' pl.name as place, ' || ' state.stusps as stateAbbrev, ' - || ' centroid(pl.the_geom) as address_geom, ' + || ' ST_Centroid(pl.the_geom) as address_geom, ' || ' 100::integer + levenshtein_ignore_case(coalesce(pl.name), ' || quote_literal(coalesce(parsed.location,'')) || ') as in_rating ' || ' FROM place pl ' || ' JOIN state USING (statefp)' -- 2.50.1