Updated Cuban Cities

[southside_hitmen]

Here is an updated file for the Cuban cities. The original cities.txt had most of the cities drastically underpopulated. Also, I broke it down into municipalities like the Cuban government does. You will no longer have a ton of players from Havanna (it was mispelled anyway) as that is broken down as well, players will still be from Havana but will now come from different areas of the city. Cuba essentially has 15 regions, each with municipalities and that should be properly replicated here.

Tried to stay true to the Spanish spelling as much as possible. Population information is taken from recent census projections (2006 for most, 2005 for Villa Clara). This should help to diversify your Cuban leagues a bit.

I need help uploading the cities.txt file as even when i zip it up it is exceeding the upload limit right now


Here is the cities that I added:

Abreus,30599,49,Cienfuegos,22.28,-80.57
Aguada,31931,49,Cienfuegos,22.34,-80.85
Alquízar,30613,49,La Habana,22.81,-82.58
Amancio,41121,49,Las Tunas,20.82,-77.58
Antilla,12066,49,Holguín,20.85,-75.75
Arroyo Naranjo,210950,49,Ciudad de la Habana,23.01,-82.30
Artemisa,82229,49,La Habana,22.81,-82.76
Báguanos,52780,49,Holguín,20.76,-76.03
Bahía Honda,45546,49,Pinar del Río,22.90,-83.16
Banes,80841,49,Holguín,20.97,-75.71
Baracoa,48362,49,Guantánamo,20.35,-74.51
Baraguá,32208,49,Ciego de Avila,21.68,-78.62
Bartolomé Masó,52987,49,Granma,20.17,-76.94
Batabanó,26229,49,La Habana,22.72,-82.29
Bauta,46858,49,La Habana,23.00,-82.55
Bayamo,225126,49,Granma,20.38,-76.64
Bejucal,26242,49,La Habana,22.93,-82.39
Bolivia,16361,49,Ciego de Avila,22.08,-78.35
Boyeros,187266,49,Ciudad de la Habana,22.98,-82.39
Buey Arriba,31666,49,Granma,20.17,-76.75
Cabaiguán,67322,49,Sancti Spíritus,22.08,-79.50
Cacocum,42602,49,Holguín,20.74,-76.32
Caibarién,38134,49,Villa Clara,22.52,-79.47
Caimanera,10777,49,Guantánamo,20.00,-75.16
Caimito,38033,49,La Habana,22.96,-82.60
Calimete,29388,49,Matanzas,22.53,-80.91
Calixto García,57935,49,Holguín,20.85,-76.60
Camagüey,327046,49,Camagüey,21.38,-77.91
Camajuaní,63342,49,Villa Clara,22.47,-79.72
Campechuela,45602,49,Granma,20.23,-77.28
Candelaria,19790,49,Pinar del Río,22.74,-82.95
Cárdenas,105889,49,Matanzas,23.04,-81.20
Carlos Manuel de Céspedes,25395,49,Camagüey,21.58,-78.28
Cauto Cristo,21320,49,Granma,20.56,-76.47
Centro Habana,154838,49,Ciudad de la Habana,23.14,-82.38
Cerro,130593,49,Ciudad de la Habana,23.11,-82.36
Chambas,39402,49,Ciego de Avila,22.20,-78.91
Ciego de Avila,138757,49,Ciego de Avila,21.85,-78.76
Ciénaga de Zapata,9070,49,Matanzas,22.29,-81.20
Cienfuegos,165231,49,Cienfuegos,22.15,-80.44
Cifuentes,32964,49,Villa Clara,22.62,-80.07
Ciro Redondo,29691,49,Ciego de Avila,22.02,-78.70
Colombia,32771,49,Las Tunas,20.99,-77.42
Colón,71468,49,Matanzas,22.72,-80.91
Consolación del Sur,87893,49,Pinar del Río,22.59,-83.51
Contramaestre,104734,49,Santiago de Cuba,20.30,-76.25
Corralillo,27427,49,Villa Clara,22.99,-80.58
Cotorro,74760,49,Ciudad de la Habana,23.00,-82.21
Cruces,32098,49,Cienfuegos,22.34,-80.28
Cueto,34365,49,Holguín,20.65,-75.93
Cumanayagua,51635,49,Cienfuegos,22.15,-80.20
Diez de Octubre,219953,49,Ciudad de la Habana,23.10,-82.34
El Salvador,45734,49,Guantánamo,20.21,-75.22
Encrucijada,33443,49,Villa Clara,22.62,-79.87
Esmeralda,29470,49,Camagüey,21.86,-78.11
Florencia,19583,49,Ciego de Avila,22.15,-78.97
Florida,72515,49,Camagüey,21.53,-78.22
Fomento,33301,49,Sancti Spíritus,22.11,-79.72
Frank País,25654,49,Holguín,20.67,-75.28
Gibara,72392,49,Holguín,21.11,-76.14
Guáimaro,57363,49,Camagüey,21.06,-77.35
Guamá,34817,49,Santiago de Cuba,19.98,-76.41
Guanabacoa,113258,49,Ciudad de la Habana,23.10,-82.25
Guanajay,28717,49,La Habana,22.93,-82.69
Guane,35786,49,Pinar del Río,22.21,-84.08
Guantánamo,243808,49,Guantánamo,20.14,-75.21
Güines,68559,49,La Habana,22.85,-82.02
Güira de Melena,38121,49,La Habana,22.80,-82.50
Guisa,50659,49,Granma,20.26,-76.54
Holguín,331580,49,Holguín,20.89,-76.26
Imías,21014,49,Guantánamo,20.08,-74.65
Isla de la Juventud,86557,49,Isla de la Juventud,21.75,-82.85
Jagüey Grande,58924,49,Matanzas,22.53,-81.13
Jaruco,25309,49,La Habana,23.04,-82.01
Jatibonico,42945,49,Sancti Spíritus,21.95,-79.17
Jesús Menéndez,50974,49,Las Tunas,21.16,-76.48
Jiguaní,60627,49,Granma,20.37,-76.42
Jimaguayú,21166,49,Camagüey,21.27,-77.83
Jobabo,48770,49,Las Tunas,20.91,-77.28
Jovellanos,59258,49,Matanzas,22.81,-81.20
La Habana del Este,175139,49,Ciudad de la Habana,23.16,-82.25
La Habana Vieja,92347,49,Ciudad de la Habana,23.14,-82.37
La Lisa,130790,49,Ciudad de la Habana,23.03,-82.48
La Palma,35403,49,Pinar del Río,22.76,-83.55
La Sierpe,16844,49,Sancti Spíritus,21.76,-79.24
Lajas,22502,49,Cienfuegos,22.42,-80.29
Las Tunas,191169,49,Las Tunas,20.96,-76.95
Limonar,25745,49,Matanzas,22.96,-81.41
Los Arabos,25287,49,Matanzas,22.74,-80.72
Los Palacios,38856,49,Pinar del Río,22.59,-83.25
Madruga,30445,49,La Habana,22.92,-81.86
Maisí,28446,49,Guantánamo,20.24,-74.16
Majagua,26664,49,Ciego de Avila,21.92,-78.99
Majibacoa,40695,49,Las Tunas,20.92,-76.88
Manatí,32809,49,Las Tunas,21.31,-76.94
Manicaragua,72641,49,Villa Clara,22.15,-79.98
Mantua,25884,49,Pinar del Río,22.29,-84.29
Manuel Tames,14299,49,Guantánamo,20.18,-75.05
Manzanillo,131121,49,Granma,20.34,-77.11
Marianao,134305,49,Ciudad de la Habana,23.08,-82.40
Mariel,43633,49,La Habana,23.00,-82.75
Martí,23177,49,Matanzas,23.05,-80.92
Matanzas,146078,49,Matanzas,23.05,-81.58
Mayarí,105028,49,Holguín,20.66,-75.68
Media Luna,35237,49,Granma,20.14,-77.44
Melena del Sur,20397,49,La Habana,22.78,-82.15
Mella,35050,49,Santiago de Cuba,20.37,-75.91
Minas,38116,49,Camagüey,21.49,-77.60
Minas de Matahambre,34000,49,Pinar del Río,22.59,-83.95
Moa,72414,49,Holguín,20.64,-74.92
Morón,62228,49,Ciego de Avila,22.11,-78.63
Najasa,16299,49,Camagüey,21.08,-77.75
Niceto Pérez,18116,49,Guantánamo,20.13,-75.34
Niquero,41733,49,Granma,20.05,-77.58
Nueva Paz,24615,49,La Habana,22.76,-81.76
Nuevitas,43953,49,Camagüey,21.54,-77.26
Palma Soriano,123097,49,Santiago de Cuba,20.21,-75.99
Palmira,33418,49,Cienfuegos,22.24,-80.39
Pedro Betancourt,32000,49,Matanzas,22.73,-81.29
Perico,30910,49,Matanzas,22.78,-81.02
Pilón,29658,49,Granma,19.91,-77.32
Pinar del Río,191388,49,Pinar del Río,22.42,-83.70
Placetas,71212,49,Villa Clara,22.32,-79.66
Playa,182712,49,Ciudad de la Habana,23.09,-82.45
Plaza de la Revolución,158682,49,Ciudad de la Habana,23.13,-82.39
Primero de Enero,27689,49,Ciego de Avila,21.95,-78.42
Puerto Padre,93550,49,Las Tunas,21.19,-76.95
Quemado de Güines,22532,49,Villa Clara,22.79,-80.26
Quivicán,29874,49,La Habana,22.82,-82.36
Rafael Freyre,51275,49,Holguín,21.03,-75.99
Ranchuelo,58590,49,Villa Clara,22.34,-80.11
Regla,43898,49,Ciudad de la Habana,23.14,-82.30
Remedios,46140,49,Villa Clara,22.49,-79.55
Río Cauto,47918,49,Granma,20.56,-76.92
Rodas,33562,49,Cienfuegos,22.34,-80.56
Sagua de Tánamo,51679,49,Holguín,20.59,-75.24
Sagua la Grande,55727,49,Villa Clara,22.81,-80.07
San Antonio de los Baños,48629,49,La Habana,22.89,-82.50
San Antonio del Sur,26500,49,Guantánamo,20.06,-74.81
San Cristóbal,71300,49,Pinar del Río,22.71,-83.05
San José de las Lajas,71729,49,La Habana,22.97,-82.16
San Juan y Martinez,45037,49,Pinar del Río,22.28,-83.85
San Luis,33981,49,Pinar del Río,22.29,-83.78
San Luis,89066,49,Santiago de Cuba,20.19,-75.99
San Miguel del Padrón,158764,49,Ciudad de la Habana,23.06,-82.28
San Nicolás,21479,49,La Habana,22.78,-81.91
Sancti Spíritus,134810,49,Sancti Spíritus,21.93,-79.44
Sandino,38896,49,Pinar del Río,22.08,-84.21
Santa Clara,237973,49,Villa Clara,22.41,-79.95
Santa Cruz del Norte,33432,49,La Habana,23.16,-81.93
Santa Cruz del Sur,50149,49,Camagüey,20.72,-77.99
Santiago de Cuba,494430,49,Santiago de Cuba,20.04,-75.81
Santo Domingo,53610,49,Villa Clara,22.58,-80.24
Segundo Frente,39993,49,Santiago de Cuba,20.41,-75.53
Sibanicú,31128,49,Camagüey,21.24,-77.52
Sierra de Cubitas,18655,49,Camagüey,21.73,-77.77
Songo-La Maya,93832,49,Santiago de Cuba,20.17,-75.65
Taguasco,36228,49,Sancti Spíritus,22.01,-79.27
Tercer Frente,29722,49,Santiago de Cuba,20.17,-76.33
Trinidad,74304,49,Sancti Spíritus,21.80,-79.98
Unión de Reyes,38893,49,Matanzas,22.80,-81.54
Urbano Noris,43760,49,Holguín,20.60,-76.13
Varadero,25990,49,Matanzas,23.14,-81.29
Venezuela,27227,49,Ciego de Avila,21.75,-78.78
Vertientes,53190,49,Camagüey,21.26,-78.15
Viñales,27516,49,Pinar del Río,22.62,-83.71
Yaguajay,58004,49,Sancti Spíritus,22.33,-79.24
Yara,59172,49,Granma,20.28,-76.95
Yateras,20558,49,Guantánamo,20.35,-74.92

[Raidergoo]

1) What is your source for this?

2) Can you post your entire list for Cuba?

I can add this to Bugzilla and try to get it shipped with OOTP 9.

[southside_hitmen]

Populations are taken from the cuban census projections from the government in 2006, except for Villa Clara which only had info from 2005. I basically had to download a pdf file from each province and hunt for the info.

Here's the main Cuban site I used for the populations: Oficina Nacional de Estadísticas. Cuba

The latitudes and longitudes are from wikipedia.

As far as the complete list, this is it. It will replace every current city for Cuba. Every city has been updated, if it hasn't been replaced, so you will just need to delete all the other cities from Cuba and add these. I can also send you in what municipality each team in Cuba plays so they can have their accurate city info for the release.

Next step is updated weather info for each province, that's also in the province pdf's, so it should be easy enough. I just need to know what the rain % is based off of. Is it based on total rainfall, or # of days each month?

[southside_hitmen]

Also, since Isla de la Juventud does not have individual municipalities, I may add a few cities from there before the release, as of right now their is only info for the whole island.

[Raidergoo]

Originally Posted by southside_hitmen

Is it based on total rainfall, or # of days each month?

It is based off of # days per month with rainfall.

Example:

June has 30 days, 10 of which have rain.

((10/30)/8)*100 = 4.16

Round to the nearest whole number, this case 4. There would be a 4% chance of rain during the game.

[ChinoNYC]

Have you used GMail, as it allows attachments up to 16-17 MB to be sent without cause for much concern?? And send it to someone who has good bandwidth so that he may host it on their site, perhaps.

[southside_hitmen]

Originally Posted by Raidergoo

It is based off of # days per month with rainfall.

Example:

June has 30 days, 10 of which have rain.

((10/30)/8)*100 = 4.16

Round to the nearest whole number, this case 4. There would be a 4% chance of rain during the game.

OK, I get most of it, but why do you divide by 8?

[southside_hitmen]

Originally Posted by ChinoNYC

Have you used GMail, as it allows attachments up to 16-17 MB to be sent without cause for much concern?? And send it to someone who has good bandwidth so that he may host it on their site, perhaps.

That's a good idea. The forum has an upload limit and apparently the .zip file is too large for it. I guess I could split it in half as well, but i swore I have seen others upload their whole file as 1. Also, when I convert the file back from excel to a text file it gets a little screwy with foriegn characters. Any suggestions?

[Raidergoo]

Originally Posted by southside_hitmen

OK, I get most of it, but why do you divide by 8?

There are 8 three hour periods in a day, which is around the average game time for a major league game. Plus, it was how it was done in OOTP 6.

[ChinoNYC]

Well, you could try saving it as a .CSV file as OOTP can import from a comma-delimited format. However, importing it with special characters will cause OOTP to replace the special accented characters with a letter from the normal alphabet, usually z, such as in the case of Bayamón (PR), where the ó is replaced with a z, thereby calling the town Bayamzn.

[southside_hitmen]

Originally Posted by Raidergoo

There are 8 three hour periods in a day, which is around the average game time for a major league game. Plus, it was how it was done in OOTP 6.

Got it, thanks. Don't really have time this weekend but I'll get to work on the weather next week

[southside_hitmen]

Originally Posted by Raidergoo

It is based off of # days per month with rainfall.

Example:

June has 30 days, 10 of which have rain.

((10/30)/8)*100 = 4.16

Round to the nearest whole number, this case 4. There would be a 4% chance of rain during the game.

Looking again at those pdf's, it appears they only have total rainfall and not days per month. Will have to do a little more searching on the subject. Anyone know of a good site with # of rainy days per month?

[Raidergoo]

Originally Posted by southside_hitmen

Looking again at those pdf's, it appears they only have total rainfall and not days per month. Will have to do a little more searching on the subject. Anyone know of a good site with # of rainy days per month?

It's very hard to do, but you can make your own here:

Climate Data Online Summary

[southside_hitmen]

Originally Posted by Raidergoo

It's very hard to do, but you can make your own here:

Climate Data Online Summary

That site is awesome. Very good info. I will concentrate on the cities that the teams are in initially so it can hopefully get released with OOTP9. I can expand to other Cuban cities later.

[No Pepper]

southside,

Now that we have multinational support for our leagues and teams, are you thinking about creating the Cuban provinces as individual nations, as each team is made up of players from that region?

[southside_hitmen]

Originally Posted by No Pepper

southside,

Now that we have multinational support for our leagues and teams, are you thinking about creating the Cuban provinces as individual nations, as each team is made up of players from that region?

You sir, read my mind. Still got to get through the cuban weather first, but that's next on the agenda. Should be relatively simple. Would also be great if you could set the "foriegner" percentage by region. So if you were doing an All U.S. league, you could have players on teams from only Illinois, and another team only from Wisconsin. You could then run those leagues in larger universes instead of having to run them by themself.