Page 1 of 2 1 2 LastLast
Results 1 to 15 of 20

Thread: Historic city data update

  1. #1
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878

    Historic city data update

    I've put together a database of cities through the various decades, with accurate City and regional populations from 1900-2010 (some of the population figures are estimates, but their pretty good ones). The first set of files is for 1900 (for use between 1901-1909), and is attached below.

    The Regional population figures are based on County Population data, which is available for all time periods through US Census data. Note that the Counties which are included in any particular cities' region are determined by Nieson Market Research. I spent literally 100's of hours hand coding the Nielson data into the database, and I have to say that I'm particularly proud of the realistic effect which it provides. It most certainly creates proper market sizes for several cities which are either over or under represented in the base City data that Baseball Mogul uses. For example, in the base city data in 2007, Seattle has a paltry 3,554,000 regional population and Milwaukee has 1,685,000. In my set, based on real life market data, Seattle has 4,305,000 while Milwaukee has 2,216,000. NY's base region is 21,199,00 while in this set it has 20,381,916.

    I also used much more accurate Median Household Income data (again, county wide data), also available though the US Census, to replace the income data that the game comes with. Again, the effect turns out to be very nice, as it gives a great differential between not only cities in different regions, but also some particular cities within the same region.

    There are 212 Cities in the 1900's set. I've included all of the Major cities in the US with actual city populations above 10,000 in 1900. There are several thousand additional cities available in the database that I have though, so if anyone has any requests for additions to the base set feel free to ask. The largest cities (by region) available in 1901 are as follows:
    Code:
    City Name	State		City 	Region 	Growth	Income
    Passaic		New Jersey	209930	7596905	2332	47861
    Yonkers		New York	278993	7596905	3099	63924
    Scarborough	New York	278993	7596905	3099	63924
    Jamaica		New York	379924	7596905	4221	39649
    Manhattan	New York	1850123	7596905	20556	45290
    Brooklyn	New York	1634868	7596905	18165	38238
    Bronx		New York	592932	7596905	6588	28173
    Jersey City	New Jersey	509614	7596905	5662	40311
    Hoboken		New Jersey	509614	7596905	5662	40311
    Newark		New Jersey	528192	7596905	5868	52050
    New York	New York	592932	7596905	6588	28173
    Mexico City	Mexico		6377076	6377076	70856	20000
    Chicago		Illinois	2472943	3116559	27477	28201
    Wilmington	Illinois	75257	3116559	836	66417
    Philadelphia	Pennsylvania	1477260	3043297	16414	30892
    Wilmington	Massachusetts	630465	2687496	7005	63949
    Boston		Massachusetts	676772	2687496	7519	41517
    Pittsburgh	Pennsylvania	960504	2010668	10672	42182
    Cleveland	Ohio		764230	1586639	8491	40547
    Toronto		Canada		1486680	1486680	16518	49345
    In order to use this file manually, place the Cities output 1900.txt file in you're main Baseball Mogul folder. Rename the file to Cities.txt. Then go to Tools -> Advanced Tools and click the Import Cities button, and say yes to replace the current cities. The order and names of the cities are all different, so if you use this method to import the cities be sure to go into the league editor and adjust the cities that each team is located in.

    Also attached is a .MOG save game version with the city information imported into the game already and with the teams set to the correct cities. This save game also uses my roster set (available in the link in my signature). If you do adjust the League Revenue or Salary Demands, I'd recommend using the Calculate Salaries option in Tools -> Advanced tools to adjust the game to the new environment.

    FYI: Be on the lookout for team moves while using this mod. Since the order of the city information is now different, the team's city will no longer change correctly when a team moves. The game notifies you when a team does move however, so once that occurs simply enter League editor and adjust the team's home city as appropriate. The first move to occur is Milwaukee moving to St. Louis after the 1901 season. Baltimore also moves to New York (to become the Highlanders/Yankees) after the 1902 season. I've provided a 1902 save game with the St. Louis Browns city changed already (1901 has been simmed through with the other save game) for those who wish to avoid having to change the city themselves.

    Also, the save game is set to Manager level (for testing reasons), so be sure to adjust that to the setting that you'd like in League -> Options before you begin playing.
    Last edited by ohms_law; 09-22-2007 at 02:26 AM. Reason: Updated
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

  2. #2
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878

    Re: Historic Cities

    This is the 1910 Set. The save game has been simulated from 1901 until 1909, and the city data for 1910 was loaded just prior to the free agent period at the end of the 1909 season. The save game posted has been saved on April 1, 1910, and all of the team cities have been ensured to be correct. Note that the finances of some of the teams (including most of the NL!) are in somewhat bad shape, but the teams are as competitive as they normally are from what I've seen. Feel free to edit team finances as you see fit, though.

    To use just the Cities output 1910.txt file: download the file and rename it to Cities.txt, then place the file in your root Baseball Mogul directory. Go to Tools -> Advanced Tools and click the Import Cities button. After doing this, open League Editor (enabling commissioner mode) and set all of the teams to their correct cities.
    Attached Files Attached Files
    Last edited by ohms_law; 09-22-2007 at 02:25 AM. Reason: Updated
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

  3. #3
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878

    Re: Historic Cities

    This is the 1920 set. To use the Cities.txt file, download it and place the file in your root Baseball Mogul directory, then go to Tools -> Advanced Tools and click the Import Cities button. After doing this, open League Editor (enabling commissioner mode) and set all of the teams to their correct cities.
    Attached Files Attached Files
    Last edited by ohms_law; 09-22-2007 at 02:24 AM.
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

  4. #4
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878

    Re: Historic Cities

    1930 set
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

  5. #5
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878

    Re: Historic Cities

    1940 set
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

  6. #6
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878

    Re: Historic Cities

    1950 set
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

  7. #7
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878

    Re: Historic Cities

    1960 set
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

  8. #8
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878

    Re: Historic Cities

    1970 set
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

  9. #9
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878

    Re: Historic Cities

    1980 set
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

  10. #10
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878

    Re: Historic Cities

    1990 set
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

  11. #11
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878

    Re: Historic Cities

    2000 set
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

  12. #12
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878

    Re: Historic Cities

    This is the 2007 save game version (There isn't a cities.txt specifically for 2007 since it's the same as the 2000 cities.txt, above). The save game has been set up at the start of the 2007 season, and the city data for the 2000's has been loaded. The save game posted has been saved on April 1, 2007, and all of the team cities have been ensured to be correct.
    Last edited by ohms_law; 07-29-2007 at 04:14 AM. Reason: Added description and files
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

  13. #13
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878

    Re: Historic city data update

    2010 Set
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

  14. #14
    Join Date
    Jan 2003
    Location
    Huntsville, AL
    Posts
    5,237

    Re: Historic city data update

    thanks for all the hard work
    Be more concerned with your character than your reputation, because your character is what you really are, while your reputation is merely what others think you are .

  15. #15
    Join Date
    Jun 2006
    Location
    Edison, NJ
    Posts
    15,878
    Updated 7/24/2007
    Updated the 1901 set.

    Updated 7/25/2007
    Added 1910 set.

    Updated 7/28/2007
    Added 2007 save game file.

    Updated 9/21/2007
    Added 1920 set.
    Fixed 1900 and 1910 City data text files.
    You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •