[postgis-devel] [PostGIS] #908: linux version of tiger2010 geocoder does not work

PostGIS trac at osgeo.org
Thu Apr 14 01:39:42 PDT 2011

#908: linux version of tiger2010 geocoder  does not work
 Reporter:  donh            |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  1.5.X        
 Keywords:                  |  
 ctrl-m's in the file and/or generated by psql would crash psql.  Missing
 command line parameters would also crash it.
 I would generate my load_tiger script by running psql as:
 \o  load_tiger
 \i states
 I would them remove the control-m's from load_tiger.
 tr "\r" "\n" < load_tiger > load_tiger2
 I then would edit load_tiger2 putting a #!bin/bash at the top and removing
 the line numbers at the end.
 I had already downloaded the tiger database files so I would replace wget
 with #wget in the file.
 shp2pgsql does not really convert latin1 to utf-8 all the time so I added
 a "| iconv -f latin1 -t UTF8 | $PGBIN/psql" after the shp2pgsql command.
 That did away with the aborted transactions from postgresql.

Ticket URL: <http://trac.osgeo.org/postgis/ticket/908>
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.

More information about the postgis-devel mailing list