search

jbrzusto / TO_DO

sensorgnome / motus TODO list for jbrzusto
0 stars 0 forks source link

fix multiple receivers in site 'Motus:Kingsburg' for 2015 #69

Closed jbrzusto closed 6 years ago

jbrzusto commented 7 years ago

for some days, files from a mobile unit and the fixed unit were both included in 2015_Motus_Kingsburg

select t1.*, t2.bootnum, min(t2.ts) as tsLo, max(t2.ts), avg(t3.lat), avg(t3.lon) as tsHi 
from deployments as t1 left join files as t2 on t1.depID=t2.depID left join gps as t3 on
t1.depID=t3.depID group by t2.depID, t2.bootnum order by t2.depID, t2.bootnum;
depID,proj,recv,bootnum,tsLo,max(t2.ts),avg(t3.lat),tsHi
1,Kingsburg,1614BBBK1612,40,1431648407.638,1438178445.365,44.2673932745881,-64.2594703893818
1,Kingsburg,1614BBBK1612,41,1438178512.248,1441027170.435,44.2673932684413,-64.2594703939056
1,Kingsburg,1614BBBK1612,42,1441027294.832,1441548438.0,44.2673932668556,-64.2594703966131
2,kingsburg,4001BBBK2600,85,1448042804.448,1448248308.961,44.267395829838,-64.2594832066482
2,kingsburg,4001BBBK2600,86,1448283661.486,1448287261.687,44.2673958298302,-64.259483206646
2,kingsburg,4001BBBK2600,87,1448293519.058,1448294187.782,44.267395829824,-64.259483206647
2,kingsburg,4001BBBK2600,88,1448297022.873,1448297561.535,44.267395829824,-64.259483206647
2,kingsburg,4001BBBK2600,89,1448300103.908,1448300202.351,44.267395829824,-64.259483206647
2,kingsburg,4001BBBK2600,90,1448302854.354,1448302962.937,44.267395829824,-64.259483206647
2,kingsburg,4001BBBK2600,91,1448365529.21,1448365827.854,44.267395829824,-64.259483206647
2,kingsburg,4001BBBK2600,92,1448367813.173,1449227632.096,44.2673958297349,-64.2594832065238
2,kingsburg,4001BBBK2600,93,1450269369.025,1450468273.475,44.2673958298339,-64.2594832066406
2,kingsburg,4001BBBK2600,94,1450529194.546,1450922503.057,44.267395829802,-64.2594832065401
2,kingsburg,4001BBBK2600,97,1451047596.404,1451447804.642,44.267395829801,-64.2594832065389
2,kingsburg,4001BBBK2600,99,1451479806.39,1451508907.167,44.267395829827,-64.259483206637
2,kingsburg,4001BBBK2600,101,1451572727.541,1451598228.234,44.2673958298256,-64.2594832066377
3,motusmobile,4001BBBK2600,31,1438977063.911,1438977063.911,44.2204833676624,-64.3399159148123
3,motusmobile,4001BBBK2600,32,1438977113.204,1438999313.679,44.2204833676725,-64.3399159148014
3,motusmobile,4001BBBK2600,33,1439057281.871,1439057310.456,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,34,1439057434.782,1439061335.047,44.2204833676778,-64.3399159148474
3,motusmobile,4001BBBK2600,35,1439062777.841,1439066678.151,44.2204833676778,-64.3399159148474
3,motusmobile,4001BBBK2600,36,1439068781.727,1439069001.58,44.2204833676764,-64.3399159148395
3,motusmobile,4001BBBK2600,37,1439069054.809,1439076555.051,44.2204833676764,-64.3399159148395
3,motusmobile,4001BBBK2600,38,1439079477.524,1439079496.025,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,39,1439080234.475,1439081468.266,44.2204833676764,-64.3399159148395
3,motusmobile,4001BBBK2600,40,1439081521.873,1439085422.131,44.2204833676778,-64.3399159148474
3,motusmobile,4001BBBK2600,41,1439212151.114,1439252051.912,44.2204833676743,-64.3399159147752
3,motusmobile,4001BBBK2600,42,1439737706.846,1439745207.144,44.2204833676764,-64.3399159148395
3,motusmobile,4001BBBK2600,43,1439746146.648,1439746353.212,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,44,1439747004.486,1439748167.811,44.2204833676764,-64.3399159148395
3,motusmobile,4001BBBK2600,45,1439748276.273,1439748334.939,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,46,1439749332.545,1439749401.05,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,47,1439752260.978,1439752369.543,44.2204833676818,-64.3399159148356
3,motusmobile,4001BBBK2600,48,1439752533.956,1439752572.559,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,49,1439752921.66,1439752960.083,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,50,1439753915.329,1439754382.884,44.2204833676778,-64.3399159148474
3,motusmobile,4001BBBK2600,51,1439759763.886,1439774136.218,44.2204833676742,-64.3399159148175
3,motusmobile,4001BBBK2600,52,1439774198.551,1439774542.248,44.2204833676764,-64.3399159148395
3,motusmobile,4001BBBK2600,53,1439774656.949,1439774705.566,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,54,1439775598.636,1439775634.039,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,55,1439776404.924,1439834135.385,44.2204833676754,-64.3399159147403
3,motusmobile,4001BBBK2600,56,1439834877.167,1439834955.667,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,57,1439836325.576,1439836374.177,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,58,1439839220.543,1439857349.546,44.2204833676733,-64.3399159148088
3,motusmobile,4001BBBK2600,59,1439858663.943,1439858712.478,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,60,1439859335.598,1439859645.308,44.2204833676764,-64.3399159148395
3,motusmobile,4001BBBK2600,61,1439859694.501,1439859903.632,44.2204833676764,-64.3399159148395
3,motusmobile,4001BBBK2600,62,1439860014.302,1439881763.257,44.2204833676725,-64.3399159148014
3,motusmobile,4001BBBK2600,63,1439927286.296,1439927746.326,44.2204833676764,-64.3399159148395
3,motusmobile,4001BBBK2600,64,1439927859.401,1439927917.95,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,65,1439928558.528,1439932202.162,44.2204833676778,-64.3399159148474
3,motusmobile,4001BBBK2600,66,1439934946.037,1439942227.603,44.2204833676764,-64.3399159148395
3,motusmobile,4001BBBK2600,67,1439945387.609,1439945426.033,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,68,1439947245.437,1439947364.147,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,69,1439947676.54,1439947725.189,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,70,1439947947.814,1439947986.42,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,71,1439948645.613,1439948724.432,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,72,1439949046.79,1439996006.241,44.2204833676748,-64.339915914764
3,motusmobile,4001BBBK2600,73,1439997479.928,1440001153.066,44.2204833676778,-64.3399159148474
3,motusmobile,4001BBBK2600,74,1440003291.733,1440003327.161,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,75,1440114333.985,1440208835.902,44.2204833676454,-64.3399159146906
3,motusmobile,4001BBBK2600,77,1441054387.71,1441054536.112,44.2204833676796,-64.3399159148421
3,motusmobile,4001BBBK2600,78,1441055870.151,1441066970.494,44.2204833676752,-64.3399159148276
3,motusmobile,4001BBBK2600,79,1441069296.473,1441073196.7,44.2204833676778,-64.3399159148474
3,motusmobile,4001BBBK2600,80,1441113133.138,1441121260.042,44.2204833676742,-64.3399159148175
3,motusmobile,4001BBBK2600,81,1441121319.614,1441128819.901,44.2204833676764,-64.3399159148395
3,motusmobile,4001BBBK2600,82,1441150636.657,1441208838.214,44.2204833676754,-64.3399159147403
3,motusmobile,4001BBBK2600,83,1441298919.356,1441367621.129,44.2204833676758,-64.3399159147217
3,motusmobile,4001BBBK2600,84,1441554566.81,1441554675.186,44.2204833676818,-64.3399159148356
3,motusmobile,4001BBBK2600,85,1441560505.52,1448042718.539,44.2204833762373,-64.3399159102232
4,UPTAN2,4001BBBK2600,11,1438450176.504,1438450176.504,43.929530368761,-64.8388028613629
4,UPTAN2,4001BBBK2600,12,1438622385.854,1438622525.457,43.9295303687611,-64.8388028613628
4,UPTAN2,4001BBBK2600,13,1438622638.054,1438622706.565,43.9295303687611,-64.8388028613629
4,UPTAN2,4001BBBK2600,14,1438623110.066,1438623188.744,43.9295303687611,-64.8388028613629
4,UPTAN2,4001BBBK2600,15,1438648953.296,1438649201.898,43.9295303687611,-64.8388028613629
4,UPTAN2,4001BBBK2600,16,1438697433.359,1438697790.926,43.929530368761,-64.8388028613628
4,UPTAN2,4001BBBK2600,17,1438697904.002,1438697992.703,43.9295303687611,-64.8388028613629
4,UPTAN2,4001BBBK2600,18,1438704112.858,1438704417.08,43.929530368761,-64.8388028613628
4,UPTAN2,4001BBBK2600,19,1438704527.618,1438708427.848,43.9295303687611,-64.8388028613628
4,UPTAN2,4001BBBK2600,20,1438723425.266,1438730925.54,43.9295303687611,-64.8388028613628
4,UPTAN2,4001BBBK2600,22,1438824285.827,1438827885.881,43.929530368761,-64.8388028613629
5,SG1,4001BBBK2600,23,1438828833.639,1438828862.109,43.9295376515273,-64.8387829242364
5,SG1,4001BBBK2600,24,1438829914.648,1438830033.411,43.9295376515273,-64.8387829242364
5,SG1,4001BBBK2600,25,1438910180.813,1438912141.266,43.9295376515273,-64.8387829242365
5,SG1,4001BBBK2600,26,1438912274.492,1438913794.495,43.9295376515273,-64.8387829242365
5,SG1,4001BBBK2600,27,1438913907.504,1438913945.977,43.9295376515273,-64.8387829242364
5,SG1,4001BBBK2600,28,1438914178.777,1438914207.232,43.9295376515273,-64.8387829242364
5,SG1,4001BBBK2600,29,1438952635.013,1438956535.251,43.9295376515273,-64.8387829242364
5,SG1,4001BBBK2600,30,1438960246.227,1438975846.489,43.9295376515273,-64.8387829242365
5,SG1,4001BBBK2600,31,1438976255.389,1438976304.019,43.9295376515273,-64.8387829242364
jbrzusto commented 6 years ago

closing - obsolete.