Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 26 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 10-20-2021, 09:08 PM   #1
cbbl
All Star Starter
 
cbbl's Avatar
 
Join Date: Apr 2003
Location: Massachusetts
Posts: 1,179
Historical world_default.txt file - US 1850-1890

See thread:
https://forums.ootpdevelopments.com/...02#post4835302

Datasource: U.S. Census Abstracts/Summaries for each census year available at https://www2.census.gov/library/publications/decennial/

Some general comments:

1. I have sought to preserve all IDs from the original OOTP-provided world_default.txt file. Accordingly, a few important things to note:
  • One, some localities may be in the file with NULL populations (pop=""). These will be interpreted by the application as a population of 10. If you wish to truly zero them, you have to do so from within the application itself. It is strongly recommended that you do not delete these municipalities as they could result in errors such as birthplace = "Unknown". This is NOT true for states/territories. If the state/territory did not exist for the applicable census, it is excluded from the file.

  • Two, any municipalities not included in the OOTP-provided world_default.txt file (there are many) start with the CITY id of 200000.
2. These files are ONLY NATION_id="206" (United States). You can use these files as they are, or overwrite the data in the larger world_default.txt file.

3. All Korean attributes within the CITY lines have been eliminated.

4. At this time, I have not updated longitude or latitude for any new municipality added to the file. Where possible, I have tried to update time zones in states with multiple time zones, but I do not promise they are completely accurate.
Attached Files
File Type: zip world_default_1850_USpop.xml.zip (448.0 KB, 226 views)
File Type: zip world_default_1860_USpop.xml.zip (475.4 KB, 208 views)
File Type: zip world_default_1870_USpop.xml.zip (491.5 KB, 248 views)
File Type: zip world_default_1880_USpop.xml.zip (493.8 KB, 230 views)
File Type: zip world_default_1890_USpop.xml.zip (502.5 KB, 227 views)

Last edited by cbbl; 10-21-2021 at 04:31 PM.
cbbl is offline   Reply With Quote
Old 10-21-2021, 04:02 PM   #2
cbbl
All Star Starter
 
cbbl's Avatar
 
Join Date: Apr 2003
Location: Massachusetts
Posts: 1,179
FILE: world_default_1850_USpop.xml

I have started the significant project of updating the populations for all municipalities listed in the census for the decade listed and will update this post as my work continues.

1. To reflect the makeup of baseball during this era, the ETHN_PCTS have been set to 100% caucasian and all second ethnicities have been removed.

2. For some states, much of the population did not reside within a defined municipality, particularly in southern states. To account for this population, I have created generic "cities" for each county and have set the population as the residual number of persons within that county not included in a municipality count.

Last edited by cbbl; 10-21-2021 at 04:13 PM.
cbbl is offline   Reply With Quote
Old 10-21-2021, 04:02 PM   #3
cbbl
All Star Starter
 
cbbl's Avatar
 
Join Date: Apr 2003
Location: Massachusetts
Posts: 1,179
Reserved for discussion about 1860 file
cbbl is offline   Reply With Quote
Old 10-21-2021, 04:03 PM   #4
cbbl
All Star Starter
 
cbbl's Avatar
 
Join Date: Apr 2003
Location: Massachusetts
Posts: 1,179
Reserved for discussion about 1870 file
cbbl is offline   Reply With Quote
Old 10-21-2021, 04:03 PM   #5
cbbl
All Star Starter
 
cbbl's Avatar
 
Join Date: Apr 2003
Location: Massachusetts
Posts: 1,179
Reserved for discussion about 1880 file
cbbl is offline   Reply With Quote
Old 10-21-2021, 04:03 PM   #6
cbbl
All Star Starter
 
cbbl's Avatar
 
Join Date: Apr 2003
Location: Massachusetts
Posts: 1,179
Reserved for discussion about 1890 file
cbbl is offline   Reply With Quote
Reply

Bookmarks


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 05:31 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments