Forum OpenACS Q&A: ref-us-zipcodes missing zip codes?

Collapse
1: ref-us-zipcodes missing zip codes?
Posted by Bruno Mattarollo on 07/29/04 09:02 AM

Hello,

I was having a look at the ref-us-zipcodes package and I can't seem to find where the actual zip codes are located. In the ref-us-zipcodes/sql/postgresql/ref-us-zipcodes-create.sql file there is a reference to: 

begin;
\i ../common/ref-us-zipcodes-data.sql
but I can't find that file. Looking around I came accross this posting and this bug but ... how to proceed from now?

Any suggestion is welcome. Thanks.

Collapse
2: Re: ref-us-zipcodes missing zip codes? (response to 1)
Posted by Torben Brosten on 07/29/04 09:27 AM
Hi Bruno,

they are (supposed to be) located in us_zipcodes.zipcode

Collapse
3: Re: ref-us-zipcodes missing zip codes? (response to 1)
Posted by Torben Brosten on 07/29/04 09:32 AM
Sorry, misread your post (late and too hot here).

I see your point... the table is there, but its empty.

Collapse
4: Re: ref-us-zipcodes missing zip codes? (response to 1)
Posted by Torben Brosten on 07/29/04 10:17 AM
Sheesh.. I need some sleep (just cross posted on the other thread by mistake).

Looks like Don moved it over to a "bulk loading", not sure where that is, but you can pick up the old version from here:

https://openacs.org/viewcvs/openacs-4/packages/ref-us-zipcodes/sql/common/Attic/

cheers,

Torben

Collapse
5: Re: ref-us-zipcodes missing zip codes? (response to 4)
Posted by Bruno Mattarollo on 07/29/04 10:27 AM
Cool ... will do, thanks a lot. Where are you that is so late? :)
Collapse
6: Re: ref-us-zipcodes missing zip codes? (response to 1)
Posted by Torben Brosten on 07/29/04 11:01 AM
pdx oregon, A paradise, really, but I don't tolerate temperatures above 75F/23C very well.
Collapse
7: Re: ref-us-zipcodes missing zip codes? (response to 6)
Posted by Bruno Mattarollo on 07/29/04 04:31 PM
Now it's a bit late in Sydney, Australia but it's a great winter with temperatures rounding 21ºC (sunshine) during the day!

Sorry, I know this is off-topic ;)