...
- The first step requires us to create multiple CSV files. Each CSV file will correspond to an independent geolocation technique. Open a spreadsheet already created and copy target IPs and error distance columns into a new spreadsheet and save it as a CSV (.csv) file. Name it against the geolocation technique such as apollonius.csv for Apollonius. Table 2 below shows geolocation technique against its file name. Click on the file name to download and view the file.
- Put these under a csv directory. Put the csv directory and Node_info.txt file alongside CreateCSVForComparison.pl script. Table 3 below provides links to these files.
- Execute CreateCSVForComparison.pl script. This will generate all-analysis.csv file containing data in the following format. This will contain all data including null value for those targets for which a geolocation technique didn't find any estimate results. The name of each technique represents column of error distance values.
- Open this all-analysis.csv file and convert this to a spreadsheet for analysis.
Code Block | ||||
---|---|---|---|---|
| ||||
serial no, hostname, ip, region, apollonius, cbg_multi, cbg_tri, cbg_with_apollonius, soi, sping, tbg, tbg_updated, tulip_imp, tulip_old |
Table 2 below showing list of csv files.
Geolocation technique | File name |
---|---|
Apollonius | apollonius.csv |
CBG with multilateration | cbg-multilateration.csv |
CBG with trilateration | cbg-trilateration.csv |
CBG with Apollonius | cbg-with-apollonius.csv |
Speed of Internet (SOI) | soi.csv |
SPing | sping.csv |
TBG | tbg.csv |
TBG Updated | tbg-updated.csv |
TULIP trilateration improved | tulip-trilateration-improved.csv |
TULIP trilateration old | tulip-trilateration-old.csv |
Table 3 below provides links to the files above in csv directory, Node_info.txt file, all-analysis.csv file and CreateCSVForComparison.pl script.
File | Description |
---|---|
csv directory | Contains all the csv files. |
Node_info.txt | Contains information such as hostname, IP addresses, Regions, Lat/Longs, etc. for 182 targets. |
all-analysis.csv | An amalgamation of all the geolocation techniques and their error distances against the IP addresses and other information. The format is shown above in the box titled "data format of all-analysis.csv". |
CreateCSVForComparison.pl | Script that takes csv files from csv directory and Node_info.txt file as inputs and processes out all-analysis.csv file as output. |
To do: Upload these files and paste links here once work on geolocation paper is completed.
Known issues
Output file formatting issues:
...