Re: [HACKERS] US Census database (Tiger 2004FE) - 4.4G

2005-09-16 Thread Joshua D. Drake
Darcy Buskermolen wrote: On Thursday 04 August 2005 09:37, Gavin M. Roy wrote: You can send it to me, and ehpg will host it. I'll send you a private email with my info. Gavin On Aug 4, 2005, at 8:26 AM, Mark Woodward wrote: It is 4.4G in space in a gzip package. I'll mail a DVD to two

Re: [HACKERS] US Census database (Tiger 2004FE) - 4.4G

2005-09-15 Thread Darcy Buskermolen
On Thursday 04 August 2005 09:37, Gavin M. Roy wrote: You can send it to me, and ehpg will host it. I'll send you a private email with my info. Gavin On Aug 4, 2005, at 8:26 AM, Mark Woodward wrote: It is 4.4G in space in a gzip package. I'll mail a DVD to two people who promise to

Re: [HACKERS] US Census database (Tiger 2004FE)

2005-08-04 Thread Mark Woodward
Wow! a lot of people seem to want it! I am dumping out with pg_dump right now, it may take a few hours. It is in PostgreSQL 8.0.3 Does anyone have access to a high bandwidth server? I could mail it on a DVD to someone who would host it. David Fetter wrote: On Wed, Aug 03, 2005 at 05:00:16PM

Re: [HACKERS] US Census database (Tiger 2004FE)

2005-08-04 Thread Stephen Frost
* Mark Woodward ([EMAIL PROTECTED]) wrote: I just finished converting and loading the US census data into PostgreSQL would anyone be interested in it for testing purposes? It's a *LOT* of data (about 40+ Gig in PostgreSQL) How big dumped compressed? I may be able to host it depending on

Re: [HACKERS] US Census database (Tiger 2004FE)

2005-08-04 Thread Mark Woodward
* Mark Woodward ([EMAIL PROTECTED]) wrote: I just finished converting and loading the US census data into PostgreSQL would anyone be interested in it for testing purposes? It's a *LOT* of data (about 40+ Gig in PostgreSQL) How big dumped compressed? I may be able to host it depending on

Re: [HACKERS] US Census database (Tiger 2004FE)

2005-08-04 Thread Stephen Frost
* Mark Woodward ([EMAIL PROTECTED]) wrote: How big dumped compressed? I may be able to host it depending on how big it ends up being... It's been running for about an hour now, and it is up to 3.3G. Not too bad. I had 2003 (iirc) loaded into 7.4 at one point. pg_dump tiger | gzip

Re: [HACKERS] US Census database (Tiger 2004FE)

2005-08-04 Thread Tino Wildenhain
Am Donnerstag, den 04.08.2005, 08:40 -0400 schrieb Mark Woodward: * Mark Woodward ([EMAIL PROTECTED]) wrote: I just finished converting and loading the US census data into PostgreSQL would anyone be interested in it for testing purposes? It's a *LOT* of data (about 40+ Gig in

Re: [HACKERS] US Census database (Tiger 2004FE)

2005-08-04 Thread Mark Woodward
* Mark Woodward ([EMAIL PROTECTED]) wrote: How big dumped compressed? I may be able to host it depending on how big it ends up being... It's been running for about an hour now, and it is up to 3.3G. Not too bad. I had 2003 (iirc) loaded into 7.4 at one point. Cool. pg_dump tiger |

Re: [HACKERS] US Census database (Tiger 2004FE)

2005-08-04 Thread Mark Woodward
It's been running for about an hour now, and it is up to 3.3G. pg_dump tiger | gzip tiger.pgz | bzip2 tiger.sql.bz2 :) I find bzip2 FAR SLOWER than the gain in compression. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] US Census database (Tiger 2004FE)

2005-08-04 Thread Christopher Kings-Lynne
It's been running for about an hour now, and it is up to 3.3G. pg_dump tiger | gzip tiger.pgz | bzip2 tiger.sql.bz2 :) Chris ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[HACKERS] US Census database (Tiger 2004FE) - 4.4G

2005-08-04 Thread Mark Woodward
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. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] US Census database (Tiger 2004FE) - 4.4G

2005-08-04 Thread Gavin M. Roy
You can send it to me, and ehpg will host it. I'll send you a private email with my info. Gavin On Aug 4, 2005, at 8:26 AM, 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. ---(end of

Re: [HACKERS] US Census database (Tiger 2004FE) - 4.4G

2005-08-04 Thread Ron Mayer
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

Re: [HACKERS] US Census database (Tiger 2004FE) - 4.4G

2005-08-04 Thread Mark Woodward
I thought bout it, but it isn't the best program around, but it does work. My program also reformats numbers, i.e. long/lat become properly decimal-ed numerics, zips become integers, etc. The question is... Do you download the raw data and convert it into a database, or do you download the

[HACKERS] US Census database (Tiger 2004FE)

2005-08-03 Thread Mark Woodward
I just finished converting and loading the US census data into PostgreSQL would anyone be interested in it for testing purposes? It's a *LOT* of data (about 40+ Gig in PostgreSQL) ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] US Census database (Tiger 2004FE)

2005-08-03 Thread David Fetter
On Wed, Aug 03, 2005 at 05:00:16PM -0400, Mark Woodward wrote: I just finished converting and loading the US census data into PostgreSQL would anyone be interested in it for testing purposes? It's a *LOT* of data (about 40+ Gig in PostgreSQL) Sure. Got a torrent? Cheers, D -- David Fetter

Re: [HACKERS] US Census database (Tiger 2004FE)

2005-08-03 Thread Andrew Dunstan
David Fetter wrote: On Wed, Aug 03, 2005 at 05:00:16PM -0400, Mark Woodward wrote: I just finished converting and loading the US census data into PostgreSQL would anyone be interested in it for testing purposes? It's a *LOT* of data (about 40+ Gig in PostgreSQL) Sure. Got a