Breakdown of province.csv

[WiSK]

I know roughly what most of them do. But I don't know the PRECISE effect of all of them and we will need to if we are gonna make new provinces.

Apart from the ones shown at Havard's editing empire we have the following columns:

Climate - Values between 0 and 8. For more info see post #20 or this thread.
Uprgadable - Most provinces seem to have value 0 here. There are 138 provinces with value 1. No obviously discernable pattern apart from that they are all land provinces.
Difficulty for Colonization - Values between 0 and 9, modifies the chance for settlers to make a colony (not TP). Also lowers the cost.
Native Combat Strength - Value between 0 and 400, max number of native warriors x 100
Ferocity - Values between 0 and 5, chance that natives attack when you send new colonists?
Efficiency of Natives in combat - Values between 0 and 2, how quickly native warriors die? or are reborn after battle? or stop the battle so they can regroup?
Negotiation Value for Trading Posts - Values between 0 and 9, TP equivalent of Difficulty for Colonization.
Natives Tolerance value - Values between 0 and 9, chance that natives attack at random or if you move a non-conquistador army into the province?
City XPos, City YPos - Position on map of the city/capital sprite
Army XPos, ArmyYPos - Position on map where army/ship sprite stands
PortXPos, Port YPos - Position on map of port/shipyard sprite
Manufactory XPos, Manufactory YPos - Position on map of manufactory
Port/sea Adjacency - Which sea province the port is connected to. If this is incorrect, ships can still dock in port, but armies don't auto-unload. Should be 0 for province that don't have a port (even coastal provinces).
Terrain x, Terrain Y, Terrain variant (x4) - Position and index number of any extra sprites to display on map. This is connected to the value of the terrain column, which in turn indexes into map\terrain types.csv to indicate which sprite should be loaded. E.g. if terrain=4 and variant=3 then the game will display GFX\Map\Landscape\Marsh3.bmp when the province is known.
Extra River Desc Link 1/2/3 - Often contains values for neighbouring rivers. I think this was used by Johan in his own map tools. It doesn't seem to affect anything now?
(unnamed) - Contains values 0, 1 and X but mostly filled with #N/A. This is a weird one, and I'm guessing it also had something to do with Johan's map tools?
Fill coord X, Fill coord Y, (more Fill coords...) - Definitely unused, leftover from Johan's map tools.

When I use a question mark in the description, I'm probably just guessing about the effect.

Comments and corrections welcome

 

[Rythin]

Gosh, good stuff.

 

[Hive]

Negotiation Value for Trading Posts - Values between 0 and 9, extra cost for TP?

Could this perhaps determine the peace value of the TP instead?

Nice post btw. Good information.

Does this mean that you have begun working on a province.csv editor?

 

[WiSK]

Does this mean that you have begun working on a province.csv editor?

Might've

 

[jdrou]

Difficulty for Colonization - Values between 0 and 9, modifies the chance for settlers to make a colony (also a TP?)

Only seems to affect colonies, not TPs (see Colonization FAQ for effects)

Native Combat Strength - Value between 0 and 400, max number of native warriors?

Yes, x100 (i.e. 10 means 1000 natives).

Ferocity - Values between 0 and 5, morale of native warriors?

In EU1 this combined with Native Tolerance value to determine when natives would attack and reduce colonization probabilties. Seems to be unused in EU2.

Negotiation Value for Trading Posts - Values between 0 and 9, used to determine percentage during peace negotiations?

This seems to be the TP equivalent to Difficulty for Colonization.

 

[WiSK]

Only seems to affect colonies, not TPs (see Colonization FAQ for effects)

Yes, x100 (i.e. 10 means 1000 natives).

This seems to be the TP equivalent to Difficulty for Colonization.

Thanks for the info!

Ferocity - Values between 0 and 5, morale of native warriors?

In EU1 this combined with Native Tolerance value to determine when natives would attack and reduce colonization probabilties. Seems to be unused in EU2.

That's the thing. Natives attack when you try to colonise or move an army in, but sometimes they just attack randomly. Perhaps Ferocity is the chance they attack when you attempt to colonise, and Tolerance is the chance when there is an established colony?

 

[chegitz guevara]

Port/sea Adjacency - Which sea province the port is connected to. If this is incorrect, ships can still dock in port, but armies don't auto-unload.

Hmmm, I wonder. Do you think we could use this to make canals?

 

[unmerged(31425)]

Geez WISK I thought you may have actually known more than me.

Difficulty for Colonization - Values between 0 and 9, modifies the chance for settlers to make a colony (no TP).

This effects the percantage chance for success. It also effects cost. Lower being better for the percantage and cost.

Native Combat Strength - Value between 0 and 400, max number of native warriors x 100

Correct.

Ferocity - Values between 0 and 5, chance that natives attack when you send new colonists?
Efficiency of Natives in combat - Values between 0 and 2, how quickly native warriors die? or are reborn after battle? or something?

Not sure about these 2 but I think you're right. I haven't modded them yet. Perhasp I ought to, I deliberately try to make the natives avoid being slaughtered by the AIs. It's high time I get to work on that.

Negotiation Value for Trading Posts - Values between 0 and 9, TP equivalent of Difficulty for Colonization.

Correct. Lower has the same effect as for the colonization one

Natives Tolerance value - Values between 0 and 9, chance that natives attack at random or if you move a non-conquistador army into the province?

This is their aggressive level, you know very low(1), medium(6), etc.
The other ones you mentioned, I of course suspect the same thing but don't know for sure either.

 

[unmerged(31425)]

Could this perhaps determine the peace value of the TP instead?

No.

 

[WiSK]

Natives Tolerance value

This is their aggressive level, you know very low(1), medium(6), etc.

The Colonisation FAQ suggests this also affects colonisation chance. Jdrou suggests that Ferocity seems unused. A simple test is in order.

Make one province Difficulty=0, Ferocity=1, Tolerance=0. Observe the following:
- cost and chance of sending colonist
- after each successful colonist, note whether natives attack
- if natives don't attack, repeatedly send in a small army and note how often natives attack (don't kill natives)
- leave a colony sitting there for a while, and note how long it takes before the native attack of their own accord

Once you've gathered enough data on that, repeat observations with Ferocity=5, Tolerance=0. Then again with Ferocity=1, Tolerance=9 then Ferocity=5, Tolerance=9. This should be enough to get a good picture of what these two values represent.

Port/sea Adjacency

Hmmm, I wonder. Do you think we could use this to make canals?

Not sure what you mean with 'canals' but I'm pretty sure you can't use this for any tricks. You just need to fill it in or the port won't work as it should.

 

[unmerged(25696)]

Not sure what you mean with 'canals' but I'm pretty sure you can't use this for any tricks. You just need to fill it in or the port won't work as it should.

I think he proposes to model a canal by moving a fleet in a port, exiting on the other side of the canal. But it's not possible : if a port is adjacent to a sea-zone (and AFAIK only one adjacency is possible for a port), a fleet will always enter and leave the port from and to the same sea-zone.

The only ways to have a canal are through a strait, or through adjacencies of sea-zones.

 

[Norrefeldt]

Port/sea Adjacency - Which sea province the port is connected to. If this is incorrect, ships can still dock in port, but armies don't auto-unload.

Should be 0 even for coastal provinces that don't have a port. Used to have lots of problem with this in AGCEEP.

 

[WiSK]

Should be 0 even for coastal provinces that don't have a port. Used to have lots of problem with this in AGCEEP.

I'm interested to know what the effect was in that case?

 

[Khephren]

Sort of on topic. While waiting for new maps I've been dinking around with fantasia and I noticed it saves a lot more variables for each province. Natives, tolerance, etc are saved ( would be useful if these were saved in normal scenarios ). One variable that is saved is "wilderness". This doesn't seem to correspond with any province.csv value and is generated randomly. Upon further testing, it can be added to regular scenarios via the .inc file. Wondering if anyone knew the effects of this value.

 

[WiSK]

Sort of on topic. While waiting for new maps I've been dinking around with fantasia and I noticed it saves a lot more variables for each province. Natives, tolerance, etc are saved ( would be useful if these were saved in normal scenarios ). One variable that is saved is "wilderness". This doesn't seem to correspond with any province.csv value and is generated randomly. Upon further testing, it can be added to regular scenarios via the .inc file. Wondering if anyone knew the effects of this value.

What range of values does it have? Is it a yes/no or 0-9?

 

[unmerged(31425)]

The Colonisation FAQ suggests this also affects colonisation chance. Jdrou suggests that Ferocity seems unused. A simple test is in order.

NTV does indeed effect colonization as well. The lower it is the increased chance of success you have. I believe it also effects cost.

There is something that effects the likeness that natives will attack, a colony randomly, armies passing through, or after a failed attempt. I'm not 100% sure which setting is effecting this but I'm about 99% sure that something is. What I've noticed is that when I make provinces that are hostile in the vanilla into peaceful natives that are easy to colonize, the former hostile provinces still have natives attacking more frequently than the ones that were easy spots to begin with.

Ideally what I want is for natives to never attack and to last longer if attacked themselves. In my version I've lowered the NTV of almost every vacant province to 4 or less.

 

[WiSK]

NTV does indeed effect colonization as well. The lower it is the increased chance of success you have. I believe it also effects cost.

There is something that effects the likeness that natives will attack, a colony randomly, armies passing through, or after a failed attempt. I'm not 100% sure which setting is effecting this but I'm about 99% sure that something is. What I've noticed is that when I make provinces that are hostile in the vanilla into peaceful natives that are easy to colonize, the former hostile provinces still have natives attacking more frequently than the ones that were easy spots to begin with.

Ideally what I want is for natives to never attack and to last longer if attacked themselves. In my version I've lowered the NTV of almost every vacant province to 4 or less.

Well, you are welcome to try the simple test I proposed (ie try the extremes of the ferocity setting). I don't seem to have had time to do it myself.

 

[Norrefeldt]

I'm interested to know what the effect was in that case?

Cannot recall really. I think you got the port graphics in the city view, but no water. You might have been able to build ships that couldn't be moved afterwards. I don't think it had any useful effects.

 

[Kasperus]

As advised, I check out this thread and add a question of mine: anyone knows how 'climate' works exactly? As in what do the values stand for? As, in contrary to variables like goods or terrain, climate isn't really explained by Havard (or, at least, I cannot find it)

 

[jdrou]

As advised, I check out this thread and add a question of mine: anyone knows how 'climate' works exactly? As in what do the values stand for? As, in contrary to variables like goods or terrain, climate isn't really explained by Havard (or, at least, I cannot find it)

There's a pretty good summary by AndrewT in this thread.

The meaning of the climate values, as best we know them:

0 - Snow, October through May. It is most prevalant in November through April.
1 - Seems to be desert type weather.
2 - Certainly no snow with this value. It appears in a couple of Baltic Sea provinces, a couple of South American provinces, most of North America, and one Siberian province. it might be intended to provide very occasional snow, but still, the province assortment is wierd.
3 - No snow.
4 - Tropical climate.
5 - Some snow December through February.
6 - Tropical climate. This one seems mostly used in equatorial provinces, compared to a value of 4.
7 - Snow, November through March. It is most prevalent in December through February.
8 - Snow, June through August. Used in the southern hemisphere and in a couple of Afghani and Indian provinces (north of the equator).