[postgis-users] reverse_geocode not returning predirabbrev

[Barry McCall]

I have an existing daily utilized PostGIS install on psql 9.2. It was
functioning fine up until the latest change. This change was the
installation of the tz_world shapefile from http://efele.net/maps/tz/world/
to use lon/lat for getting timezone data.

Since the installation reverse_geocode(); is still functional; however, I
never get data in predirabbrev. Going back through about 7.9M records that
have been geocoded, not one has N, W, S or any data that (I would assume)
would come from direction_lookup.

I've attempted to re run indexes with no luck. I installed the tz shapefile
with: shp2pgsql -S -s 4326 -I tz_world | psql -U postgres geocoder


Any help would be greatly appreciated!

Thanks!

------------------------------------------------------------------------------------------------------
Linux ip-172-16-x-x 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC
2013 x86_64 x86_64 x86_64 GNU/Linux
---------------------------------------------------
PostgreSQL "9.2.9"
---------------------------------------------------
SELECT extname, extversion
FROM pg_extension;
"plpgsql";"1.0"
"postgis";"2.1.3"
"postgis_topology";"2.1.3"
"fuzzystrmatch";"1.0"
"postgis_tiger_geocoder";"2.1.3"
"plsh";"2"
---------------------------------------------------
"POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6
March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.6"
LIBJSON="UNKNOWN" TOPOLOGY RASTER"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141209/6c707469/attachment.html>