home
  • View
    • Basic Search
    • Advanced Search
    • Map
  • Uploads
  • Info
    • Android App
    • FAQ
    • App FAQ
    • Forums
    • Twitter
  • Stats
  • Tools
    • Downloads
    • API
    • Account
    • CSV Upload
  • Login
    • Forgot your password?
      New? Register

WiGLE CSV Format v1.4


WiGLE has adopted a simple modified comma-separated-value (CSV) format for wireless network observation upload through it's client as well as for a data interchange format. This is simple, mostly-human-readable format that allows us to reliably accept data from multiple software packages. The WiGLE CSV format adheres to UTF-8 encoded rfc4180 for the most part, however we require a pre-header row containing client specification before the CSV-standard header definition. Most full-featured CSV generators/parsers can be set to prepend/ignore this row by default.

Pre-header (Device)

Description

[Format version],appRelease=[version],model=[device model],release=[device release],device=[device name],display=[device dispaly characteristics],board=[device board descriptor],brand=[device brand]

Example

WigleWifi-1.4,appRelease=2.53,model=X-37B,release=11.0.0,device=felgercarb,display=OPSPLS1.76-1-S,board=snodgrass,brand=Moog

Details

Field Name Description Example
Format version Current format - treat this as fixed for the version you've selected to implement WigleWifi-1.4
appRelease The current release of the application creating this CSV 2.53
model The device model measuring these signals X-37B
release The device OS version 11.0.0
device The device name/codename felgercarb
display The device display if present OPSPLS1.76-1-S
board The device core circuit board/processor version snodgrass
brand The device brand Moog

Header

Description/Example

MAC,SSID,AuthMode,FirstSeen,Channel,RSSI,CurrentLatitude,CurrentLongitude,AltitudeMeters,AccuracyMeters,Type

The header is a fixed ordered set describing the columns following. It is somewhat overloaded to accommodate cell (both CDMA and GSM variants) and bluetooth, but has been maintained for purposes of backward compatability.

WiFi Rows

Description

[BSSID],[SSID],[Capabilities],[First timestamp seen],[Channel],[RSSI],[Latitude],[Longitude],[Altitude],[Accuracy],[Type]

Example

1a:9f:ee:5c:71:c6,Scampoodle,[WPA2-EAP-CCMP][ESS],2018-08-01 13:08:27,161,-43,37.76578028,-123.45919439,67,3.2160000801086426,WIFI

Details

Field Name Description Example
BSSID Basic Service Set Identifier - hardware address 1a:9f:ee:5c:71:c6
SSID Service Set Identifier - the access point name Scampoodle
Capabilities Capabilities array as specified by package. Based on Android capabilities sets. [WPA2-EAP-CCMP][ESS]
First timestamp seen First timestamp seen in SQL seconds-precision time format (YYYY-MM-DD hh:mm:ss), assumes UTC 2018-08-01 13:08:27
Channel Integer channel vaule for the observed signal 161
RSSI Received Signal Strength Indicator (RSSI) as reported by the radio -43
Latitude Observed latitude in decimal (degrees.decimal degrees) format 37.76578028
Longitude Observed longitude in decimal (degrees.decimal degrees) format -123.45919439
Altitude Estimated position altitude in integer meters 67
Accuracy Estimated position accuracy in decimal meters 3.2160000801086426
Type The device type - always WIFI for WiFi networks currently WIFI

Cell Rows

Description

[Cell Key],[Network Name],[Capabilities],[First timestamp seen],[Frequency],[RSSI],[Latitude],[Longitude],[Altitude],[Accuracy],[Type]

Example

310410_56967_4118917,AT&T Mobility,WCDMA;310410,2018-08-03 18:14:15,4385,-81,37.72090053,-122.44579219,104,34.30400085449219,WCDMA

Details

Field Name Description Example
Cell Key Composite Identifier - depends on network type:
For CDMA:[System]_[Network]_[Base Station]
For GSM:[Operator*]_[LAC]_[Cell ID]
For WCDMA:[Operator*]_[LAC]_[Cell ID]
For LTE:[Operator*]_[LAC]_[Cell ID]


*Operator: for GSM-derived networks this is MCCMNCconcatenated to a 6 digit format. MCC and MNC are searchable through the WiGLE API via the https://api.wigle.net/api/v2/cell/mccMnc endpoint.
310410_56967_4118917
Network Name For GSM/WCDMA/LTE: reported MCCMNC lookup vaule if available, otherwise reported network name from radio/SIM. For CDMA: reported network name from radio. AT&T Mobility
Capabilities For GSM/WCDMA/LTE: Network type + ; + MCC+MNC (operator value)
For CDMA: Network type + ; + System
WCDMA;310410
First timestamp seen First timestamp seen in SQL seconds-precision time format (YYYY-MM-DD hh:mm:ss), assumes UTC 2018-08-01 13:08:27
Frequency Integer center frequency value depending on network type:
For CDMA:0
For GSM:Observed ARFCN
For WCDMA:Observed UARFCN
For LTE:Observed EARFCN
4385
RSSI Received Signal Strength Indicator (RSSI) as reported by the radio -81
Latitude Observed latitude in decimal (degrees.decimal degrees) format 37.72090053
Longitude Observed longitude in decimal (degrees.decimal degrees) format -122.44579219
Altitude Estimated position altitude in integer meters 104
Accuracy Estimated position accuracy in decimal meters 34.30400085449219
Type The device type - always one of CDMA, WCDMA, GSM or LTE. WCDMA

Bluetooth Rows

Description

[BD_ADDR],[Device Name],[Capabilities],[First timestamp seen],[Channel],[RSSI],[Latitude],[Longitude],[Altitude],[Accuracy],[Type]

Example

63:56:ac:c4:d4:30,,Misc [LE],2018-08-03 18:14:12,0,-67,37.76090571,-122.44877987,104,49.3120002746582,BLE

Details

Field Name Description Example
BD_ADDR Bluetooth Device Address - hardware address 1a:9f:ee:5c:71:c6
Device Name The published name of the blueooth device if available Jabra Headset
Capabilities List; includes the device type list if provided, and optionally [BT] or [BLE] enclosed in square brackets to describe the first scan type detecting the device. Misc [LE]
First timestamp seen First timestamp seen in SQL seconds-precision time format (YYYY-MM-DD hh:mm:ss), assumes UTC 2018-08-01 13:08:27
Channel 0 for Bluetooth devices 0
RSSI Received Signal Strength Indicator (RSSI) as reported by the radio -67
Latitude Observed latitude in decimal (degrees.decimal degrees) format 37.73090571
Longitude Observed longitude in decimal (degrees.decimal degrees) format -122.42877987
Altitude Estimated position altitude in integer meters 104
Accuracy Estimated position accuracy in decimal meters 49.3120002746582
Type The device type - always BT or BLE for Bluetooth or BTLE devices respectively BLE
Social
  • Wiki
  • Twitter
  • IRC
Site Information
  • FAQ
  • End-User Agreement
  • Privacy
  • Our ToDo List
/dev/random
  • Cafepress Gear
  • Links
user management
  • Reset Password
  • Register
News
  • Forums
  • News RSS
  • Stats RSS

WiGLE respects your privacy. To have records of your access point removed from our database, or if you have any questions or suggestions, send an email to: WiGLE-admin[at]WiGLE.net (please include BSSID (MAC) in removal requests). We're also on IRC: at WiGLE.net:6667

Copyright 2001-2022 bobzilla && arkasha && uhtu

×
×

×
Join WiGLE ×