Re : [GENERAL] US Highschool database in postgres
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, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : [EMAIL PROTECTED] [EMAIL PROTECTED] À : Ron Johnson [EMAIL PROTECTED]; pgsql-general@postgresql.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 [EMAIL PROTECTED] 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, [EMAIL PROTECTED] wrote: List of highschools by city state and county Mark On 3/1/07, Ron Johnson [EMAIL PROTECTED] 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
Re: [GENERAL] US Highschool database in postgres
On Monday 05 March 2007 08:47, Laurent ROCHE wrote:
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.
Don't forget to look at the samples database project on pgfoundry:
http://pgfoundry.org/projects/dbsamples/
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
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 [EMAIL PROTECTED] 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, [EMAIL PROTECTED] wrote: List of highschools by city state and county Mark On 3/1/07, Ron Johnson [EMAIL PROTECTED] 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-
Re: [GENERAL] US Highschool database in postgres
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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) iD8DBQFF5wuFS9HxQb37XmcRAk8OAKCEKRtzaXppkdVedA4ZB798wrG1XgCeOqpi cnqACyTWIvWW0mTMXSQEqZY= =q/4U -END PGP SIGNATURE- ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
