Re : US Highschool database in postgres

From: Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re : US Highschool database in postgres
Date: 2007-03-05 13:47:37
Message-ID: 625341.94550.qm@web34407.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You can get some lists from here:
http://www.iso.org/iso/en/prods-services/iso3166ma/index.html
and there
http://www.unece.org/cefact/locode/service/main.htm

No high schools though, but countries, currencies, cities, states, ...
Not sure whether this will help you ... but you can have a look.

If you don't have access, you can use OpenOffice to open them and you can use a PG connection to copy the data from one system to the other !
Quite impressive.


Have fun,
L(at)u
The Computing Froggy

----- Message d'origine ----
De : "mobiledreamers(at)gmail(dot)com" <mobiledreamers(at)gmail(dot)com>
À : Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>; pgsql-general(at)postgresql(dot)org
Envoyé le : Vendredi, 2 Mars 2007, 2h04mn 36s
Objet : Re: [GENERAL] US Highschool database in postgres

http://en.wikipedia.org/wiki/Category:Lists_of_schools_in_the_United_States
Has one parsed the list of high schools in the USA and stored in postgres

or is there an open list of backup files that people can share so they can share their useful backups of useful dbs
like
list of high schools
list of cities
list of zipcodes
etc
thanks
mArk

On 3/1/07, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hmmm.

Have you Googled? "list of high schools in california" brought up
some very useful sites. I would not be surprised if there were such

sites for all the other states.

You'll need some skill with Perl or Python to efficiently grab all
the data, though.

On 03/01/07 13:39, mobiledreamers(at)gmail(dot)com
wrote:
> List of highschools by city state and county
> Mark
>
> On 3/1/07, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> wrote:
>>
> On 02/27/07 01:04, mobil wrote:

>> Is there a downlaodable high school database in postgresql
>
> What exactly do you mean by "high school database"?
>
>
>>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG
v1.4.6 (GNU/Linux)

iD8DBQFF5zXpS9HxQb37XmcRAsUEAKDpswN/4IHBF4QFDDwCmn2kd6/K7gCfZlH2
PtSrXdRordiqRPkYSgzgSrQ=
=zczG
-----END PGP SIGNATURE-----



___________________________________________________________________________
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses
http://fr.answers.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Downs 2007-03-05 13:51:23 Re: usage for 'with recursive'?
Previous Message Heikki Linnakangas 2007-03-05 13:20:49 Re: PostgreSQL 8.2.3 VACUUM Timings/Performance