? on cities.txt

redsox45 · 06-08-2006, 10:39 PM

Raidergoo,

I downloaded your US cities file this evening, and popped it into excel. It seemed to work fine without any crashes.

I got it into columns fine, and can pretty much figure out what each of them are, except one...

There is one column with nothing but "206" in it. What is this "206" is it the nation associated with the city, state...?

Will

battists · 06-08-2006, 10:40 PM

Quote:

Originally Posted by redsox45

Raidergoo,

I downloaded your US cities file this evening, and popped it into excel. It seemed to work fine without any crashes.

I got it into columns fine, and can pretty much figure out what each of them are, except one...

There is one column with nothing but "206" in it. What is this "206" is it the nation associated with the city, state...?

Will

Yes.

Raidergoo · 06-08-2006, 10:57 PM

Quote:

Originally Posted by battists

Yes.

Cryptic.

Raidergoo · 06-08-2006, 10:58 PM

Quote:

Originally Posted by redsox45

Raidergoo,

I downloaded your US cities file this evening, and popped it into excel. It seemed to work fine without any crashes.

I got it into columns fine, and can pretty much figure out what each of them are, except one...

There is one column with nothing but "206" in it. What is this "206" is it the nation associated with the city, state...?

Will

206 is the nation column, which in this case is The United States.

redsox45 · 06-09-2006, 06:36 AM

OK,

so basically, if you wanted to change each state to a nation edit the nations.txt file accordingly, and match up the cities.txt file, you could do that...

It's a great file btw...

But then, any file that has Machias, Maine in it would be great!

Will

Raidergoo · 06-09-2006, 07:22 AM

Yes, you could.

Matching up data from a third party ( like me ) into cities.txt is a tough thing to do, at least for my little brain.

Bob Zupcic · 06-09-2006, 12:29 PM

Quote:

Originally Posted by redsox45

OK,

any file that has Machias, Maine in it would be great!

I edited mine so that it also has Macwahoc, Maine. And Wytopitlock. I get homesick sometimes. I'm under no illusions that the game will ever generate players from these places, however. Macwahoc has a population of 114.

battists · 06-09-2006, 12:32 PM

Quote:

Originally Posted by Bob Zupcic

I edited mine so that it also has Macwahoc, Maine. And Wytopitlock. I get homesick sometimes. I'm under no illusions that the game will ever generate players from these places, however. Macwahoc has a population of 114.

You'd be surprised. My hometown has a pop of 1,000 or so, and I ran across someone from there in the game quite by mistake.

06-08-2006, 10:39 PM	#1
redsox45 Hall Of Famer Join Date: Dec 2001 Location: Machias, Maine Posts: 4,573 Blog Entries: 1	? on cities.txt Raidergoo, I downloaded your US cities file this evening, and popped it into excel. It seemed to work fine without any crashes. I got it into columns fine, and can pretty much figure out what each of them are, except one... There is one column with nothing but "206" in it. What is this "206" is it the nation associated with the city, state...? Will __________________ Top Five Books I Ever Read: 1. Murder of Roger Ackroyd -- Agatha Christie 2. Birds of Prey -- Wilbur Smith 3. King Solomon's Mines - H. Rider Haggard 4. Comstock Lode -- Louis L'Amour 5. Andersonville -- McKinley Kantor

06-09-2006, 06:36 AM	#5
redsox45 Hall Of Famer Join Date: Dec 2001 Location: Machias, Maine Posts: 4,573 Blog Entries: 1	OK, so basically, if you wanted to change each state to a nation edit the nations.txt file accordingly, and match up the cities.txt file, you could do that... It's a great file btw... But then, any file that has Machias, Maine in it would be great! Will __________________ Top Five Books I Ever Read: 1. Murder of Roger Ackroyd -- Agatha Christie 2. Birds of Prey -- Wilbur Smith 3. King Solomon's Mines - H. Rider Haggard 4. Comstock Lode -- Louis L'Amour 5. Andersonville -- McKinley Kantor

06-09-2006, 07:22 AM	#6
Raidergoo Hall Of Famer Join Date: Mar 2003 Posts: 9,004	Yes, you could. Matching up data from a third party ( like me ) into cities.txt is a tough thing to do, at least for my little brain.