Commands? Please refer to here
- Export the file from GM
- Add a new column called "block"
- Use Regex command
ponto (9,|3,|37,|8,|12,|13,|16,|17,)
to select multiple markers then, add an indicator for the block (it has to be a number), it will be like:
WKT,nome,block
"POINT (144.9517062 -37.8133123)",Ponto 3,1
- if you are using VSCode, you can use crtl+shift+l
IMPORTANT
- beware the "lines" or "ponto" in other languages
- the script only generates ONE proxy per block
- note that the column WKT of Gmaps uses the format LONGITUDE and LATITUTE, as described in the scripts
- Run
node maps-fog-nodes-to-simulator
to generate the formated file
The output should be as follows:
ID,Latitude,Longitude,Block,Level,Parent,State,Details
0,-37.8136,144.9631,0,0,-1,VIC,Cloud Data Center
I recommend to check if everything is fine in GMaps. After testing and importing the file there, it will be something like:
WKT,ID,Latitude,Longitude,Block,Level,Parent,State,Details
"POINT (144.9631 -37.8136)",0.0,-37.8136,144.9631,0.0,0.0,-1.0,VIC,Cloud Data Center
"POINT (144.9517062 -37.8133123)",1.0,-37.8133123,144.9517062,1.0,1.0,0.0,VIC,Block 1 Proxy
If everything is fine, you can format it by using the following steps
- Delete the first column
- Delete the floating points, just in case
- you can use vs codes shortcut for this
- Hour file is ready!
- Export the file from GM
- check if your file is in the following format:
WKT,nome,
"POINT (144.95362 -37.81282)",Ponto 1,
- Run
node maps-walks-to-simulator.js
The output should be as follows:
Latitude,Longitude
-37.81282, 144.95362
I recommend using the Rainbown CSV in VSCode.
RBQL:
select a4, count (a4) group by a4 --> count blocks for exp1 and exp2
Happy simulation!
- @vyk