♒ Chess spectrum

[programarivm]

The chess spectrum of a game is the range of heuristic evaluation features contained by a signal. Similarly to sound and visible light, the evaluation features can be ordered by frequency of appearance in the ChesslaBlab database. This information is currently unknown. When available, it would be appropriate to arrange the evaluation features in the Chess\Function namespace as per the chess spectrum.

Keep it up,

[programarivm]

• ∑ Return the average sum of an evaluation feature chess-data#71

[programarivm]

mysql> select count(*) from games where heuristics_mine is not null;
+----------+
| count(*) |
+----------+
|     3004 |
+----------+
1 row in set (0.12 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 0), 2) as material_count;
+----------------+
| material_count |
+----------------+
|          15.03 |
+----------------+
1 row in set (0.21 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 1), 2) as center_count;
+--------------+
| center_count |
+--------------+
|        25.28 |
+--------------+
1 row in set (0.21 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 2), 2) as connectivity_count;
+--------------------+
| connectivity_count |
+--------------------+
|               -6.3 |
+--------------------+
1 row in set (0.19 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 3), 2) as space_count;
+-------------+
| space_count |
+-------------+
|       26.92 |
+-------------+
1 row in set (0.22 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 4), 2) as pressure_count;
+----------------+
| pressure_count |
+----------------+
|           4.62 |
+----------------+
1 row in set (0.20 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 5), 2) as king_safety_count;
+-------------------+
| king_safety_count |
+-------------------+
|              8.22 |
+-------------------+
1 row in set (0.22 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 6), 2) as protection_count;
+------------------+
| protection_count |
+------------------+
|            -0.61 |
+------------------+
1 row in set (0.19 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 7), 2) as discovered_check_count;
+------------------------+
| discovered_check_count |
+------------------------+
|                   0.54 |
+------------------------+
1 row in set (0.18 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 8), 2) as doubled_pawn_count;
+--------------------+
| doubled_pawn_count |
+--------------------+
|               2.12 |
+--------------------+
1 row in set (0.19 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 9), 2) as passed_pawn_count;
+-------------------+
| passed_pawn_count |
+-------------------+
|              7.19 |
+-------------------+
1 row in set (0.19 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 10), 2) as advanced_pawn_count;
+---------------------+
| advanced_pawn_count |
+---------------------+
|               15.39 |
+---------------------+
1 row in set (0.20 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 11), 2) as far_advanced_pawn_count;
+-------------------------+
| far_advanced_pawn_count |
+-------------------------+
|                    3.67 |
+-------------------------+
1 row in set (0.18 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 12), 2) as isolated_pawn_count;
+---------------------+
| isolated_pawn_count |
+---------------------+
|                1.76 |
+---------------------+
1 row in set (0.22 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 13), 2) as backward_pawn_count;
+---------------------+
| backward_pawn_count |
+---------------------+
|                2.92 |
+---------------------+
1 row in set (0.21 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 14), 2) as defense_count;
+---------------+
| defense_count |
+---------------+
|           1.7 |
+---------------+
1 row in set (0.19 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 15), 2) as absolute_skewer_count;
+-----------------------+
| absolute_skewer_count |
+-----------------------+
|                     0 |
+-----------------------+
1 row in set (0.18 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 16), 2) as absolute_pin_count;
+--------------------+
| absolute_pin_count |
+--------------------+
|                  1 |
+--------------------+
1 row in set (0.18 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 17), 2) as relative_pin_count;
+--------------------+
| relative_pin_count |
+--------------------+
|               0.69 |
+--------------------+
1 row in set (0.18 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 18), 2) as absolute_fork_count;
+---------------------+
| absolute_fork_count |
+---------------------+
|                0.07 |
+---------------------+
1 row in set (0.18 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 19), 2) as relative_fork_count;
+---------------------+
| relative_fork_count |
+---------------------+
|                0.88 |
+---------------------+
1 row in set (0.18 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 20), 2) as square_outpost_count;
+----------------------+
| square_outpost_count |
+----------------------+
|                14.59 |
+----------------------+
1 row in set (0.19 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 21), 2) as knight_outpost_count;
+----------------------+
| knight_outpost_count |
+----------------------+
|                 1.27 |
+----------------------+
1 row in set (0.18 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 22), 2) as bishop_outpost_count;
+----------------------+
| bishop_outpost_count |
+----------------------+
|                 1.18 |
+----------------------+
1 row in set (0.18 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 23), 2) as bishop_pair_count;
+-------------------+
| bishop_pair_count |
+-------------------+
|             -1.06 |
+-------------------+
1 row in set (0.18 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 24), 2) as bad_bishop_count;
+------------------+
| bad_bishop_count |
+------------------+
|             0.93 |
+------------------+
1 row in set (0.19 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 25), 2) as diagonal_opposition_count;
+---------------------------+
| diagonal_opposition_count |
+---------------------------+
|                     -0.02 |
+---------------------------+
1 row in set (0.18 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 26), 2) as direct_opposition_count;
+-------------------------+
| direct_opposition_count |
+-------------------------+
|                    0.03 |
+-------------------------+
1 row in set (0.20 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 27), 2) as overloading_count;
+-------------------+
| overloading_count |
+-------------------+
|              0.29 |
+-------------------+
1 row in set (0.18 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 28), 2) as back_rank_count;
+-----------------+
| back_rank_count |
+-----------------+
|           -0.01 |
+-----------------+
1 row in set (0.18 sec)

mysql> SELECT ROUND(EVAL_ARRAY_COUNT('1-0', 29), 2) as flight_square_count;
+---------------------+
| flight_square_count |
+---------------------+
|               13.81 |
+---------------------+
1 row in set (0.21 sec)