[ -5.00, 45.00 ], [ +0.00, 45.00 ], [ +0.00, 50.00 ], [ -5.00, 50.00 ], [ -5.00, 45.00 ] [ -5.00, 45.00 ], [ -5.00, 50.00 ], [ +0.00, 50.00 ], [ +0.00, 45.00 ], [ -5.00, 45.00 ] ################################################## ################################################## db.nari_dynamic.explain('executionStats').aggregate ( [ { "$match": { "geoloc": { "$geoWithin": { "$geometry": { "type" : "Polygon" , "coordinates": [ [ [ -5.00, 45.00 ], [ +0.00, 45.00 ], [ +0.00, 50.00 ], [ -5.00, 50.00 ], [ -5.00, 45.00 ] ] ] }}}} }, { "$group": {"_id": "$sourcemmsi", "PointCount": {"$sum" : 1}, "MinDatePoint": {"$min" : {"date": "$t3" }}, "MaxDatePoint": {"$max" : {"date": "$t3" }} }}, { "$sort": {"_id":1} }, { "$limit":100 }, { "$project": {"_id":1, "PointCount":1, "MinDatePoint":1, "MaxDatePoint":1} } ], { explain:true} ) ##################WITHOUT INDEX################## { stages: [ { '$cursor': { queryPlanner: { plannerVersion: 1, namespace: 'mscdata.nari_dynamic', indexFilterSet: false, parsedQuery: { geoloc: { '$geoWithin': { '$geometry': { type: 'Polygon', coordinates: [ [ [ -5, 45 ], [ 0, 45 ], [ 0, 50 ], [ -5, 50 ], [ -5, 45 ] ] ] } } } }, queryHash: '6E2EAB94', planCacheKey: '6E2EAB94', winningPlan: { stage: 'PROJECTION_SIMPLE', transformBy: { sourcemmsi: 1, t3: 1, _id: 0 }, inputStage: { stage: 'COLLSCAN', filter: { geoloc: { '$geoWithin': { '$geometry': { type: 'Polygon', coordinates: [ [ [ -5, 45 ], [ 0, 45 ], [ 0, 50 ], [ -5, 50 ], [ -5, 45 ] ] ] } } } }, direction: 'forward' } }, rejectedPlans: [] } } }, { '$group': { _id: '$sourcemmsi', PointCount: { '$sum': { '$const': 1 } }, MinDatePoint: { '$min': { date: '$t3' } }, MaxDatePoint: { '$max': { date: '$t3' } } } }, { '$sort': { sortKey: { _id: 1 }, limit: 100 } }, { '$project': { _id: true, PointCount: true, MaxDatePoint: true, MinDatePoint: true } } ], serverInfo: { host: 'ubuntu16', port: 27017, version: '4.4.1', gitVersion: 'ad91a93a5a31e175f5cbf8c69561e788bbc55ce1' }, ok: 1 } ##################WITH INDEX################## { stages: [ { '$cursor': { queryPlanner: { plannerVersion: 1, namespace: 'mscdata.nari_dynamic', indexFilterSet: false, parsedQuery: { geoloc: { '$geoWithin': { '$geometry': { type: 'Polygon', coordinates: [ [ [ -5, 45 ], [ 0, 45 ], [ 0, 50 ], [ -5, 50 ], [ -5, 45 ] ] ] } } } }, queryHash: '6E2EAB94', planCacheKey: 'F35B194B', winningPlan: { stage: 'PROJECTION_SIMPLE', transformBy: { sourcemmsi: 1, t3: 1, _id: 0 }, inputStage: { stage: 'FETCH', filter: { geoloc: { '$geoWithin': { '$geometry': { type: 'Polygon', coordinates: [ [ [ -5, 45 ], [ 0, 45 ], [ 0, 50 ], [ -5, 50 ], [ -5, 45 ] ] ] } } } }, inputStage: { stage: 'IXSCAN', keyPattern: { geoloc: '2dsphere' }, indexName: 'geoloc-field', isMultiKey: false, multiKeyPaths: { geoloc: [] }, isUnique: false, isSparse: false, isPartial: false, indexVersion: 2, direction: 'forward', indexBounds: { geoloc: [ '[936748722493063168, 936748722493063168]', '[954763121002545152, 954763121002545152]', '[959266720629915648, 959266720629915648]', '[960392620536758272, 960392620536758272]', '[960674095513468928, 960674095513468928]', '[960744464257646592, 960744464257646592]', '[960762056443691008, 960762056443691008]', '[960766454490202112, 960766454490202112]', '[960767554001829888, 960767554001829888]', '[960767828879736832, 960767828879736832]', '[960767897599213568, 960767897599213568]', '[960767914779082752, 960767914779082752]', '[960767919074050048, 960767919074050048]', '[960767920147791872, 960767920147791872]', '[960767920416227328, 960767920416227328]', '[960767920483336192, 960767920483336192]', '[960767920500113408, 960767920500113408]', '[960767920504307712, 960767920504307712]', '[960767920505356288, 960767920505356288]', '[960767920505618432, 960767920505618432]', '[960767920505683968, 960767920505683968]', '[960767920505683969, 960767920505716735]', '[1345075088707977217, 1345075088708009983]', '[1345075088708009984, 1345075088708009984]', '[1345075088708075520, 1345075088708075520]', '[1345075088708337664, 1345075088708337664]', '[1345075088709386240, 1345075088709386240]', '[1345075088713580544, 1345075088713580544]', '[1345075088730357760, 1345075088730357760]', '[1345075088797466624, 1345075088797466624]', '[1345075089065902080, 1345075089065902080]', '[1345075090139643904, 1345075090139643904]', '[1345075094434611200, 1345075094434611200]', '[1345075111614480384, 1345075111614480384]', '[1345075180333957120, 1345075180333957120]', '[1345075455211864064, 1345075455211864064]', '[1345076554723491840, 1345076554723491840]', '[1345080952770002944, 1345080952770002944]', '[1345098544956047360, 1345098544956047360]', '[1345168913700225024, 1345168913700225024]', '[1345450388676935680, 1345450388676935680]', '[1346576288583778304, 1346576288583778304]', '[1351079888211148800, 1351079888211148800]', '[1369094286720630784, 1369094286720630784]', '[5116089176692883456, 5116089176692883456]', '[5170132372221329408, 5170132372221329408]', '[5179139571476070401, 5179702521429491711]', '[5179702521429491713, 5180265471382913023]', '[5180265471382913024, 5180265471382913024]', '[5183643171103440896, 5183643171103440896]', '[5187020870823968768, 5187020870823968768]', '[5187020870823968769, 5187583820777390079]', '[5187583820777390081, 5188146770730811391]', '[5188146770730811393, 5197153969985552383]', '[5206161169240293376, 5206161169240293376]', '[5218264593238851584, 5218264593238851584]', '[5218264593238851585, 5218405330727206911]', '[5218546068215562240, 5218546068215562240]', '[5218546068215562241, 5219109018168983551]', '[5219671968122404864, 5219671968122404864]', '[5220234918075826177, 5220797868029247487]', '[5220797868029247488, 5220797868029247488]', '[5220938605517602817, 5221079343005958143]', '[5221079343005958144, 5221079343005958144]', '[5260204364768739328, 5260204364768739328]' ] } } } }, rejectedPlans: [] } } }, { '$group': { _id: '$sourcemmsi', PointCount: { '$sum': { '$const': 1 } }, MinDatePoint: { '$min': { date: '$t3' } }, MaxDatePoint: { '$max': { date: '$t3' } } } }, { '$sort': { sortKey: { _id: 1 }, limit: 100 } }, { '$project': { _id: true, MinDatePoint: true, MaxDatePoint: true, PointCount: true } } ], serverInfo: { host: 'ubuntu16', port: 27017, version: '4.4.1', gitVersion: 'ad91a93a5a31e175f5cbf8c69561e788bbc55ce1' }, ok: 1 } ##################WITH INDEX GEOLOC 2################## { stages: [ { '$cursor': { queryPlanner: { plannerVersion: 1, namespace: 'mscdata.nari_dynamic', indexFilterSet: false, parsedQuery: { geoloc2: { '$geoWithin': { '$geometry': { type: 'Polygon', coordinates: [ [ [ -5, 45 ], [ 0, 45 ], [ 0, 50 ], [ -5, 50 ], [ -5, 45 ] ] ] } } } }, queryHash: '8D2F4949', planCacheKey: '472F9222', winningPlan: { stage: 'PROJECTION_SIMPLE', transformBy: { sourcemmsi: 1, t3: 1, _id: 0 }, inputStage: { stage: 'FETCH', filter: { geoloc2: { '$geoWithin': { '$geometry': { type: 'Polygon', coordinates: [ [ [ -5, 45 ], [ 0, 45 ], [ 0, 50 ], [ -5, 50 ], [ -5, 45 ] ] ] } } } }, inputStage: { stage: 'IXSCAN', keyPattern: { geoloc2: '2dsphere' }, indexName: 'geoloc2-field', isMultiKey: false, multiKeyPaths: { geoloc2: [] }, isUnique: false, isSparse: false, isPartial: false, indexVersion: 2, direction: 'forward', indexBounds: { geoloc2: [ '[936748722493063168, 936748722493063168]', '[954763121002545152, 954763121002545152]', '[959266720629915648, 959266720629915648]', '[960392620536758272, 960392620536758272]', '[960674095513468928, 960674095513468928]', '[960744464257646592, 960744464257646592]', '[960762056443691008, 960762056443691008]', '[960766454490202112, 960766454490202112]', '[960767554001829888, 960767554001829888]', '[960767828879736832, 960767828879736832]', '[960767897599213568, 960767897599213568]', '[960767914779082752, 960767914779082752]', '[960767919074050048, 960767919074050048]', '[960767920147791872, 960767920147791872]', '[960767920416227328, 960767920416227328]', '[960767920483336192, 960767920483336192]', '[960767920500113408, 960767920500113408]', '[960767920504307712, 960767920504307712]', '[960767920505356288, 960767920505356288]', '[960767920505618432, 960767920505618432]', '[960767920505683968, 960767920505683968]', '[960767920505683969, 960767920505716735]', '[1345075088707977217, 1345075088708009983]', '[1345075088708009984, 1345075088708009984]', '[1345075088708075520, 1345075088708075520]', '[1345075088708337664, 1345075088708337664]', '[1345075088709386240, 1345075088709386240]', '[1345075088713580544, 1345075088713580544]', '[1345075088730357760, 1345075088730357760]', '[1345075088797466624, 1345075088797466624]', '[1345075089065902080, 1345075089065902080]', '[1345075090139643904, 1345075090139643904]', '[1345075094434611200, 1345075094434611200]', '[1345075111614480384, 1345075111614480384]', '[1345075180333957120, 1345075180333957120]', '[1345075455211864064, 1345075455211864064]', '[1345076554723491840, 1345076554723491840]', '[1345080952770002944, 1345080952770002944]', '[1345098544956047360, 1345098544956047360]', '[1345168913700225024, 1345168913700225024]', '[1345450388676935680, 1345450388676935680]', '[1346576288583778304, 1346576288583778304]', '[1351079888211148800, 1351079888211148800]', '[1369094286720630784, 1369094286720630784]', '[5116089176692883456, 5116089176692883456]', '[5170132372221329408, 5170132372221329408]', '[5179139571476070401, 5179702521429491711]', '[5179702521429491713, 5180265471382913023]', '[5180265471382913024, 5180265471382913024]', '[5183643171103440896, 5183643171103440896]', '[5187020870823968768, 5187020870823968768]', '[5187020870823968769, 5187583820777390079]', '[5187583820777390081, 5188146770730811391]', '[5188146770730811393, 5197153969985552383]', '[5206161169240293376, 5206161169240293376]', '[5218264593238851584, 5218264593238851584]', '[5218264593238851585, 5218405330727206911]', '[5218546068215562240, 5218546068215562240]', '[5218546068215562241, 5219109018168983551]', '[5219671968122404864, 5219671968122404864]', '[5220234918075826177, 5220797868029247487]', '[5220797868029247488, 5220797868029247488]', '[5220938605517602817, 5221079343005958143]', '[5221079343005958144, 5221079343005958144]', '[5260204364768739328, 5260204364768739328]' ] } } } }, rejectedPlans: [] } } }, { '$group': { _id: '$sourcemmsi', PointCount: { '$sum': { '$const': 1 } }, MinDatePoint: { '$min': { date: '$t3' } }, MaxDatePoint: { '$max': { date: '$t3' } } } }, { '$sort': { sortKey: { _id: 1 }, limit: 100 } }, { '$project': { _id: true, PointCount: true, MaxDatePoint: true, MinDatePoint: true } } ], serverInfo: { host: 'ubuntu16', port: 27017, version: '4.4.1', gitVersion: 'ad91a93a5a31e175f5cbf8c69561e788bbc55ce1' }, ok: 1 } ##################WITH INDEX GEOLOC 2 - v3################## { stages: [ { '$cursor': { queryPlanner: { plannerVersion: 1, namespace: 'mscdata.nari_dynamic', indexFilterSet: false, parsedQuery: { geoloc2: { '$geoWithin': { '$geometry': { type: 'Polygon', coordinates: [ [ [ -5, 45 ], [ 0, 45 ], [ 0, 50 ], [ -5, 50 ], [ -5, 45 ] ] ] } } } }, queryHash: '8D2F4949', planCacheKey: '472F9222', winningPlan: { stage: 'PROJECTION_SIMPLE', transformBy: { sourcemmsi: 1, t3: 1, _id: 0 }, inputStage: { stage: 'FETCH', filter: { geoloc2: { '$geoWithin': { '$geometry': { type: 'Polygon', coordinates: [ [ [ -5, 45 ], [ 0, 45 ], [ 0, 50 ], [ -5, 50 ], [ -5, 45 ] ] ] } } } }, inputStage: { stage: 'IXSCAN', keyPattern: { geoloc2: '2dsphere', version: 3 }, indexName: 'geoloc2', isMultiKey: false, multiKeyPaths: { geoloc2: [], version: [] }, isUnique: false, isSparse: false, isPartial: false, indexVersion: 2, direction: 'forward', indexBounds: { geoloc2: [ '[936748722493063168, 936748722493063168]', '[954763121002545152, 954763121002545152]', '[959266720629915648, 959266720629915648]', '[960392620536758272, 960392620536758272]', '[960674095513468928, 960674095513468928]', '[960744464257646592, 960744464257646592]', '[960762056443691008, 960762056443691008]', '[960766454490202112, 960766454490202112]', '[960767554001829888, 960767554001829888]', '[960767828879736832, 960767828879736832]', '[960767897599213568, 960767897599213568]', '[960767914779082752, 960767914779082752]', '[960767919074050048, 960767919074050048]', '[960767920147791872, 960767920147791872]', '[960767920416227328, 960767920416227328]', '[960767920483336192, 960767920483336192]', '[960767920500113408, 960767920500113408]', '[960767920504307712, 960767920504307712]', '[960767920505356288, 960767920505356288]', '[960767920505618432, 960767920505618432]', '[960767920505683968, 960767920505683968]', '[960767920505683969, 960767920505716735]', '[1345075088707977217, 1345075088708009983]', '[1345075088708009984, 1345075088708009984]', '[1345075088708075520, 1345075088708075520]', '[1345075088708337664, 1345075088708337664]', '[1345075088709386240, 1345075088709386240]', '[1345075088713580544, 1345075088713580544]', '[1345075088730357760, 1345075088730357760]', '[1345075088797466624, 1345075088797466624]', '[1345075089065902080, 1345075089065902080]', '[1345075090139643904, 1345075090139643904]', '[1345075094434611200, 1345075094434611200]', '[1345075111614480384, 1345075111614480384]', '[1345075180333957120, 1345075180333957120]', '[1345075455211864064, 1345075455211864064]', '[1345076554723491840, 1345076554723491840]', '[1345080952770002944, 1345080952770002944]', '[1345098544956047360, 1345098544956047360]', '[1345168913700225024, 1345168913700225024]', '[1345450388676935680, 1345450388676935680]', '[1346576288583778304, 1346576288583778304]', '[1351079888211148800, 1351079888211148800]', '[1369094286720630784, 1369094286720630784]', '[5116089176692883456, 5116089176692883456]', '[5170132372221329408, 5170132372221329408]', '[5179139571476070401, 5179702521429491711]', '[5179702521429491713, 5180265471382913023]', '[5180265471382913024, 5180265471382913024]', '[5183643171103440896, 5183643171103440896]', '[5187020870823968768, 5187020870823968768]', '[5187020870823968769, 5187583820777390079]', '[5187583820777390081, 5188146770730811391]', '[5188146770730811393, 5197153969985552383]', '[5206161169240293376, 5206161169240293376]', '[5218264593238851584, 5218264593238851584]', '[5218264593238851585, 5218405330727206911]', '[5218546068215562240, 5218546068215562240]', '[5218546068215562241, 5219109018168983551]', '[5219671968122404864, 5219671968122404864]', '[5220234918075826177, 5220797868029247487]', '[5220797868029247488, 5220797868029247488]', '[5220938605517602817, 5221079343005958143]', '[5221079343005958144, 5221079343005958144]', '[5260204364768739328, 5260204364768739328]' ], version: [ '[MinKey, MaxKey]' ] } } } }, rejectedPlans: [] } } }, { '$group': { _id: '$sourcemmsi', PointCount: { '$sum': { '$const': 1 } }, MinDatePoint: { '$min': { date: '$t3' } }, MaxDatePoint: { '$max': { date: '$t3' } } } }, { '$sort': { sortKey: { _id: 1 }, limit: 100 } }, { '$project': { _id: true, PointCount: true, MinDatePoint: true, MaxDatePoint: true } } ], serverInfo: { host: 'ubuntu16', port: 27017, version: '4.4.1', gitVersion: 'ad91a93a5a31e175f5cbf8c69561e788bbc55ce1' }, ok: 1 } {'_id': 1234500, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 14, 7, 33, 28)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 14, 7, 33, 28)}} {'_id': 9105765, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2016, 3, 21, 15, 48, 20)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 3, 21, 15, 48, 20)}} {'_id': 37100300, 'PointCount': 3489, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 6, 22, 52, 5)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 8, 10, 13, 3)}} {'_id': 205067000, 'PointCount': 27, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 23, 0, 38, 33)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 23, 7, 43, 59)}} {'_id': 205204000, 'PointCount': 12076, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 2, 4, 16, 10)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 23, 15, 58, 37)}} {'_id': 205227000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2016, 1, 23, 7, 59)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 1, 23, 7, 59)}} {'_id': 205277430, 'PointCount': 215, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 13, 8, 43, 35)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 14, 12, 58, 20)}} {'_id': 205309000, 'PointCount': 28268, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 24, 16, 51, 4)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 2, 4, 2, 18, 12)}} {'_id': 205439000, 'PointCount': 3034, 'MinDatePoint': {'date': datetime.datetime(2016, 1, 23, 7, 38, 26)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 2, 7, 7, 58, 56)}} {'_id': 205476000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 13, 14, 53, 14)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 13, 14, 53, 14)}} {'_id': 205655000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2016, 3, 25, 17, 33, 51)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 3, 25, 17, 33, 51)}} {'_id': 205656000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2016, 1, 23, 8, 53, 23)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 1, 23, 8, 53, 23)}} {'_id': 205688000, 'PointCount': 86, 'MinDatePoint': {'date': datetime.datetime(2016, 3, 25, 6, 43, 46)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 3, 25, 14, 30, 22)}} {'_id': 205734400, 'PointCount': 403, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 17, 6, 38, 25)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 22, 21, 58, 32)}} {'_id': 205880600, 'PointCount': 1451, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 11, 12, 14, 47)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 13, 10, 46, 26)}} {'_id': 207137000, 'PointCount': 6, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 13, 19, 48)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 13, 20, 29, 51)}} {'_id': 207138000, 'PointCount': 7485, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 16, 9, 28, 45)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 23, 15, 9, 12)}} {'_id': 209015000, 'PointCount': 4119, 'MinDatePoint': {'date': datetime.datetime(2016, 1, 2, 0, 15, 39)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 1, 12, 1, 36, 28)}} {'_id': 209179000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 22, 2, 48, 18)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 22, 2, 48, 18)}} {'_id': 209185000, 'PointCount': 2, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 23, 0, 53, 47)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 23, 0, 58, 58)}} {'_id': 209297000, 'PointCount': 48, 'MinDatePoint': {'date': datetime.datetime(2016, 1, 5, 20, 58, 47)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 1, 13, 14, 28, 36)}} {'_id': 209304000, 'PointCount': 146, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 12, 20, 44, 2)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 27, 19, 58, 15)}} {'_id': 209355000, 'PointCount': 2, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 12, 17, 38, 12)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 12, 18, 43, 42)}} {'_id': 209384000, 'PointCount': 7, 'MinDatePoint': {'date': datetime.datetime(2016, 1, 23, 7, 59, 1)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 1, 24, 20, 48, 1)}} {'_id': 209487000, 'PointCount': 182, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 30, 11, 58, 17)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 1, 23, 7, 33, 27)}} {'_id': 209570000, 'PointCount': 166, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 17, 2, 28, 34)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 17, 3, 21, 59)}} {'_id': 209588000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 27, 10, 33, 41)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 27, 10, 33, 41)}} {'_id': 209672000, 'PointCount': 3, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 12, 5, 5, 26)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 12, 5, 6, 57)}} {'_id': 209718000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 22, 9, 53, 58)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 22, 9, 53, 58)}} {'_id': 209734000, 'PointCount': 3, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 1, 6, 33, 14)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 1, 6, 53, 51)}} {'_id': 209840000, 'PointCount': 283, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 17, 5, 1, 42)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 2, 1, 9, 38, 50)}} {'_id': 209964000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 3, 17, 48, 14)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 3, 17, 48, 14)}} {'_id': 210029000, 'PointCount': 206, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 6, 22, 33, 48)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 17, 23, 50, 23)}} {'_id': 210041000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2016, 3, 12, 4, 53, 41)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 3, 12, 4, 53, 41)}} {'_id': 210075000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 10, 16, 53, 42)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 10, 16, 53, 42)}} {'_id': 210117000, 'PointCount': 2, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 3, 7, 33, 37)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 3, 7, 48, 26)}} {'_id': 210267000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 15, 21, 53, 20)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 15, 21, 53, 20)}} {'_id': 210329000, 'PointCount': 21, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 16, 22, 43, 11)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 12, 19, 38, 33)}} {'_id': 210434000, 'PointCount': 686, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 5, 1, 38, 51)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 2, 21, 20, 6, 46)}} {'_id': 210505000, 'PointCount': 81, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 22, 1, 42, 25)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 22, 3, 14, 16)}} {'_id': 210745000, 'PointCount': 4, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 4, 11, 33, 39)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 4, 11, 48, 29)}} {'_id': 210914000, 'PointCount': 51, 'MinDatePoint': {'date': datetime.datetime(2016, 1, 22, 21, 43, 33)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 2, 6, 4, 56, 9)}} {'_id': 210974000, 'PointCount': 17, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 30, 4, 43, 51)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 1, 24, 19, 31, 26)}} {'_id': 211135000, 'PointCount': 2418, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 9, 9, 0, 21)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 11, 10, 14, 1)}} {'_id': 211158080, 'PointCount': 3214, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 16, 8, 34)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 3, 24, 11, 58, 33)}} {'_id': 211160630, 'PointCount': 496, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 1, 13, 33, 33)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 4, 9, 48, 59)}} {'_id': 211210100, 'PointCount': 108, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 21, 16, 33, 11)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 22, 1, 58, 59)}} {'_id': 211210280, 'PointCount': 16, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 10, 18, 48, 55)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 11, 6, 43, 58)}} {'_id': 211211220, 'PointCount': 12354, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 8, 11, 49, 18)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 23, 13, 58, 50)}} {'_id': 211211760, 'PointCount': 3, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 23, 9, 33, 31)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 23, 9, 33, 46)}} {'_id': 211232180, 'PointCount': 1313, 'MinDatePoint': {'date': datetime.datetime(2015, 9, 30, 22, 0, 28)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 11, 11, 43, 55)}} {'_id': 211271630, 'PointCount': 19, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 2, 13, 33, 18)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 3, 22, 15, 58, 39)}} {'_id': 211286440, 'PointCount': 7066, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 7, 14, 21, 13)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 31, 23, 21, 29)}} {'_id': 211330520, 'PointCount': 1916, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 25, 21, 3, 26)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 2, 29, 17, 45, 55)}} {'_id': 211366340, 'PointCount': 13, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 1, 14, 33, 37)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 1, 14, 53, 39)}} {'_id': 211379750, 'PointCount': 1076, 'MinDatePoint': {'date': datetime.datetime(2016, 1, 23, 15, 15, 26)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 1, 25, 1, 43, 3)}} {'_id': 211387420, 'PointCount': 553, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 2, 15, 43, 58)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 7, 16, 58, 40)}} {'_id': 211397660, 'PointCount': 2, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 12, 0, 31, 53)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 12, 0, 45, 13)}} {'_id': 211422510, 'PointCount': 14, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 2, 8, 58, 27)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 11, 16, 58, 49)}} {'_id': 211447460, 'PointCount': 734, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 3, 9, 43, 54)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 3, 16, 12, 46, 45)}} {'_id': 211472000, 'PointCount': 2042, 'MinDatePoint': {'date': datetime.datetime(2016, 1, 18, 8, 30)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 1, 19, 15, 7, 10)}} {'_id': 211522970, 'PointCount': 204, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 11, 10, 43, 12)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 13, 4, 58, 50)}} {'_id': 211545370, 'PointCount': 433, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 18, 23, 33, 16)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 20, 10, 2, 33)}} {'_id': 211552340, 'PointCount': 2177, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 2, 18, 48, 14)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 9, 18, 58, 25)}} {'_id': 211560760, 'PointCount': 578, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 19, 11, 33, 16)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 20, 12, 48, 57)}} {'_id': 211611040, 'PointCount': 11, 'MinDatePoint': {'date': datetime.datetime(2016, 3, 10, 12, 33, 22)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 3, 22, 10, 53, 44)}} {'_id': 211617730, 'PointCount': 2408, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 12, 7, 43, 59)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 19, 11, 48, 47)}} {'_id': 211625170, 'PointCount': 13, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 9, 15, 43, 22)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 9, 17, 43, 52)}} {'_id': 211627970, 'PointCount': 60, 'MinDatePoint': {'date': datetime.datetime(2016, 1, 24, 20, 13, 12)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 1, 24, 21, 5, 5)}} {'_id': 211633320, 'PointCount': 704, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 3, 1, 58, 41)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 3, 22, 58, 57)}} {'_id': 211651000, 'PointCount': 211, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 7, 8, 30, 6)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 7, 9, 53, 55)}} {'_id': 211668500, 'PointCount': 1508, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 20, 12, 33, 35)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 25, 11, 33, 36)}} {'_id': 211707600, 'PointCount': 8580, 'MinDatePoint': {'date': datetime.datetime(2016, 3, 16, 12, 43, 16)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 3, 31, 21, 59, 27)}} {'_id': 211852000, 'PointCount': 60, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 6, 22, 13, 26)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 30, 9, 29, 4)}} {'_id': 211881000, 'PointCount': 8, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 19, 16, 39, 31)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 19, 16, 57, 50)}} {'_id': 212097000, 'PointCount': 11, 'MinDatePoint': {'date': datetime.datetime(2016, 2, 1, 11, 43, 11)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 3, 10, 14, 33, 42)}} {'_id': 212109000, 'PointCount': 4021, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 9, 5, 45, 13)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 12, 9, 19)}} {'_id': 212136000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 19, 0, 22, 41)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 19, 0, 22, 41)}} {'_id': 212186000, 'PointCount': 45, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 7, 8, 36, 20)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 11, 2, 8, 38)}} {'_id': 212193000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 12, 3, 33, 42)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 12, 3, 33, 42)}} {'_id': 212360000, 'PointCount': 3514, 'MinDatePoint': {'date': datetime.datetime(2016, 1, 21, 13, 15, 46)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 1, 23, 12, 5, 30)}} {'_id': 212369000, 'PointCount': 12, 'MinDatePoint': {'date': datetime.datetime(2016, 2, 3, 1, 34, 35)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 2, 3, 10, 53, 22)}} {'_id': 212371000, 'PointCount': 3, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 15, 4, 38, 14)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 15, 9, 58, 31)}} {'_id': 212373000, 'PointCount': 3873, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 17, 18, 23, 8)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 21, 16, 35, 29)}} {'_id': 212423000, 'PointCount': 2, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 22, 3, 48, 37)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 22, 3, 58, 48)}} {'_id': 212518000, 'PointCount': 42, 'MinDatePoint': {'date': datetime.datetime(2016, 2, 7, 15, 48, 21)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 3, 5, 11, 15, 59)}} {'_id': 212521000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 25, 21, 33, 17)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 25, 21, 33, 17)}} {'_id': 212542000, 'PointCount': 4847, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 27, 5, 33, 10)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 1, 10, 33, 54)}} {'_id': 212571000, 'PointCount': 16, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 1, 9, 39, 1)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 1, 14, 53, 54)}} {'_id': 212662000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2016, 3, 20, 7, 48, 38)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 3, 20, 7, 48, 38)}} {'_id': 212735000, 'PointCount': 19, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 2, 16, 26, 15)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 2, 16, 32, 56)}} {'_id': 212801000, 'PointCount': 3, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 5, 15, 38, 9)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 19, 2, 48, 59)}} {'_id': 212933000, 'PointCount': 4, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 1, 10, 46, 4)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 1, 12, 36, 34)}} {'_id': 215047000, 'PointCount': 47, 'MinDatePoint': {'date': datetime.datetime(2016, 1, 23, 7, 26, 39)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 1, 24, 21, 26, 53)}} {'_id': 215096000, 'PointCount': 1, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 3, 5, 48, 58)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 3, 5, 48, 58)}} {'_id': 215116000, 'PointCount': 13, 'MinDatePoint': {'date': datetime.datetime(2015, 10, 3, 23, 33, 40)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 10, 4, 2, 38, 57)}} {'_id': 215135000, 'PointCount': 264, 'MinDatePoint': {'date': datetime.datetime(2016, 3, 9, 19, 39, 38)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 3, 14, 8, 53, 41)}} {'_id': 215166000, 'PointCount': 12, 'MinDatePoint': {'date': datetime.datetime(2015, 12, 16, 20, 42, 27)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 12, 16, 21, 54, 6)}} {'_id': 215194000, 'PointCount': 12, 'MinDatePoint': {'date': datetime.datetime(2015, 11, 1, 3, 45, 18)}, 'MaxDatePoint': {'date': datetime.datetime(2015, 11, 1, 3, 47, 19)}} {'_id': 215211000, 'PointCount': 3, 'MinDatePoint': {'date': datetime.datetime(2016, 2, 21, 13, 38, 36)}, 'MaxDatePoint': {'date': datetime.datetime(2016, 2, 22, 23, 58, 58)}} Execution Time: 285.687620639801