As a by-product of something else I'm doing for Tornnight's The Long Road mod, I ended up sorting all of the vanilla resources by region so they're easier to find.
Every resource listed in the vanilla desc_strat/txt file has the proper region attached. Yes, I know the marble in Bologna looks like it's in Florence, but it's actually in Bologna according to the game. And I'll bet you didn't know that there was a timber resource on the border between Angers and Caen. It's hidden by trees and almost impossible to see at 105, 129.
It's in simple space and tab delimited text so it can be easily copied and pasted and imported into your favorite spreadsheet. I left the multiple region names for the same reason; so you can sort it differently and still have the region attached to the resource. It's currently sorted alphabetically by region capital then resource name then x coordinate. I used region capitals to avoid confusion when the region name is different from the capital city name, such as Fortaleza instead of Brazil.
Hopefully, someone will find this useful. I'll be working on BigMap resources in the same way in the next few days and then adding the extra provinces beyond BigMap used in The Long Road mod. I'll upload the BigMap resources sorted like this, if there's interest.
Code:
province resource X Y
Acre timber 251 60
Adana sulfur 245 77
Ajaccio wine 134 96
Aleppo spices 256 72
Aleppo spices 258 74
Alexandria cotton 233 39
Alexandria spices 231 40
Alexandria sugar 228 37
Alexandria sugar 234 37
Algiers iron 97 60
Algiers iron 106 61
Angers wine 101 124
Angers wine 110 120
Antioch cotton 253 73
Antioch cotton 253 69
Antioch sugar 249 73
Antioch sugar 250 70
Antwerp dyes 122 141
Antwerp textiles 122 143
Antwerp textiles 122 146
Arguin gold 48 2
Arguin ivory 34 5
Arguin ivory 51 2
Arguin slaves 31 22
Arguin slaves 31 18
Arhus amber 142 174
Arhus fish 136 171
Arhus fish 144 169
Baghdad silk 289 70
Baghdad silk 292 68
Baghdad sulfur 292 77
Bern timber 129 121
Bologna marble 141 105
Bordeaux dyes 97 108
Bordeaux wine 97 120
Bordeaux wine 99 116
Breslau timber 158 143
Bruges dyes 117 142
Bruges textiles 114 139
Caen dyes 109 135
Caen timber 105 129
Caernarvon coal 96 149
Caernarvon coal 98 154
Caernarvon coal 100 156
Caernarvon wool 99 155
Caffa slaves 232 117
Caffa slaves 234 119
Caffa sulfur 226 123
Cagliari silver 131 79
Cairo dyes 234 27
Cairo sugar 235 29
Cholula chocolate 6 137
Cholula chocolate 13 133
Cholula gold 2 129
Cholula gold 5 134
Cholula silver 8 140
Constantinople dyes 210 91
Constantinople grain 208 92
Constantinople silk 211 93
Constantinople silk 212 91
Cordoba coal 66 75
Cordoba coal 67 80
Cordoba sugar 74 78
Damascus sugar 264 65
Dijon coal 119 121
Dijon iron 118 109
Dijon wine 117 106
Dijon wine 120 114
Dongola ivory 227 1
Dongola ivory 236 3
Dongola slaves 229 4
Dongola slaves 232 1
Dublin silver 83 158
Durazzo timber 177 88
Edessa coal 266 83
Edinburgh dyes 100 172
Florence textiles 141 98
Florence tin 145 98
Fortaleza chocolate 8 68
Fortaleza dyes 8 72
Fortaleza gold 3 69
Fortaleza gold 3 59
Fortaleza iron 1 70
Fortaleza timber 3 75
Fortaleza tin 6 64
Frankfurt coal 136 143
Frankfurt coal 144 141
Gaza textiles 250 43
Genoa marble 137 103
Genoa textiles 132 105
Halych amber 187 146
Hamburg silver 139 149
Helsinki dyes 198 186
Helsinki fish 179 187
Helsinki fish 186 186
Helsinki furs 185 187
Helsinki furs 196 186
Helsinki timber 184 188
Iconium sulfur 233 80
Iconium wool 231 79
Iraklion timber 199 57
Jedda spices 268 16
Jerusalem dyes 252 52
Kiev slaves 216 136
Kiev slaves 221 141
Kiev sulfur 214 128
Krakow amber 171 147
Krakow amber 179 132
Krakow silver 176 132
Krakow sulfur 174 138
Leon coal 69 107
Leon wool 63 105
Lisbon marble 60 96
Lisbon tin 62 89
Lisbon tin 63 96
London dyes 100 146
London tin 91 145
London tin 92 147
London wool 95 146
Magdeburg timber 150 143
Magdeburg timber 150 147
Marrakesh iron 54 54
Marrakesh iron 61 56
Marseille dyes 120 102
Marseille wine 121 101
Metz grain 127 130
Metz iron 128 136
Metz iron 129 136
Metz iron 129 131
Metz timber 131 133
Miccosukee coal 24 179
Miccosukee tobacco 16 179
Milan textiles 138 110
Milan textiles 140 110
Moscow furs 237 178
Moscow furs 246 173
Moscow timber 238 172
Mosul cotton 279 80
Mosul cotton 284 77
Naples grain 164 83
Naples wool 154 86
Naples wool 162 85
Nicaea silk 218 86
Nicaea silk 219 90
Nicosia marble 240 64
Nottingham dyes 108 153
Nottingham wool 102 155
Nottingham wool 110 154
Novgorod amber 198 175
Novgorod furs 205 176
Novgorod furs 207 183
Novgorod timber 223 172
Nuremburg iron 149 134
Nuremburg timber 145 133
Nuremburg tin 148 130
Nuremburg wine 142 135
Oslo amber 139 185
Oslo fish 133 178
Oslo fish 137 181
Oslo furs 138 186
Oslo iron 135 181
Oslo timber 138 184
Oslo timber 146 183
Palermo amber 148 68
Palermo cotton 157 63
Palermo sugar 154 64
Palermo sulfur 153 67
Pamplona marble 93 107
Pamplona wool 95 105
Prague coal 158 135
Prague timber 159 136
Prague tin 159 131
Rennes grain 94 128
Rennes wine 98 126
Rheims coal 122 129
Rheims iron 120 126
Rheims timber 119 131
Rhodes wine 213 64
Riga amber 184 171
Riga amber 191 176
Ryazan timber 252 161
Sarkel slaves 258 133
Sophia timber 197 103
Staufen wine 135 131
Stockholm amber 152 170
Stockholm amber 162 174
Stockholm furs 153 177
Stockholm furs 159 177
Stockholm iron 160 178
Stockholm iron 166 186
Stockholm silver 162 184
Stockholm slaves 167 182
Stockholm timber 157 168
Tbilisi slaves 281 110
Tenochtitlan chocolate 2 112
Tenochtitlan chocolate 2 122
Tenochtitlan chocolate 7 124
Tenochtitlan dyes 1 119
Tenochtitlan gold 4 113
Tenochtitlan gold 4 118
Tenochtitlan gold 10 128
Tenochtitlan silver 4 123
Tenochtitlan tobacco 5 117
Tenochtitlan tobacco 6 124
Tenochtitlan tobacco 7 137
Thessalonika marble 195 73
Thessalonika sulfur 189 87
Thessalonika timber 185 92
Timbuktu gold 67 4
Timbuktu gold 78 2
Timbuktu ivory 62 5
Timbuktu ivory 86 2
Timbuktu slaves 74 11
Tlaxcala dyes 9 150
Tlaxcala gold 0 140
Tlaxcala gold 5 143
Tlaxcala tobacco 1 149
Tlaxcala tobacco 6 149
Toledo iron 80 93
Toledo iron 85 89
Toulouse dyes 113 103
Toulouse iron 110 105
Trebizond silver 249 101
Trebizond sulfur 247 100
Tripoli fish 154 38
Tunis iron 131 58
Venice textiles 146 110
Venice textiles 152 107
Vienna dyes 161 113
Vienna dyes 161 121
Vienna iron 160 127
Vienna silver 158 121
Vienna silver 159 117
Vienna timber 163 120
Vilnius amber 186 160
Vilnius amber 189 166
York coal 100 164
York coal 107 162
York iron 105 168
York wool 106 163
Zagreb gold 172 99
Zagreb iron 158 110
Zagreb iron 167 104
Zagreb timber 180 105
Zaragosa iron 94 99