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.