|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
Thread Tools
![]() |
![]() |
#1 |
All Star Starter
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:
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. Last edited by cbbl; 10-21-2021 at 04:31 PM. |
![]() |
![]() |
![]() |
#2 |
All Star Starter
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. |
![]() |
![]() |
![]() |
#3 |
All Star Starter
Join Date: Apr 2003
Location: Massachusetts
Posts: 1,179
|
Reserved for discussion about 1860 file
|
![]() |
![]() |
![]() |
#4 |
All Star Starter
Join Date: Apr 2003
Location: Massachusetts
Posts: 1,179
|
Reserved for discussion about 1870 file
|
![]() |
![]() |
![]() |
#5 |
All Star Starter
Join Date: Apr 2003
Location: Massachusetts
Posts: 1,179
|
Reserved for discussion about 1880 file
|
![]() |
![]() |
![]() |
#6 |
All Star Starter
Join Date: Apr 2003
Location: Massachusetts
Posts: 1,179
|
Reserved for discussion about 1890 file
|
![]() |
![]() |
![]() |
Bookmarks |
|
|