[postgis-users] New install - not returning data

Barry McCall barry.mccall+postgis at gmail.com
Mon Sep 22 06:04:46 PDT 2014


Was hoping to reach out for some help. I've performed a fresh install
(details below) and I've populated with tiger data for the state of PA
utilizing loader_generate_script(). Upon completion I also executed
install_missing_indexes().

Attempting a test with the following script returns NULL

SELECT g.rating, ST_X(g.geomout) As lon, ST_Y(g.geomout) As lat,
(addy).address As stno, (addy).streetname As street,
(addy).streettypeabbrev As styp, (addy).location As city,
(addy).stateabbrev As st,(addy).zip
FROM geocode('535 Smithfield St Pittsburgh, PA 15222') As g;

Where do I troubleshoot from here?
Any help is greatly appreciated.



PostgreSQL 9.2.9 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-4), 64-bit 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/20140922/ff6d9e62/attachment.html>


More information about the postgis-users mailing list