search

transistorsoft / background-geolocation-console

A field-testing & analysis server for the Background Geolocation plugin
MIT License
150 stars 157 forks source link

Sample data not included #44

Open bf4 opened 6 years ago

bf4 commented 6 years ago

scripts/json2csv.rb references file = File.open("./geolocation-data.json")

Any way we can get a copy of that json file in the repo somehow?

christocracy commented 6 years ago

That was just a one-off script I used to generate location-data for a blog-entry. That script wasn't supposed to be committed. I see no need for sample-data in the repo.

bf4 commented 6 years ago

Oh, would just be nice to see what the data looks like. (Thanks for the quick response)

I just looked at https://github.com/transistorsoft/background-geolocation-console/blob/master/src/server/database/background-geolocation.db.bak?raw=true and got a dump from that

background-geolocation.sql

background-geolocation.csv.xlsx

"id","uuid","device_id","device_model","latitude","longitude","accuracy","altitude","speed","heading","odometer","event","activity_type","activity_confidence","battery_level","battery_is_charging","is_moving","geofence","provider","extras","recorded_at","created_at"
"1","287cbbe2-8b98-4576-8435-c5a5e711b54a","ReactNative-a76924c11115eb8b","Pixel (ReactNative)","45.5185201","-73.617955","113.2","46.0","-1.0","299.0","2956.2","","still","100","1.0","1","1","","","{}","2017-04-12T17:54:06.000Z","1492019766138"
"2","cef75633-78d9-4374-89b1-cb26748b5106","ReactNative-a76924c11115eb8b","Pixel (ReactNative)","45.5192773","-73.6170103","19.9","45.0","-1.0","299.0","2956.5","","still","100","1.0","1","1","","","{}","2017-04-12T17:54:36.000Z","1492019766315"
"3","b60ac68f-ff0c-496a-9427-9b4e83d95063","ReactNative-a76924c11115eb8b","Pixel (ReactNative)","45.5192747","-73.6170143","10","44.0","-1.0","-1.0","2956.5","motionchange","still","100","1.0","1","0","","","{}","2017-04-12T17:55:59.669Z","1492019766394"
"4","3714ed05-8b99-4d7e-8465-46f0419e300e","ReactNative-a76924c11115eb8b","Pixel (ReactNative)","45.5192748","-73.6170141","10","44.0","-1.0","-1.0","2956.9","motionchange","still","100","1.0","1","1","","","{}","2017-04-12T17:56:00.666Z","1492019766472"
"5","de39019a-767d-4444-9640-9b1135bc1b72","ReactNative-a76924c11115eb8b","Pixel (ReactNative)","45.5192753","-73.6170136","10","-1.0","-1.0","-1.0","2956.9","motionchange","still","100","1.0","1","0","","","{}","2017-04-12T17:56:01.999Z","1492019766549"
"6","D1B48386-CB5C-4B44-9ABB-5AF032076009","Cordova-43270678-0F41-48C1-B647-49C4226B6EA0","iPhone8,1 (Cordova)","45.5192759167827","-73.616872709313","50","76.4","0.0","-1.0","3717.9","motionchange","still","100","1.0","1","0","","","{}","2017-04-12T16:55:18.000Z","1492019996041"
"7","0E941E38-6F4A-41A8-82CF-65196662C42B","Cordova-43270678-0F41-48C1-B647-49C4226B6EA0","iPhone8,1 (Cordova)","45.5192331809583","-73.6168758537481","65","75.8","-1.0","-1.0","3724.0","motionchange","still","100","1.0","1","1","","","{}","2017-04-12T17:59:52.528Z","1492019996071"
"70","BF9828B8-50E0-47D2-B701-0EC9537639F5","ReactNative-CD64F7EB-F3FB-4C01-8B0C-75A480D5400F","iPhone 6s (ReactNative)","45.5192833486263","-73.6169273760565","65","75.6","-1.0","-1.0","3684.7","motionchange","unknown","100","1.0","1","0","","","{}","2017-04-12T18:01:16.718Z","1492026811329"
"71","9CFFC5E7-E3FA-4337-9EB7-162DDA00E64C","ReactNative-CD64F7EB-F3FB-4C01-8B0C-75A480D5400F","iPhone 6s (ReactNative)","45.5207802588544","-73.6165661831141","10","73.2","1.76","3.87","0.0","geofence","on_foot","100","1.0","0","0","{""identifier"":""Jfk"",""extras"":{""center"":{""longitude"":-73.61569021334856,""latitude"":45.52206705924803},""radius"":200},""action"":""DWELL""}","","{}","2017-04-12T18:54:05.000Z","1492026811363"
"72","485E0CBE-44C0-4240-9398-9DE3367AC9AC","ReactNative-CD64F7EB-F3FB-4C01-8B0C-75A480D5400F","iPhone 6s (ReactNative)","45.5210611783392","-73.6160553061158","10","66.1","1.31","137.46","207.8","motionchange","on_foot","100","1.0","0","1","","","{}","2017-04-12T18:54:22.773Z","1492026811391"
"73","A2A71FF2-28B9-4C01-BB01-196167D6B595","ReactNative-CD64F7EB-F3FB-4C01-8B0C-75A480D5400F","iPhone 6s (ReactNative)","45.5212807003833","-73.6154773738921","10","68.0","1.37","25.31","259.2","","on_foot","100","1.0","0","1","","","{}","2017-04-12T18:55:18.000Z","1492026811413"
"74","DDD765D1-FDF3-4188-9799-518BF5D52165","ReactNative-CD64F7EB-F3FB-4C01-8B0C-75A480D5400F","iPhone 6s (ReactNative)","45.5216558324597","-73.6151048821151","10","69.5","1.45","26.02","310.0","","on_foot","100","1.0","0","1","","","{}","2017-04-12T18:55:48.000Z","1492026811439"
"75","51B60C02-F16B-468F-8E20-19DF97C68F43","ReactNative-CD64F7EB-F3FB-4C01-8B0C-75A480D5400F","iPhone 6s (ReactNative)","45.5215505557559","-73.6144713778734","10","71.6","1.8","99.49","360.9","","on_foot","100","1.0","0","1","","","{}","2017-04-12T18:56:21.000Z","1492026811467"
"76","A6F4716D-01C6-4630-88B5-1C6BE5DF586F","ReactNative-CD64F7EB-F3FB-4C01-8B0C-75A480D5400F","iPhone 6s (ReactNative)","45.5213770084507","-73.6135986541152","30","75.7","0.0","-1.0","431.7","motionchange","still","33","1.0","0","0","","","{}","2017-04-12T18:58:52.000Z","1492026811496"
"77","152484A7-6DA6-41EC-B6DA-42F21FC776C8","ReactNative-CD64F7EB-F3FB-4C01-8B0C-75A480D5400F","iPhone 6s (ReactNative)","45.5202501453883","-73.6114264839083","10","78.4","1.77","117.42","642.6","motionchange","on_foot","100","1.0","0","1","","","{}","2017-04-12T19:05:09.426Z","1492026811671"
"122","9AD1FB4B-74F0-4257-A832-9ACE77C2A11B","ReactNative-293A65E0-7253-4BF2-B5EC-D96FBE1BDE6C","iPhone 5 (ReactNative)","45.5210045166738","-73.6157238856644","30","72.0","2.12","53.44","212.1","motionchange","unknown","100","1.0","0","1","","","{}","2017-04-12T18:54:55.534Z","1492026826584"
"123","3E484045-4A76-4D9E-8BB6-4B9D3C27D311","ReactNative-293A65E0-7253-4BF2-B5EC-D96FBE1BDE6C","iPhone 5 (ReactNative)","45.5213610409252","-73.6153466162026","5","59.1","1.43","30.59","212.1","geofence","unknown","100","1.0","0","1","{""identifier"":""Jfk"",""action"":""DWELL"",""extras"":{""radius"":200,""center"":{""longitude"":-73.61556974481086,""latitude"":45.52226466831542}}}","","{}","2017-04-12T18:55:27.393Z","1492026826668"
"124","328A2864-E914-4A8D-A937-CC28F129538A","ReactNative-293A65E0-7253-4BF2-B5EC-D96FBE1BDE6C","iPhone 5 (ReactNative)","45.5213734880514","-73.6153269187302","5","57.9","1.46","37.62","263.5","","unknown","100","1.0","0","1","","","{}","2017-04-12T18:55:28.000Z","1492026826723"
"125","DE9B3741-CB7E-42CF-98BA-143BC40523DC","ReactNative-293A65E0-7253-4BF2-B5EC-D96FBE1BDE6C","iPhone 5 (ReactNative)","45.5216787569649","-73.6148422770888","5","72.6","1.29","105.82","314.3","","unknown","100","1.0","0","1","","","{}","2017-04-12T18:56:05.000Z","1492026826752"
"126","3C988460-7395-468D-809F-070770AC2AC3","ReactNative-293A65E0-7253-4BF2-B5EC-D96FBE1BDE6C","iPhone 5 (ReactNative)","45.5215023179031","-73.6142427195549","5","71.7","1.28","110.74","365.1","","unknown","100","1.0","0","1","","","{}","2017-04-12T18:56:35.000Z","1492026826814"
"127","118946E7-319A-4103-BDB3-C3A4A7F48C53","ReactNative-293A65E0-7253-4BF2-B5EC-D96FBE1BDE6C","iPhone 5 (ReactNative)","45.5214616237632","-73.6139031686574","5","77.3","0.63","166.99","392.0","","unknown","100","0.99","0","1","","","{}","2017-04-12T18:58:34.665Z","1492026826842"
"128","3BC34342-1A87-40C3-9435-2F15C4C2B405","ReactNative-293A65E0-7253-4BF2-B5EC-D96FBE1BDE6C","iPhone 5 (ReactNative)","45.5214790162123","-73.6138558109045","5","83.9","0.0","166.99","392.0","geofence","unknown","100","0.99","0","1","{""identifier"":""Laj"",""action"":""DWELL"",""extras"":{""radius"":200,""center"":{""longitude"":-73.61121512264513,""latitude"":45.52043806052276}}}","","{}","2017-04-12T18:58:56.191Z","1492026826880"
"161","193663A5-15AC-4092-A8CD-8A64465DE040","Cordova-F5278DDA-BC0D-47B6-80DA-1C16A40F2B84","iPhone5,1 (Cordova)","45.5193151824011","-73.6169239281508","65","75.5","-1.0","-1.0","86.2","motionchange","unknown","100","0.97","1","0","","","{}","2017-04-12T17:15:58.378Z","1492026850580"
"162","0D3BD261-4BD9-4DF5-90B1-8C15EB7F3F8A","Cordova-F5278DDA-BC0D-47B6-80DA-1C16A40F2B84","iPhone5,1 (Cordova)","45.5207905338406","-73.6159949300617","65","71.3","-1.0","-1.0","265.5","motionchange","unknown","100","1.0","0","1","","","{}","2017-04-12T18:54:52.836Z","1492026850611"
"163","0549C446-2B89-4414-B614-9C2E88451BB3","Cordova-F5278DDA-BC0D-47B6-80DA-1C16A40F2B84","iPhone5,1 (Cordova)","45.5207903881916","-73.6159951543541","65","71.3","-1.0","-1.0","265.5","","unknown","100","1.0","0","1","","","{}","2017-04-12T18:54:53.907Z","1492026850632"
"164","92D793DA-F09A-4981-BE9A-E7712E836BD0","Cordova-F5278DDA-BC0D-47B6-80DA-1C16A40F2B84","iPhone5,1 (Cordova)","45.5209885072387","-73.6159356963575","10","72.6","2.12","-1.0","288.0","","unknown","100","1.0","0","1","","","{}","2017-04-12T18:54:57.139Z","1492026850655"
"165","60B656F9-AD71-475D-BD14-CF00C689201A","Cordova-F5278DDA-BC0D-47B6-80DA-1C16A40F2B84","iPhone5,1 (Cordova)","45.5212578177876","-73.6154220533311","5","62.2","1.26","26.72","338.1","","unknown","100","1.0","0","1","","","{}","2017-04-12T18:55:18.000Z","1492026850716"
"166","4516B10E-AD8E-4E1D-8EB3-4DA4017B177C","Cordova-F5278DDA-BC0D-47B6-80DA-1C16A40F2B84","iPhone5,1 (Cordova)","45.5213610409252","-73.6153466162026","5","59.1","1.43","30.59","338.1","geofence","unknown","100","1.0","0","1","{""identifier"":""Jfk"",""action"":""DWELL"",""extras"":{""radius"":""200"",""center"":{""longitude"":-73.6164665222168,""latitude"":45.52231518882623}}}","","{}","2017-04-12T18:55:27.421Z","1492026850745"
"211","45d43708-67c1-4ee1-9cbc-212082b645c2","ReactNative-a76924c11115eb8b","Pixel (ReactNative)","45.5192799","-73.6170079","20","-1.0","-1.0","-1.0","0.7","motionchange","on_foot","80","1.0","0","1","","","{}","2017-04-12T18:38:09.716Z","1492026861182"
"212","65eb4295-d4a7-4046-ba36-af6cc57ba611","ReactNative-a76924c11115eb8b","Pixel (ReactNative)","45.5192718","-73.6170127","10","-1.0","-1.0","-1.0","0.7","motionchange","still","75","1.0","0","0","","","{}","2017-04-12T18:39:58.585Z","1492026861259"
"213","38986aab-a141-44dd-8845-e4f067c1ca09","ReactNative-a76924c11115eb8b","Pixel (ReactNative)","45.5192799","-73.6170079","20.2","-1.0","-1.0","-1.0","0.7","motionchange","on_foot","80","1.0","0","1","","","{}","2017-04-12T18:50:32.006Z","1492026861329"
"214","3d603cc4-998b-452a-8040-d8ea2de45545","ReactNative-a76924c11115eb8b","Pixel (ReactNative)","45.5192909","-73.6176493","12","37.0","1.88","314.0","50.9","","on_foot","80","1.0","0","1","","","{}","2017-04-12T18:51:59.000Z","1492026861404"
"215","592db1b5-b4ce-4672-acf1-6f8339bf5e1f","ReactNative-a76924c11115eb8b","Pixel (ReactNative)","45.519735","-73.6175287","6","47.0","1.69","31.0","101.1","","on_foot","80","1.0","0","1","","","{}","2017-04-12T18:52:36.000Z","1492026861467"