State of Georgia as it's own nation

Kelric · 08-20-2006, 06:42 PM

Following my Cape Cod league, I am creating a league in the state of Georgia that will operate as it's own nation. This is going to be ridiculously huge to accomplish, as there are 531 towns/cities in Georgia as of the 2000 US Census data that I have. The longest part is obtaining the geographic location for input into OOTP.

If someone knows of a quicker way to obtain that information other than manually entering in each town/city one by one here, then I would greatly appreciate it.

As with my Cape Cod information, I will post the final data here on the forums for general use.

exoverge · 08-20-2006, 07:10 PM

I can't believe I couldn't find it in a downloadable format on the census site. Must be hidden somewhere in there. But anyway, I did find the following site which has the data in multiple formats and charges $2 per state or $10 for the nation. Looks like it has all the information you need.

http://www.customcensusdata.com/gazPlaces.html

Kelric · 08-20-2006, 07:26 PM

Damn, that probably has exactly what I need. But I'm cheap.

Thanks for looking at least.

ey215 · 08-20-2006, 10:42 PM

Quote:

Originally Posted by Kelric

Following my Cape Cod league, I am creating a league in the state of Georgia that will operate as it's own nation. This is going to be ridiculously huge to accomplish, as there are 531 towns/cities in Georgia as of the 2000 US Census data that I have. The longest part is obtaining the geographic location for input into OOTP.

If someone knows of a quicker way to obtain that information other than manually entering in each town/city one by one here, then I would greatly appreciate it.

As with my Cape Cod information, I will post the final data here on the forums for general use.

Nice! Milledgeville, here I come!

Raidergoo · 08-21-2006, 08:21 AM

There are easy and free ways to do this. My file is at work; wait a few hours and I'll post GA as an independant nation.

Kelric · 08-21-2006, 04:00 PM

Quote:

Originally Posted by Raidergoo

There are easy and free ways to do this. My file is at work; wait a few hours and I'll post GA as an independant nation.

Hooray.

I have the population info and such, that was easy. It's just the lats/longs that have been tough to find (as going one by one for 530 places didn't appeal to me much).

Just how easy/quick is it to do, by the way? If you have the proper information and it can all be worked on a spreadsheet, I'd be willing to start doing a project that covers every state.

Raidergoo · 08-21-2006, 06:08 PM

Edited

Raidergoo · 08-21-2006, 06:11 PM

Send me an email address. The zip file is 311 KB.

It's drawn from a US Census Dept file called places2k.txt.

The file can be seen here.

What I did was just clean up the useless fields.

Once you figure out using some of the very obscure Excel functions, it takes 1 minute to turn out the entire USA. Figuring out those functions took me 4 days or so.

Kelric · 09-06-2006, 04:04 PM

And.... done. Every state as it's own nation has been completed and sent to http://www.ootpmodsquad.com/

I'll create a new thread for it when I see it's been hosted.

08-20-2006, 06:42 PM	#1 (permalink)
Kelric Hall Of Famer Join Date: Mar 2002 Location: Greater Boston Area Posts: 3,982 Thanks: 7 Thanked 46x in 36 posts	State of Georgia as it's own nation Following my Cape Cod league, I am creating a league in the state of Georgia that will operate as it's own nation. This is going to be ridiculously huge to accomplish, as there are 531 towns/cities in Georgia as of the 2000 US Census data that I have. The longest part is obtaining the geographic location for input into OOTP. If someone knows of a quicker way to obtain that information other than manually entering in each town/city one by one here, then I would greatly appreciate it. As with my Cape Cod information, I will post the final data here on the forums for general use. __________________ Former Co-Commish and owner of the Boston Red Sox, 1783-1144, .609%, of the defunct Overlords Baseball League (1930-48). 17 Division wins, 9 ALCS wins, 5 World Series wins. Last edited by Kelric; 08-20-2006 at 06:44 PM.

08-20-2006, 07:10 PM	#2 (permalink)
exoverge Minors (Rookie Ball) Join Date: Jan 2005 Location: New Jersey Posts: 38 Thanks: 1 Thanked 0x in 0 posts	I can't believe I couldn't find it in a downloadable format on the census site. Must be hidden somewhere in there. But anyway, I did find the following site which has the data in multiple formats and charges $2 per state or $10 for the nation. Looks like it has all the information you need. http://www.customcensusdata.com/gazPlaces.html __________________ NGBL - (Webmaster & Co-Commish)

08-20-2006, 07:26 PM	#3 (permalink)
Kelric Hall Of Famer Join Date: Mar 2002 Location: Greater Boston Area Posts: 3,982 Thanks: 7 Thanked 46x in 36 posts	Damn, that probably has exactly what I need. But I'm cheap. Thanks for looking at least. __________________ Former Co-Commish and owner of the Boston Red Sox, 1783-1144, .609%, of the defunct Overlords Baseball League (1930-48). 17 Division wins, 9 ALCS wins, 5 World Series wins.

08-21-2006, 06:08 PM	#7 (permalink)
Raidergoo Hall Of Famer Join Date: Mar 2003 Location: 39.84 N -84.12 W Posts: 8,327 Thanks: 76 Thanked 53x in 36 posts	Edited Last edited by Raidergoo; 08-21-2006 at 06:12 PM.

09-06-2006, 04:04 PM	#9 (permalink)
Kelric Hall Of Famer Join Date: Mar 2002 Location: Greater Boston Area Posts: 3,982 Thanks: 7 Thanked 46x in 36 posts	And.... done. Every state as it's own nation has been completed and sent to http://www.ootpmodsquad.com/ I'll create a new thread for it when I see it's been hosted. __________________ Former Co-Commish and owner of the Boston Red Sox, 1783-1144, .609%, of the defunct Overlords Baseball League (1930-48). 17 Division wins, 9 ALCS wins, 5 World Series wins. Last edited by Kelric; 09-06-2006 at 05:35 PM.

08-21-2006, 08:21 AM	#5 (permalink)
Raidergoo Hall Of Famer Join Date: Mar 2003 Location: 39.84 N -84.12 W Posts: 8,327 Thanks: 76 Thanked 53x in 36 posts	There are easy and free ways to do this. My file is at work; wait a few hours and I'll post GA as an independant nation.

08-21-2006, 06:11 PM	#8 (permalink)
Raidergoo Hall Of Famer Join Date: Mar 2003 Location: 39.84 N -84.12 W Posts: 8,327 Thanks: 76 Thanked 53x in 36 posts	Send me an email address. The zip file is 311 KB. It's drawn from a US Census Dept file called places2k.txt. The file can be seen here. What I did was just clean up the useless fields. Once you figure out using some of the very obscure Excel functions, it takes 1 minute to turn out the entire USA. Figuring out those functions took me 4 days or so.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode