wff2csv

Convert WiFiFoFum KML files to CSV logs (e.g. for data visualization)

I had a homework assignment in a security class to just go wardriving and see what interesting patterns could be found. With an old iPhone 3GS I got got for $15, I just drove around town and collected hotspot data and geolocations. However, I couldn’t interact with it the way I wanted… So, I wrote this to convert the KML-ish output to a CSV that can be used for data visualization.

Usage

Convert the WiFiFoFum KML files to a CSV:

$ wff2csv WiFiFoFum_Log_586.kml > wifi.csv

Outputs these fields:

ESSID
MAC Address
Channel
Security
Type
Latitude
Longitude
Elevation

Then, you can choose your own way of dealing with data. For example, you can easily create a visualization using Google My Maps:

Example screenshot

API

If you want to write a different conversion (e.g. to JSON), there is a separate wffParser.js file you can take advantage of.

Parse a WFF KML file:

// parser is installed with wff2csv
const wffParser = require('wff2csv/wffParser')
const wifiData = wffParser
  .parseFile('WiFiFoFum_Log_586.kml')
  .then(data => console.log(data))

Logs:

[{
  essid: '',
  macAddress: '',
  channel: '',
  security: '',
  type: '',
  latitude: '',
  longitude: '',
  elevation: ''
}]

Install

With npm installed:

Install for system-wide usage:

$ npm install -g wff2csv

Install for API/parser usage:

$ npm install --save wff2csv

License

MPL-2.0