[postgis-users] reverse_geocode not returning predirabbrev

[Paragon Corporation]

Barry,

Sorry for the late reply.  Completely missed this email.  This issue was
fixed in 2.1.4 (as detailed here http://postgis.net/2014/09/10/postgis-2.1.4
)
so just upgrade your postgis_tiger_geocoder to the latest.


If that is not possible you can just replace the reverse_geocoder function
you have with the one in this ticket.  Make sure to set the path to tiger
though otherwise will get installed in your default schema.

http://trac.osgeo.org/postgis/ticket/2927

Hope that helps,
Regina
http://www.postgis.us
http://postgis.net





-- ORIGINAL MESSAGE --
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"