Menu

Sputnik project is RFID trasking project build using open source and open hardware.

Sputnik data from 24c3

Image of Sputnik sequence Tag used by Milosz for testing.
Image of Sputnik sequence Many resets. Maybe broken tag, or conductive clothing, or someone was playing with battery.
Image of Sputnik sequence Very strange. It looks like two sequences. My algorithm would also not create something like that. But was it really packets from one tag?
Image of Sputnik sequence Someone did not leave BCC for entire 24c3! Sequence with the most readings.
Image of Sputnik sequence Tag was not switched off (straight line). Either one was in BCC on first and last day, or held tag in foil.
Image of Sputnik sequence Many resets. Maybe broken tag, or conductive clothing, or someone was playing with battery.
Image of Sputnik sequence Again strange values of counter.
Image of Sputnik sequence Again someone was constantly in BCC, but bought tag in the dawn on third day.
Image of Sputnik sequence Buy, check that it works, switch it off.
Histogram of Sputnik sequences Histogram of Sputnik sequences.
Number of readings seen by two stations at the same time Number of readings seen by two stations at the same time.
Comparison of Sputnik activities during 23c3 and 24c3 Comparison of Sputnik activities during 23c3 and 24c3.

Entire data set consists of 27906450 rows, starting at 2007-12-27 20:51:02 and ending at 2007-12-30 23:05:34. There is 195350 packets with pressed button and 27711100 without.

StrengthCount
08669189
17103390
26637093
35496778
StationCount
D02114263
E021121923
J019169586
I014216645
I005241902
B001249056
I001306798
F012358423
C007360192
C150367488
E006386077
H019400255
J013404046
H011434331
H017518719
C005527254
F002527559
D015627286
D005635220
D003643391
B007646735
G002714648
C023756742
E013777346
F017812258
G022865833
C006896983
E017927321
G016952442
D0111038472
D0101328710
D0011332173
A1001505484
F0111514886
G0211611091
C0121922227
C0152792685

Strange packets

IDTimeSequenceStationStrengthButton
488902482007-12-29 05:35:10+011600630272B00721
488902482007-12-29 05:35:10+011600630272G00221
4880195902007-12-27 21:54:43+013365413523J01921
7369465182007-12-27 21:51:12+012874998078G02101
9713173442007-12-30 00:33:25+012957409349E01301
13180305212007-12-30 01:40:05+011539444419E01711
13180305212007-12-30 01:40:05+011539444419E01311
14434186382007-12-29 15:10:35+011176705156A10020
14434186382007-12-29 15:10:35+011176705156G02120
14434186382007-12-29 15:10:35+011176705156F01120
14802751802007-12-28 23:24:45+01612987063D01100
21124980032007-12-28 18:32:23+013865858549C01521
24364278292007-12-29 20:33:39+01862701512F00220
26704717392007-12-28 01:20:38+01491957119D00320
30715512412007-12-28 01:03:59+012407769040I01411
30715512412007-12-28 01:03:59+012407769040H01711
30715512412007-12-28 01:03:59+012407769040I00111
30715512412007-12-28 01:03:59+012407769040H01911
33324890782007-12-28 21:18:42+01828623814C01500
33324890782007-12-28 21:18:42+01828623814C02300
34333082142007-12-29 03:37:48+013439861472D00321
34333082142007-12-29 03:37:48+013439861472D01021
41615583572007-12-28 18:36:29+012950474390C01210

Import and export

SQL script to create all tables in PostgreSQL neccessary to analyze Sputnik data: create.sql

Programs to import and export binary data to and from PostgreSQL database: ImportBinary.c and ExportBinary.c

Program to import 3D XML data into database: ImportXML.py

Program to import XML CCC schedule into database: ImportSchedule.py

Recovering of lost sequences from 23c3

Talk from 24C3

Article from 24C3 describing rebuilding of lost sequences from 23C3.

Program to visualise position data read from XML file. VisualizeXML.py VisualizeXML.glade

Screenshot of visualization program

Latest version of script used to guess missing sequences IDs: guess.py and needed stored procedures (run as PostgreSQL administrator, usually postgres): create-aggregate.sql

Guessed sequences in binary format (24MB): sputnik.dat.gz

Scatter plots of chosen generated sequences

Some may be incorrect, but are interesting nonetheless.

First attempt












Second attempt













Third attempt













Different tools

Program read "pings" from tags via USB reader and put them into a database: reader.py

Program to check whether user can access functionality basing on his Sputnik tag: login.py

External links

Main page of Sputnik

Page with analysis

Page with analysis