[postgis-tickets] [PostGIS] #3227: Support for Tiger 2015

[PostGIS]

#3227: Support for Tiger 2015
-----------------------------+---------------------------
  Reporter:  robe            |      Owner:  robe
      Type:  enhancement     |     Status:  reopened
  Priority:  high            |  Milestone:  PostGIS 2.2.0
 Component:  tiger geocoder  |    Version:  trunk
Resolution:                  |   Keywords:
-----------------------------+---------------------------
Changes (by darkblueb):

 * status:  closed => reopened
 * resolution:  fixed =>


Comment:

 I tried walking through the install, using the "no extension" version of
 the dev docs..  I got stuck.. and, I have done this before.. close #3227
 and open a docs ticket perhaps, BUT so far no one has verified this fix,
 so closing the ticket is not good practice..

 # Here are some notes on the process
 {{{
 NOTES for robe2 on TIGER 2015
 14aug15  -dbb
 ---------------------------------------

 online docs:
   http://postgis.net/docs/manual-
 dev/postgis_installation.html#loading_extras_tiger_geocoder
   following the no-extension part of the doc...

 BUG:
   actual path is
     extras/tiger_geocoder
   doc shows
     postgis_trunk$ cd postgis-2.2.0dev/extras/tiger_geocoder/tiger_2011

   -- dir structure is new, doc needs updating

 ##-------------------------------------------------

 ENHANCEMENT:

   in the user-configured script tiger_loader_2015.sql

 default location on Debian/ubuntu for $BIN is
     /usr/lib/postgresql/9.4/bin/
     /usr/lib/postgresql/9.X/bin/

 PSQL=${PGBIN}/psql
   shoud be
 PSQL=`which psql`

   similarly with create_geocode.sh

 PSQL_CMD=`which psql`
 PGCONTRIB=/usr/share/postgresql/9.4/contrib


 BUG:
   create_geocode.sh should end with a newline


 BUG
 tl_test0=# SELECT pprint_addy(normalize_address('202 East Fremont Street,
 Las Vegas, Nevada 89101')) As pretty_address;
 ERROR:  function normalize_address(unknown) does not exist
 LINE 1: SELECT pprint_addy(normalize_address('202 East Fremont Stree...
                            ^
 HINT:  No function matches the given name and argument types. You might
 need to add explicit type casts.

   at this stage in the sequence, the address_standardizer has not been
 loaded yet..
   next, referring to :
 http://postgis.net/docs/manual-
 dev/postgis_installation.html#installing_pagc_address_standardizer

   line shows
 tl_test0=# create extension address_standardizer_data_us;
 CREATE EXTENSION

   BUT, at this stage.. there is no normalize_address()  ?!?  where does it
 happen ?

 tl_test0=# \df norm*
                        List of functions
  Schema | Name | Result data type | Argument data types | Type
 --------+------+------------------+---------------------+------
 (0 rows)


   at this point in the instructions .. I have :

 * created the database, used CREATE EXTENSION
     postgis;
     address_standardizer;
     address_standardizer_data_us

 * I edited the file tiger_loader_2015.sql with local settings

 * executed  ./create_geocode.sh    which executes
      create_geocode.sql
      tiger_loader_2015.sql

   where is normalize_address() ??

 ##-------------------------------------------------
 }}}

--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3227#comment:3>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.