<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; "><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>