DOI: 10.21227/sgfx-d159
title: CRAWDAD ilesansfil/wifidog

description: Dataset of user session traces collected from Wi-Fi hotspots for six years. This data set contains user session traces which were collected from a large number of free Wi-Fi hotspots in Montreal, Quebec, Canada for six years.date/time of measurement start: 2004-08-28date/time of measurement end: 2010-03-07collection environment: User session traces which were collected from a large number of free Wi-Fi hotspots in Montreal, Quebec, Canada for six years.network configuration: WifiDog is composed of the following 2 components: - the gateway is a daemon process that gets installed on every wireless router on a hotspot. - the auth server is a web application that gets installed in a central location. WifiDog enables a new hotspot site to configure the equipment by just plugging it in the existing network and entering the new router password. Existing networks, such as DSL and cable connections, have proven rather unreliable, so WifiDog makes monitoring easier in the following ways:- it graphically displays the status and location of each hotspot (see http://carte.ilesansfil.org/). - in case of fault, it sends mail to local support resources assigned to that hotspot. - it is completely unaffected by network address translation or firewalls upstream. - finally it does all this without any extra software (VPN, SNMP, etc).data collection methodology: The ISF team collects user session (i.e., between login and logout) data such as account (user) id, MAC address, login and logout time, hotspot id, and amount of data transferred incoming and outgoing. They also logs content display and click-through, but only for content being displayed on the auth server, and therefore the data are not included in this data set.sanitization: The ISF team anonymized account id (user_id), connection id (conn_id), user MAC address (user_mac), and hotspot id (node_id). They performed hashing with a different random seed for every value. The code that generated the anonymised data can be found athttp://dev.wifidog.org/browser/trunk/wifidog-auth/wifidog/classes/StatisticReport/AnonymisedDataExport.phpTracesetilesansfil/wifidog/sessionThis traceset contains user sessions which were collected from a large number of free Wi-Fi hotspots in Montreal, Quebec, Canada for six years.file: isf_wifidog_anonymised_data_nogeo_2004-08-27_2010-03-07.csv.gz, isf_wifidog_anonymised_data_nogeo_2004-08-27_2010-03-07.sql.gzmeasurement purpose: Usage Characterizationmethodology: When a user connects to a gateway installed on a wireless router, the gateway opens a session on the auth server (that knows what hotspot the user is connecting from), the auth server assigns a session number (connection id) and gives it to the gateway. The gateway then counts the in and out traffic transferred during that session, and periodically sends it to the auth server for each connected user. Therefore, no merge of data from different hotspots is necessary, the only place data is logged is on the auth server.ilesansfil/wifidogTrace session/04_10 : User session traces which were collected from a large number of free Wi-Fi hotspots in Montreal, Quebec, Canada for six years.format: The trace includes postgresql compatible file of SQL statements. The table created has the same column names, and the same datatype as the real data. The table schema is  as follows:CREATE TABLE connections_anonymised(conn_id text NOT NULL,timestamp_in timestamp,node_id text,timestamp_out timestamp,user_id text NOT NULL DEFAULT '',user_mac text,incoming int8,outgoing int8);where conn_id :  connection idtimestamp_in : login time node_id : hotspot id timestamp_out : logout time user_id : user account id user_mac : user MAC address incoming : incoming data transferred (Bytes) outgoing : outgoing data transferred (Bytes)