<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.9600.16428"></HEAD>
<BODY
style="WORD-WRAP: break-word; FONT-SIZE: 14px; FONT-FAMILY: Calibri, sans-serif; COLOR: rgb(0,0,0); -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV dir=ltr align=left><SPAN class=221482420-20112013><FONT
size=4>Greg,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=221482420-20112013><FONT size=4>Did you run
the nation script routine?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=221482420-20112013><FONT size=4><A
href="http://postgis.net/docs/manual-dev/Loader_Generate_Nation_Script.html">http://postgis.net/docs/manual-dev/Loader_Generate_Nation_Script.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=221482420-20112013><FONT
size=4></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=221482420-20112013><FONT size=4>That's the
first step needed. Should actually be done before you load the other
tables.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=221482420-20112013><FONT
size=4></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=221482420-20112013><FONT size=4>Hope that
helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=221482420-20112013><FONT
size=4>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=221482420-20112013><FONT size=4><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=221482420-20112013><FONT size=4><A
href="http://postgis.net">http://postgis.net</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=221482420-20112013><FONT
size=4></FONT></SPAN> </DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Greg
Nawrocki<BR><B>Sent:</B> Wednesday, November 20, 2013 12:10 PM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Subject:</B> [postgis-users] Postgis 2.2.0
With TIGER data<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><BR></DIV>
<DIV>Sorry about the noob question, but I am stuck. I am trying to get to a
point where I can geocode (get latitude and longitude) from an address.</DIV>
<DIV><BR></DIV>
<DIV>I build and install Postgres 9.3 and Postgis 2.2.0</DIV>
<DIV><BR></DIV>
<DIV>I create a database named "geocode" and create the proper extensions,
grants, search paths:</DIV>
<DIV><BR></DIV>
<DIV>
<DIV>/usr/local/pgsql/bin/psql -d geocode -c "CREATE EXTENSION postgis"</DIV>
<DIV>/usr/local/pgsql/bin/psql -d geocode -c "CREATE EXTENSION
postgis_topology"</DIV>
<DIV>/usr/local/pgsql/bin/psql -d geocode -c "CREATE EXTENSION
fuzzystrmatch;"</DIV>
<DIV>/usr/local/pgsql/bin/psql -d geocode -c "CREATE EXTENSION
postgis_tiger_geocoder;"</DIV>
<DIV>/usr/local/pgsql/bin/psql -d geocode -c "CREATE EXTENSION
address_standardizer;"</DIV>
<DIV>/usr/local/pgsql/bin/psql geocode -f
/usr/local/pgsql/share/contrib/postgis-2.2/legacy.sql</DIV>
<DIV><BR></DIV>
<DIV>/usr/local/pgsql/bin/psql -d geocode -c "GRANT ALL ON geometry_columns TO
PUBLIC;"</DIV>
<DIV>/usr/local/pgsql/bin/psql -d geocode -c "GRANT ALL ON geography_columns TO
PUBLIC;"</DIV>
<DIV>/usr/local/pgsql/bin/psql -d geocode -c "GRANT ALL ON spatial_ref_sys TO
PUBLIC;"</DIV>
<DIV><BR></DIV>
<DIV>/usr/local/pgsql/bin/psql -d geocode -c "ALTER DATABASE geocode SET
search_path=public, tiger;"</DIV></DIV>
<DIV><BR></DIV>
<DIV>Here's some information on the resulting environment:</DIV>
<DIV><BR></DIV>
<DIV>=========================================================================================</DIV>
<DIV>"SELECT version();"</DIV>
<DIV>
<DIV>
version
</DIV>
<DIV>--------------------------------------------------------------------------------------------------------------</DIV>
<DIV> PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
4.7.2 20120921 (Red Hat 4.7.2-2), 64-bit</DIV>
<DIV>(1 row)</DIV>
<DIV><BR></DIV>
<DIV>"SELECT postgis_full_version();"</DIV>
<DIV>
postgis_full_version
</DIV>
<DIV>---------------------------------------------------------------------------------------------------------------------------------------------------------</DIV>
<DIV> POSTGIS="2.2.0dev r12128" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6
March 2012" GDAL="GDAL 1.9.1, released 2012/05/15" LIBXML="2.7.8" TOPOLOGY
RASTER</DIV>
<DIV>(1 row)</DIV>
<DIV><BR></DIV>
<DIV>"SELECT name, default_version,installed_version FROM
pg_available_extensions WHERE name LIKE 'postgis%';"</DIV>
<DIV> name |
default_version | installed_version </DIV>
<DIV>------------------------+-----------------+-------------------</DIV>
<DIV> postgis_tiger_geocoder | 2.2.0dev |
2.2.0dev</DIV>
<DIV> postgis |
2.2.0dev | 2.2.0dev</DIV>
<DIV> postgis_topology | 2.2.0dev
| 2.2.0dev</DIV>
<DIV>(3 rows)</DIV></DIV>
<DIV>==========================================================================================</DIV>
<DIV><BR></DIV>
<DIV>The pprint_addy() and normalize_address() functions work as expected
in the examples I've seen.</DIV>
<DIV><BR></DIV>
<DIV>I generate, modify and run a tiger load script to retrieve TIGER data for
my state:</DIV>
<DIV>/usr/local/pgsql/bin/psql -d geocode -c "SELECT
loader_generate_script(ARRAY['IL'], 'sh');" -A -o ILdata.sh</DIV>
<DIV><BR></DIV>
<DIV>Everything appears to load normally. The only anomaly I see is the
following message when installing the various featnames.dbf files:</DIV>
<DIV>XXXXXXX_featnames.dbf: shape (.shp) or index files (.shx) can not be
opened, will just import attribute data.</DIV>
<DIV>However, from what I can see those files contain no shape information so I
do not think this is an error.</DIV>
<DIV><BR></DIV>
<DIV>I run the install_missing_indexes() function which appears to
work.</DIV>
<DIV><BR></DIV>
<DIV>However, when I attempt to geocode I get an immediate empty return.</DIV>
<DIV><BR></DIV>
<DIV>
<DIV>/usr/local/pgsql/bin/psql -d geocode -c "SELECT g.rating, ST_X(g.geomout)
As lon, ST_Y(g.geomout) As lat FROM geocode('810 W Main St, West Dundee, IL
60118') As g;"</DIV>
<DIV> rating | lon | lat </DIV>
<DIV>--------+-----+-----</DIV>
<DIV>(0 rows)</DIV></DIV>
<DIV><BR></DIV>
<DIV>At this point, I'm lost… Any help greatly appreciated.</DIV>
<DIV><BR></DIV>
<DIV>-- Greg</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV></BODY></HTML>