Re: US Census database (Tiger 2004FE) - 4.4G - Mailing list pgsql-hackers

From Ron Mayer
Subject Re: US Census database (Tiger 2004FE) - 4.4G
Date
Msg-id 42F2615E.5080700@cheapcomplexdevices.com
Whole thread Raw
In response to US Census database (Tiger 2004FE) - 4.4G  ("Mark Woodward" <pgsql@mohawksoft.com>)
Responses Re: US Census database (Tiger 2004FE) - 4.4G  ("Mark Woodward" <pgsql@mohawksoft.com>)
List pgsql-hackers
Mark Woodward wrote:
> It is 4.4G in space in a gzip package.
> 
> I'll mail a DVD to two people who promise to host it for Hackers.

Would it be easier to release the program you did to do
this conversion?


I use this pretty short (274 line) C program:   http://www.forensiclogic.com/tmp/tgr2sql.c
to convert the raw tiger files
from http://www.census.gov/geo/www/tiger/index.html
into SQL statements that can be loaded by postgresql.

The #define SQL line controls if it makes data
with INSERT statements or for COPY statements.


pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: openbsd, plpython, missing threading symbols
Next
From: "Rocco Altier"
Date:
Subject: Cygwin - make check broken