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" _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
