[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:
-----------------------------+---------------------------

Comment (by darkblueb):

 hmm problems .. here is '''SETUP'''

 {{{
 user at debian8:/home/shared/srcs_db8/postgis_trunk$ svn up
 Updating '.':
 G    extras/tiger_geocoder/tiger_loader_2015.sql
  ...
 Updated to revision 13913.
  ...
 user at debian8:/home/shared/srcs_db8/postgis_trunk$ make distclean
  ...
 CFLAGS='-g -O0' CXXFLAGS='-g -O0' ./configure --enable-profile --enable-
 debug
  ...
 make && sudo make install
  ...
 shell$ createdb tl_test_ext ; psql tl_test_ext
 tl_test_ext=# create extension postgis;
 tl_test_ext=# create extension address_standardizer;
 tl_test_ext=# create extension address_standardizer_data_us ;
 tl_test_ext=# create extension fuzzystrmatch ;
 tl_test_ext=# create extension postgis_tiger_geocoder;

 tl_test_ext=# SELECT na.address, na.streetname,na.streettypeabbrev, na.zip
 tl_test_ext-# FROM normalize_address('1 Devonshire Place, Boston, MA
 02109') AS na;
  address | streetname | streettypeabbrev |  zip
 ---------+------------+------------------+-------
        1 | Devonshire | Pl               | 02109
 (1 row)
 tl_test_ext=# SELECT Loader_Generate_Nation_Script('sh');
 ...
 }}}

 here is '''RESULT'''
 execute loader script line by line.. gets a few lines down then stuck...

 {{{
 user at debian8:/gisdata/temp$ ls
 tl_2015_us_state.cpg  tl_2015_us_state.prj
 tl_2015_us_state.shp.ea.iso.xml  tl_2015_us_state.shp.xml
 tl_2015_us_state.dbf  tl_2015_us_state.shp  tl_2015_us_state.shp.iso.xml
 tl_2015_us_state.shx
 user at debian8:/gisdata/temp$ ${PSQL} -c "CREATE TABLE
 tiger_data.state_all(CONSTRAINT pk_state_all PRIMARY KEY
 (statefp),CONSTRAINT uidx_state_all_stusps  UNIQUE (stusps), CONSTRAINT
 uidx_state_all_gid UNIQUE (gid) ) INHERITS(tiger.state); "
 CREATE TABLE
 user at debian8:/gisdata/temp$ ${SHP2PGSQL} -D -c -s 4269 -g the_geom   -W
 "latin1" tl_2015_us_state.dbf tiger_staging.state | ${PSQL}
 Shapefile type: Polygon
 Postgis type: MULTIPOLYGON[2]
 SET
 SET
 BEGIN
 CREATE TABLE
 ALTER TABLE
                         addgeometrycolumn
 ------------------------------------------------------------------
  tiger_staging.state.the_geom SRID:4269 TYPE:MULTIPOLYGON DIMS:2
 (1 row)

 ERROR:  value too long for type character varying(2)
 CONTEXT:  COPY state, line 1, column region: "    [shp2pgsql-
 core.c:FindPolygons:567] FindPolygons[0]: allocated space for 1 rings"
 ROLLBACK
 ERROR:  relation "tiger_staging.state" does not exist

 }}}

--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3227#comment:13>
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.