Re: [HACKERS] US Census database (Tiger 2004FE) - 4.4G
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 people who promise to host it for Hackers. Command Prompt would be willing to host it. Sincerely, Joshua D. Drake I'm wondering if this is now available for consumption by the rest of us?? (ie what's the link) -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] US Census database (Tiger 2004FE) - 4.4G
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 host it for Hackers. I'm wondering if this is now available for consumption by the rest of us?? (ie what's the link) -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] US Census database (Tiger 2004FE) - 4.4G
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 pre-formatted database? I would say the preformated database is easier to manage. There are hundreds of individual zips files, in each of those files 10 or so data files. > 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. > > ---(end of broadcast)--- > TIP 6: explain analyze is your friend > ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] US Census database (Tiger 2004FE) - 4.4G
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. ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] US Census database (Tiger 2004FE) - 4.4G
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 broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org Gavin M. Roy 800 Pound Gorilla [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] US Census database (Tiger 2004FE) - 4.4G
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