[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] New install - not returning data
From:       Barry McCall <barry.mccall+postgis () gmail ! com>
Date:       2014-09-22 13:04:46
Message-ID: CA+2dd5toq-Gt2aq2_ohqu=ZG6fxEuJS+3PvPqtCJ44=F7yxjaA () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


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

[Attachment #5 (text/html)]

<div dir="ltr"><div style="font-family:arial,sans-serif;font-size:13px">Was hoping to \
reach out for some help. I&#39;ve performed a fresh install (details below) and \
I&#39;ve populated with tiger data for the state of PA utilizing \
loader_generate_script(). Upon completion I also executed install_missing_indexes().  \
</div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div \
style="font-family:arial,sans-serif;font-size:13px">Attempting a test with the \
following script returns NULL<br><div><br></div><div><div>SELECT g.rating, \
ST_X(g.geomout) As lon, ST_Y(g.geomout) As lat,  </div><div>(addy).address As stno, \
(addy).streetname As street,  </div><div>(addy).streettypeabbrev As styp, \
(addy).location As city, (addy).stateabbrev As st,(addy).zip  </div><div>FROM \
geocode(&#39;535 Smithfield St Pittsburgh, PA 15222&#39;) As \
g;</div></div><div><br></div><div>Where do I troubleshoot from here?  </div><div>Any \
help is greatly appreciated.  \
</div><div><br></div><div><br></div><div><br></div><div>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=&quot;2.1.3 r12547&quot; GEOS=&quot;3.4.2-CAPI-1.8.2 r3921&quot; \
PROJ=&quot;Rel. 4.8.0, 6 March 2012&quot; GDAL=&quot;GDAL 1.9.2, released \
2012/10/08&quot; LIBXML=&quot;2.7.6&quot; LIBJSON=&quot;UNKNOWN&quot; TOPOLOGY \
RASTER</div></div></div>



_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]