How to modify or create new data for map

Select map, change orientation

To see data for a country, you can
* click on this country
* navigate through cards

You can modify all values, click on value, you get a cursor and you can edit this value with keyboard
For country's center coordinates, you can also move red circle to get new values for xc and yc. 

In left part, you can change name for data ( not apply to Name, xc and yc )

When you click on "Remove data", fields that you can remove are covered by sensitive area,
you click on field to remove. 
You need to confirm before data would be removed for all countries.

You can use CSV or text file to put new data or modify existing field's values.

See for detailled example in next section..

Create a new map : Benelux

  Load svg map with areas as paths

Arrange areas

Put in external area neighbouring countries

  

Join areas for Nederland

    

   You get three countries and an external area

You can edit
* map's name
* map's root for tables names
* name for selected country

You get this new map in tool

You have the three fields Name, xc and yc
You can edit this values or move red circle to change xc and yc for this country

This new map is part of your database and you can add new fields with "Add data"

Using file for data ( CSV or text file )

In this example, we use data from European Union

Step 1 : select lines 

For our example, we check lines for the three countries
( Upper check select/deselect all lines )

Step 2 : select colums for data

We check values for population

Step 3 : bind data and country

We check the column as it's a new field for our map
To affect data to current country, you can check before country's name.
You can change current country by click on it or through cards outside this window..

We get new field, we give a name

If you use values for existing field, you get scrolling list to choose field for this values :

Store data in MySQL database

  You can save modifications to database as file of SQL commands

This file is in sql directory and his name is sql_<root>.txt ( sql_benelux.txt for example given )
You can in phpMyAdmin or another interface copy this file in a SQL command window and verify 

  Modifications or new map with data are stored in database

This need that you modify your rights on local MySQL database.
When you modify data, tables are dropped and recreated from new values.

Some details on MySQL tables

Table " pays "

This table store maps that you can use in statistical maps tool
For each map, Name, root, width, height and data names with ";" as separator

We have two tables for each map

The paths in table " racine_carte "

Four values, x y width and height for viewBox attribute,
then areas number ( 54),
then value for "d" attribute for each area,
and eventually at the end value for "d" attribute for external areas ( neighbouring countries )

Data in table " racine_data "

The first record give number of data after Name xc and yc, origin for coordinates and name for each data  

A record by country give values for Name xc yc and then other data

When we create a new map
* we add a record to table "pays"
* we create table " racine_carte " from paths for map
* we create table " racine_data " from data

You can use phpMyAdmin or another interface to work on database without this tool.